Most SAP reports display in an ALV grid, a list you can rearrange like a mini Excel. Set it up once, save the layout, and export cleanly.
Arrange the list
Change layout (Ctrl+F8): add, remove and reorder columns.
Sort and Filter buttons on the toolbar.
Select an amount column and click Σ (Total), then sort by vendor and use Subtotal.
Save layouts
Save layout: name starting with / (shared, if your authorisation allows) or without (personal). Tick Default setting to open the report with it every time.
Export to Excel
Use List › Export › Spreadsheet or the export icon, choose Excel (XLSX). Avoid “local file › unconverted”: it creates text that breaks numbers and dates.
💡 If amounts arrive in Excel as text (left-aligned, with a trailing minus like 1.234,56-), check your SAP user’s decimal notation (SU3 > Defaults) and use Data > Text to Columns to fix existing files.
Transaction codes and menus are standard SAP ECC/S4HANA examples; your company may have custom codes, restricted authorisations or a different layout. Practise in a training or quality system.
Practice
Follow the checklist on a report you use daily.
📎 Practice files for this article
📄
Lesson 4 checklistStep-by-step exercises for this lesson.
