Date conversion

[Former Member]

dear all,

i have a field coming in from R/3 which is KMONTH datatype NUMC(6) and i want to map it to 0FISCPER datatype NUMC(7)

my data format is 200802 (YEAR/MONTH) and i want to convert it to e.g. 2008002 or 2008011 (YEAR/MONTH)

how can this be done? thanks

[Former Member]

Hi,

Check this code..

data: v_input(6) value '200802'.
data: v_output(7).
data: v_numc(3) type n.

* Put leading zero.
v_numc = v_input+4(2).

* Concatenate the output.
concatenate v_input(4) v_numc into v_output.

write: / v_output.

Thanks

Naren

[former_member190578]

Try this....

Move: KMONTH(4)   to OFISCPER(4),
      KMONTH+4(2) to OFISCPER+5(2). 

Edited by: Jürgen Hartwig on Jul 22, 2008 10:36 PM

[Former Member]

i wish i can assign problem solve for everyone. thanks. it did help!

[Former Member]

Check this sample

REPORT  Y_TEST.

data: year6(6) type n,
        year7(7) type n.


        year6 = '200802'.

        year7+0(4) = year6+0(4).
        year7+5(2) = year6+4(2).
        write year7.