Skip to Content
avatar image
Former Member

Read Planning Workbook content from ABAP

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 08, 2010 at 09:36 PM

    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];

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Apr 09, 2010 at 08:27 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17, 2010 at 11:09 AM

    Not solved, no longer required.

    Add comment
    10|10000 characters needed characters exceeded