downloading data into excel sheet problem

[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 in ABAP to instruct excel to store vendor number with padding zeros.

i would appreciate for your qucik response.

Thnaks

Ramesh

[Former Member]

Hi Ramesh,

Can you try by defining a field in the internal table which store vendor number as NUMC and see the result.

Regards,

Atish

[Former Member]

hi atish

i tried as you said , still problem not solved.

is there any solution please let me know.

[Former Member]

Hey,

I have just tried this.

this will work if instead of NUMC you give it as CHAR.

This worked for me.

Regards

Nishant

[Former Member]

try using the conversion routine first...or declare the itab components like DDIC fields...

SEARCH FOR....CONVERSION_* FMs

~Sid

Message was edited by:

Sid