How to Save ALV Grid Output to Excel/Local file

 Previous  Home  Next

Start GUI Scripting recording from Process Runner. Execute your transaction and reach to a screen where report is displayed in ALV Grid.

Step 1: Once you are in ALV Grid Report, click on side first icon to expand list of ALV buttons

SAP_GUI-HT-Save_ALV-

Step 2: Select "Local File"

SAP_GUI-HT-Save_ALV-1

Step 3:  Select Spreadsheet

SAP_GUI-HT-Save_ALV-.2

Step 4:  Provide filename and click Replace (this will always overwrite the file without any additional prompts)

SAP_GUI-HT-Save_ALV-.3

 

Note: If you see a different "windows" style Save file dialogue, download operation may not work when you actually play back the recording. Applying OSS notes might resolve this issue.

 

Status bar should say something similar: SAP_GUI-HT-Save_ALV-4

 

You can stop Recording in GUI Scripting Wizard at this point.

 

 

Next:

SAP System list does not match