Read Planning Workbook content from ABAP

[Former Member]

Hi guys,

This is really a complex query that I bring to the table and might be quite hard to be solved.

I have a table with a lot of values in the planning workbook like workbook name, user and different other stuff.

These need to be brought to BW. Unfortunately, I understood this isn't possible via a query or something else, so I'm looking for ways in which I can:

a) Use the ABAP variable exit coding so that I can read the cells directly from the workbook

b) Use VBA and call sapbex.xla or BexAnalyzer.xla methods so that I can call my own ABAP functions or at least make the values from these cells available in BW.

I require all this info when the user saves the workbook.

Any help would be highly appreciated and don't hesitate to ask for clarifications if you find my description confusing.

Best regards,

George

[Former Member · Accepted solution]

Hi.

If I understand you right you have any worksheet with any data enterd by user.

This data NOT RELATED to any infoobject - I mean this data entered in excel cells without relation to BW (like regular working with excel sheet).

You want add this data to BW.

Am I right ?

Regards.

[Uryukin Andrey|http://il.linkedin.com/in/andreyuryukin]

SAP-BI Consultant, [Advantech|http://advantech.co.il/en/index.asp]

[My Blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/252016769] [original link is broken] [original link is broken];

[Former Member · Accepted solution]

Hi Andrey,

1)Yes, you're right.

2) RFC might work, but only if I do not open a new RFC connection to the system (this is seen as a BAAAD thing by the business, risky and stuff), but use the actual one that Bex is using. Now I'm still investigating how to get the actual connection.

Rgds,

George

[Former Member]

Not solved, no longer required.

[Former Member]

Hi,

why do you need this information in the backend? What happens when you re-open the workbook? Do you need to load it again from the backend to the frontend or do just need to overwrite the information you have stored in the backend?

There are possibililties to create z-function modules (RFC) and to call them from the BExAnalyzer. Did you already check this? Please try searching for "Excel SAP RFC site:help.sap.com" e.g. using google to find more information about this topic.

Regards Matthias