topic Re: Date conversion in Application Development and Automation Discussions

Date conversion

Former Member — Tue, 22 Jul 2008 20:30:26 GMT

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

Re: Date conversion

Former Member — Tue, 22 Jul 2008 20:33:49 GMT

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

Re: Date conversion

former_member190578 — Tue, 22 Jul 2008 20:36:29 GMT

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

Re: Date conversion

Former Member — Tue, 22 Jul 2008 20:44:15 GMT

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.

Re: Date conversion

Former Member — Tue, 22 Jul 2008 20:52:51 GMT

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