SAP How To Export To Excel Spreadsheet?
Exporting data from SAP to Excel is pretty simple. See below how to export a SAP table to Excel, or export a SAP report to Excel with a different procedure. Once the export SAP Excel has been performed, you will be able to play with the extract data from SAP with advanced vlookup in Excel, Excel string compare, count number of occurrences, and other spreadsheet standard functions.
Once in a display table transaction on a SAP system, find the arrow icon on top of the table, and click on it.
There should be an option there called Spreadsheet.
Select that option, save the file locally, and open it in Excel — the spreadsheet will actually be an Excel file, despite not being called like that directly in SAP.
Originally published at https://www.newsaperp.com on April 11, 2019.
