Tagged Questions

1
vote
3answers
3k views

Connect a third-party application (MS Excel) with SAP R/3

I'm working out a solution for communicate MS Excel (a VBA macro) with SAP. Sometimes is too hard to reach SAP support people at any company you are working for, so it is better to figure out your own ...
1
vote
1answer
483 views

how to load sapbex.xla when the workbook opens

I open a query from SAP BW... I make all the changes I need and I even check the box that says Refresh query every time you open the workbook. The problem is that when I reopen the workbook it's just ...
1
vote
1answer
328 views

Generate XML feeds or auto export files in SAP?

Is there any way to generate automatically the result of an SAP transaction? Let's say I want to see the production orders for one MRP controller (I have the COOIS transaction for this). Is there any ...
1
vote
0answers
660 views

SAP CRM read excel file to internal table [closed]

I need a functionality to upload an excel file and store the information in DB table. Till now I`m using cl_gui_frontend_services=>gui_upload( ) to read file content. Now I need to convert the content ...
0
votes
1answer
228 views

how to select a range diagonally in excel?

Hi I have a simple question, how to select a range diagonally in excel, lets say I need to select (a3 and b1) or (a3 and b2) or simply a1 and b2 I need this range for Sap dashboard design(xcelsius) ...
0
votes
1answer
480 views

Importing an HTML table as excel file into SAP

We need to create an .xls file in asp.net which will be imported into SAP. Currently we're writing an HTML table into the response object. I'd like to know if SAP can import .xls files that are in ...
0
votes
0answers
190 views

BEx Analyzer Query - Export Excel output to CSV with VBA

I have a query on SAP Business Explorer (BExAnalyzer.exe). This program opens Excel, I select my query from "Add-Ins" and it loads the data into a new Excel worksheet. (Apparently these are xlsm ...
0
votes
1answer
267 views

Update Data With XML - xCelsius (SAP Dashboard Design)

I'm using SAP Dashboard Design 6 and I need to update the .swf with XML data. The main idea is to upload the .swf on a web server and get the data from a XML that will be updated sometimes. New rows ...
0
votes
0answers
226 views

Excel Macro after SAP Macro

So, I have an excel macro I need to run after a SAP macro is finished. The SAP macro works fine without the inclusion of the Excel macro code. I'm not sure if it is how the sub routines are called ...
0
votes
0answers
125 views

Best way to build SAP-connected web application? [closed]

I've been asked to build a "system" where users fill specific Excel formatted documents, which are then processed by a macro, which executes a SAP script that saves the SAP-user from retyping all this ...
0
votes
1answer
124 views

Automation of Excel activity on SharePoint

Here is what I need to happen, without a single user action: Data resides in a csv file on a SharePoint directory. SharePoint then loads the data file into excel and refreshes pivot tables. ...
0
votes
0answers
3k views

How can I import data from SAP Table to an Excel Sheet

I am new to Excel VBA. I dont know how to get the data from SAP table to Excel sheet. The query is. I have one excel sheet containing 10 fields. Basing on pcode field (in excel), PL will be imported ...
0
votes
1answer
688 views

Cannot pull SAP data using Excel (Permissions issue?)

I recently (today, actually) got some new permissions to some SAP tables, but I'm getting permissions issues with importing them. Here's how my process looks right now: I have an Access db that ...
-1
votes
1answer
195 views

SAP GUI loadrunner Excel document saving solution [closed]

Folks! We have a web program which calls sap application. I need to save an excel document received from SAP application. I couldn't do this while LR is in replay mode, because saving dialog doesn't ...
-6
votes
0answers
51 views

VBA Excel 2007 - SAP business objects XI [closed]

Would you happen to have a sample VBA code in excel 2007 that will automatically extract data from SAP business objects XI? Thanks.