Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Export file to local drive with sorting and totals in ALV

Former Member
0 Kudos


I have a requirement to save the ALV report in excel format. I know this is the starndard functionalilty, but when i save sorting, total, sub total information is lost. How to export the ALV with the user selected layout to excel format..

Any suggestions...


Message was edited by:

Sal Khan


Former Member
0 Kudos

check this blog:

Thanks and regards,

Former Member
0 Kudos


First Sort the records in your internal table. Then try to download.

( or )

The ALV layout has the option to sort and also to calculate and display the total, select those options in the layout and generate ur ALV report. Then u try to download.


0 Kudos


I have exactly the same problem with my ALV-list....

I define my own layout, but when I make the download to excel, the defined layout is lost (all character rows are at the left, all numeric rows are on the right side in my excel-download)

thanks for any suggestion