problem in data downlaod to excel

[Former Member]

Hi friends

we have interface requirement to download vendor master data to excel sheet.

here in excel sheet vendor number is storting as without zeros( '1212').

we want to excel sheet cell should contains vendor number with zeros (0000001212).

example

vendor number in sap: 0000001212

we want to download vendor number in excel sheet cell as '0000001212'.

Is there any command or method in ABAP to instruct excel to store vendor number with padding zeros.

i would appreciate for your qucik response.

Thnaks

Ramesh

[former_member189059]

If you can append an apostrophe to the Vendor Number, excel will show the zeros and not the apostrophe in the sheet

You must also take care to ensure that your itab's field can contain one character more than originally

[Former Member]

Hi donald

thanks for your reply,

please can you tell me is there any command or method available in ABAP to do the same.

[former_member189059]

Hi,

First change your LIFNR declaration to char(11).

then use the following

Loop at itab.
 concatenate '''' itab-lifnr into itab-lifnr.
 modify itab.
endloop.

[Former Member]

Hi,

Move the content to CHAR format so that you will get the value whatever you required...

Thanks

Yogesh

[Former Member]

Already answered this in your question in other forum

Regards

Nishant