topic Re: Leading zeros. in Application Development and Automation Discussions

Leading zeros.

Former Member — Wed, 11 Jun 2008 11:59:12 GMT

Hi,

Can any one please tell me how we will add leading zeros to a field.

I was declared the field field(10) type c, in internal table.

Now i upload the data from flat file to IT.

in flat file the value is '1254367'

Now for this field i want to add leading zeros.

Thanks in advance.

Re: Leading zeros.

kesavadas_thekkillath — Wed, 11 Jun 2008 11:59:48 GMT

use Fm conversion_exit_alpha_input

Re: Leading zeros.

prasanth_kasturi — Wed, 11 Jun 2008 12:00:33 GMT

Hi,

insted of char take it as numc.

data : field(10) type n.

or use the function module 'CONVERSION_EXIT_ALPHA_INPUT'

data : field(10) value '12345'.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = field

IMPORTING

OUTPUT = field.

write : field.

regards

prasanth

Re: Leading zeros.

Former Member — Wed, 11 Jun 2008 12:01:30 GMT

Declare it like this

field field(10) type N

Ankesh

Re: Leading zeros.

Former Member — Wed, 11 Jun 2008 12:01:43 GMT

Hi,

Please use FM CONVERSION_EXIT_ALPHA_INPUT to add leading zero's to the field.

Thanks,

Sriram Ponna.

Re: Leading zeros.

Former Member — Wed, 11 Jun 2008 12:04:18 GMT

Hi,

use the FM "CONVERSION_EXIT_ALPHA_INPUT".

loop at itab.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = itab-fldname

IMPORTING

OUTPUT = itab-fldname

modify itab.

endloop.

After this your internal table will have values appended with zeros.

Regards,

Yellappa.

Re: Leading zeros.

Former Member — Wed, 11 Jun 2008 12:08:13 GMT

hii

you can use

ls_data-matnr = ls_excel-value.
        w_matnr    = ls_data-matnr.
        CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
          EXPORTING
            input  = w_matnr
          IMPORTING
            output = w_matnr.

        ls_data-matnr  = w_matnr.

thx

twinkal

Re: Leading zeros.

Former Member — Wed, 11 Jun 2008 12:25:27 GMT

hi PB,

catch d value in a local char10 variable. then check its length with strlen. if value is 1234567 den length will b 7. den concatenate '000' local var into internal table field.

hope ur problem is resolved.

plz assign points if it is helpful.

rgds,

Avijit

Re: Leading zeros.

Former Member — Wed, 11 Jun 2008 12:32:06 GMT

Hi,

goto the domain of the field you are using, check if there is any conversion exit, use appropriate conversion_exit_XXXX_input

to convert into internal format.

Thanks,

Keerthi.