You could always create a scope of list that uses the ALV format. The resulting list display is very good to download to Excel. The other is dreadful.
You can configure this in the IMG under MM, Purchasing, Reporting, Maintain purchasing lists, Scope of list, Define scope of list. In your config, be sure to select the “Use ALV grid control” under Settings for ALV grid control.
Also, Please use the Scope of list ALV and then execute this transaction(fs10n).
To export a report from SAP, follow these general steps:
1.Open the SAP report you want to export.
2.Run the report by entering the selection criteria and clicking the Execute button.
3.Once the report has finished executing, click on the Export button, which is usually located on the toolbar at the top of the screen.
4.Select the format you want to export the report in (e.g., Excel, PDF, CSV, etc.). The available export formats may vary depending on the report and the SAP system version.
5.Choose a location to save the exported file and give it a name.
6.Click Save to export the report.
Note that the exact steps may vary slightly depending on the SAP system version and the report you are exporting. Additionally, some reports may have restrictions on exporting data, so it’s important to check with your SAP administrator or IT department to ensure that you have the necessary permissions to export the report.