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: 

Not to remove leading zeros while downloading from ALV grid to a spreadshee

Former Member
0 Kudos


I have an issue.

When i am trying to download a ALV report to a spread sheet, I am not able to get the leading zeros in the spread sheet.

when i prepend with ( ' ) to the field, It's displaying ( ' ) in the ALV output and spread sheet with leading zeros. But i don't want to display ( ' ) i the output.

Please suggest me how can i solve this issue.

Thanks & Regards



Former Member
0 Kudos

you can add some '_' (underscore) before it?? it wont display those __s


Former Member
0 Kudos

you can add some '_' (underscore) before it?? it wont display those __s

Former Member
0 Kudos

Search in , SAP market place for SAP Note with Excel with missing leading zeros.

Hope you get some help.

Edited by: harsh bhalla on Sep 8, 2009 8:52 PM

Former Member
0 Kudos

Do not concatenate ' while showing output in ALV ,

instead concatenate ' to the field which U need to show with leading zeros while downloading to excel ...

form user_command.

case sy-ucomm.

when 'DWLD'.

loop at it_final.

concatenate '''' it_final-field1 into it_final1-field1.

......... " fill all the fields which needs leading zeros

append it_final1.


call FM to download to excel ...



Hopw this works ...