11-02-2007 7:38 AM
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
11-02-2007 7:51 AM
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
11-02-2007 8:55 AM
Hi donald
thanks for your reply,
please can you tell me is there any command or method available in ABAP to do the same.
11-02-2007 10:30 AM
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.
11-02-2007 9:11 AM
Hi,
Move the content to CHAR format so that you will get the value whatever you required...
Thanks
Yogesh
11-02-2007 9:24 AM
Already answered this in your question in other forum
Regards
Nishant