Read Planning Workbook content from ABAP
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.