on 04-30-2007 5:27 AM
Hi,
I am using 2LIS_01_S001. I've migrated the datasource and creating Transformation.
While creating transformation would like to know how do we calcuate the time dimension like calmonth, calyear etc. Have we to write our own routine to doit.
We have Fiscalyear variant as contant to K4 and i want to change it to V3 but enable to do so.
Sachin K
Hi,
the first is to keep the fiscal variant as the one used in R/3.
And yes you'll have to write your routines:
"0CALMONTH
IF COMM_STRUCTURE-FISCPER+4(3) GT '012'.
CONCATENATE COMM_STRUCTURE-FISCPER(4) '12' INTO RESULT.
"this depends on your req on how to manage the extra 4 period with K4...
ELSE.
CONCATENATE
COMM_STRUCTURE-FISCPER(4)
COMM_STRUCTURE-FISCPER+5(2)
INTO RESULT.
ENDIF.
"0CALYEAR
RESULT = COMM_STRUCTURE-FISCPER(4)
hope this helps...
Olivier.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.