
📎 This article includes 1 downloadable practice file ↓
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.
More: ALV layouts and saved views.
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.⬇ TXT · 386 B
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
Stuck on a step? Ask a question and the AI answers using this article.