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 DB. 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

clip0041

Step 2: Select "Local File" or "System" -> "List" -> "Save" -> "Local File"

clip0042

Step 3:  Select Spreadsheet

clip0043

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

clip0044

 

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: clip0045

 

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

 

 

Next:

How to Export Report Output to Excel