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

[Former Member]

Hi,

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

Narayana

[Former Member]

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

[Former Member]

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]

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.

endloop.

call FM to download to excel ...

endcase.

endform.

Hopw this works ...