Q
Problem solve Get help with specific problems with your technologies, process and projects.

Saving multiple reports in spreadsheet format

I download numerous reports every month from SAP - e.g. profit + loss; budget comparisons - into Excel. The only...

reason for this is that I have to "pretty up" the data before it goes out to management. Is there a way to call SAP, get it to run the reports & save them on the hard drive in spreadsheet format, without having to run them individually. This is timeconsuming & tiring. Please help! Note: I am quite good with VB, but hopeless with BAPI...


If the data that you need is contained in the SAP Information Structures (the basis for a lot of SAP reporting), then you can use the BAPIs of object type OpenInformationWarehouse to retrieve the data from a client program.


This was last published in June 2002

Dig Deeper on SAPscript and Smart Forms

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close