Leading ZERO?

[Former Member]

Hi,

I need to export LQUA-WERKS to excel..

But when exported I mis leading zeros?

40 need to be exported in excel 0040 ?

tnx,

Adibo.

[Former Member]

How r u exporting it?

If you r using some internal table then it will take data in the format present in internal table.

If you r exporting it from ALV, it will take as it is displayed in ALV.

So, in both cases, adjust your internal table data and then export.

G@urav.

[Former Member]

I am exporting it from internal table..

[Former Member]

adjust that column data in internal table to whatever format you want it to appear in EXCEL.

G@urav.

[Former Member]

TYPES:  BEGIN OF ls_lqua,
            werks TYPE lqua-werks,
            matnr TYPE lqua-matnr,
            gesme TYPE lqua-gesme,
            meins TYPE lqua-meins,
            letyp TYPE lqua-letyp,
            lgtyp TYPE lqua-lgtyp,
            lgpla TYPE lqua-lgpla,
        END OF ls_lqua.
DATA: lt_lqua TYPE STANDARD TABLE OF ls_lqua,
      wa_lqua TYPE ls_lqua.

when I set breakpoint to see format of lt_lqua-werks, it is shown as 0040..but when exported 40 ?? strange

[Former Member]

Do we have checked options and settings in Excel?

I think there should be some setting in Excel.

It must be giving 0040 when you download it into text file.

G@urav.

[Former Member]

Hi

It depends on excel, not SAP.

As the code of plant is a number, excel manage the field as it was a numeric field, so it's deleting the leading zero.

Before opening the file u should set the colunm for WERKS as TEXT field.

Max

[Former Member]

Always best method would be........

through se16 download the data into text file then take out the header, open the blank excell sheet then open your text file in this excell. While opening the this file it will give you differnet options go with delimitor then in the next screen give the another '|' as the delimitor and with shift select all the columns in the below window go with next option

in the next screen select the text radio button and finish.... thats it u will get all the fields with leading zeros if exists in the original list.

[Former Member]

use the FM :

CONVERSION_EXIT_ALPHA_INPUT

this convert ure values or example a char(4) if u have a valu = 3, this function return = 0003

OR

CONVERSION_EXIT_ALPHA_OUTPUT

this quit the zeros example if u have a 0000056, only return 56

[Former Member]

Hello Adibo,

Simplest way to achieve this is like below:

CONCATENATE ''''' LQUA-WERKS INTO lv_werks.

Here you are concatenating single colon ( ' ) with your plant number and moving it to char type variable.

Now when you use this variable to download into XL, It will show appending Zeros and it will not show your appended single colon.

This surely works..

<REMOVED BY MODERATOR>

thnx,

ags

Edited by: Alvaro Tejada Galindo on Jun 12, 2008 6:59 PM

[Former Member]

Hi,

Not one solution has helped..But I solved it like this:

I exported file in TXT. Then when opening with excel chose option to change column WERKS as text!

[Former Member]

Hi Adibo, Can you please explain me how you solved this issue. PLease share this with me.

[Former Member]

Hi @CN,

I just exported lt_lqua as TXT file, that was enough..

When opening this file in EXCEL you can define werks column as TEXT, so leading zeros won't be deleted..