How to export SAP R/3 Data to Microsoft Excel
Microsoft Excel provides a user-friendly format and helpful tools to assist you in the process of analyzing and presenting data. To get your SAP data into Microsoft Excel, you can employ several methods. The most basic method involves the System List function, which enables you to save lists displayed on your SAP screen.
You can also use the SAP Query tool to export data to Microsoft Excel, as follows:
1. Execute an SAP Query, as discussed in Hour 20, “Reporting Tools in SAP (SAP Query, InfoSet Query, Ad Hoc Query, and QuickViewer).”
2. The options listed on the selection screen enable you to designate the type of output you want for your report. For a basic transfer to a Microsoft Excel spreadsheet, select the Display As Table radio button.
3. From here, select the List, Save, Local File to download this table into Microsoft Excel. A Save As box appears, enabling you to select the download file format. Be sure to select the spreadsheet option.
4. After the download is complete, start Microsoft Excel and open the data you have just saved
5. Return to your SAP Query output screen displaying your table.
By the Way
If you want to save your downloaded SAP list in Microsoft Excel, be sure to select File, Save As and then select the Microsoft Excel Workbook (*.xls) option in the Save As type box or your spreadsheet; otherwise, by default, it is saved in a text format.
Popularity: 12% [?]
