Skip to Content
0
Former Member
Jan 20, 2011 at 10:25 PM

ALV data to excel

213 Views

Hello Gurus please help,

We have a custom program to extract vendor performance data and show in ALV. Users want to download the data to excel and using menu option LIST/EXPORT/spread sheet. All data is exported to excel but all character data type columns are coming first and then all numeric data. We also used menu option LIST/EXPORT/LOCAL FILE/SPREAD SHEET this way the column sequence in ALV and excel are same but leading zeros in the numeric data is truncated. This data should not be trncated. Please note that in the former method leading zeroes are not truncated. So our users want to use first method and asking us maintain the column sequence as it appears in ALV.

How can we make sure that column sequence won't change during the export to excel?

We are using SAP 4.7.

Best regards,

Pavan