topic Re: downloading data into excel sheet problem in Application Development and Automation Discussions

downloading data into excel sheet problem

Former Member — Fri, 02 Nov 2007 07:31:00 GMT

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 — Fri, 02 Nov 2007 07:33:58 GMT

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 — Fri, 02 Nov 2007 09:01:27 GMT

hi atish

i tried as you said , still problem not solved.

is there any solution please let me know.

Former Member — Fri, 02 Nov 2007 09:10:53 GMT

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 — Fri, 02 Nov 2007 10:36:33 GMT

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

SEARCH FOR....CONVERSION_* FMs

~Sid

Message was edited by:

Sid