SAP Tip : How to download data from SAP to Excel

December 24, 2009 by mySAP
Filed under: SAP Tip

How to download data from SAP report to Excel

Mostly, SAP standard reports have direct download function to Excel already that can be search for the menu option or the button.
SAP Query and SAP QuickViewer are excellent tools for Downloading.
SE16N transaction also allows you to access any SAP table and download result to Excel. SAP RFC functions can be called directly from Excel / VBA (requires special authorization).
Use querySHUTTLE from Winshuttle product that extracts data from one or many SAP tables, and enforces security rules.
Process Runner also offers an easy way to find tables joins via Data Dictionary SOX compliant searchable XML look up of over 80K SAP tables and views. You can even use Excel data as a filter to limit your downloads.

Use BAPI transaction in SAP to find your business object and study the function.

If you know the SAP table the RFC RFC_READ_TABLE offers a SQL query of the table. This is only usable with single tables – joins cannot be used here. A workaround is ot create a query in the SAP database with the required joins and use the query in RFC_READ_TABLE.

There are known limitations of RFC_READ_TABLE such as total buffer width of 512 characters, older releases do not support floating point fields for extractions, short dump on incorrect where clause etc.

The Business Objects product (now acquired by SAP) offers an alternative way of querying and reporting against multiple tables in the SAP database.

Source: it.toolbox.com/wiki