downloading data into excel sheet problem

Former Member · ‎2007 Nov 02

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 · ‎2007 Nov 02

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 · ‎2007 Nov 02

hi atish

i tried as you said , still problem not solved.

is there any solution please let me know.

Former Member · ‎2007 Nov 02

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 · ‎2007 Nov 02

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

SEARCH FOR....CONVERSION_* FMs

~Sid

Message was edited by:

Sid