How to Save ALV Grid Output to Excel/Local file

How to Save ALV Grid Output to Excel/Local file

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

SAPGUI-saveALVGrid1 (1)

Step 2: Select "Local File"

SAPGUI-saveALVGrid1 (2)

Step 3:  Select Spreadsheet

SAPGUI-saveALVGrid1 (3)

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

SAPGUI-saveALVGrid1 (4)

 

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: SAPGUI-saveALVGrid1 (5)

 

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

 

 

Next

SAP System list does not match