Calday to fiscal dates

[Former Member]

hi guys i have requirement to create fiscal day ,Fiscal year week ,Fiscal week from 0calday ...i added the update routine logic in transformation... any logic solution will helpfull

[gaurav_kothari · Accepted solution]

Have you tried direct mapping with time distribution ? Does that work ?

As prerequisit you need to have 0FISCVARNT in your target.

Regards,

Gaurav

[Former Member · Accepted solution]

i didnt find the standard one for fiscal day

Fiscal year week

Fiscal week

so i created zfield for this. i want to map 0calday (standard date) to this field...any code ?

how to modify this one?

PERFORM F300_GET_ACTUAL_FISCAL_PERIOD CHANGING cal_date

CURR_PERIOD.

W_PERIOD = CURR_PERIOD.

W_MONTH = CURR_PERIOD+4(3).

W_QUOTI = W_MONTH DIV 3.

W_REMAI = W_MONTH MOD 3.

W_ZQUARTER = W_QUOTI.

IF W_REMAI > 0.

ADD 1 TO W_ZQUARTER.

ENDIF.

[Former Member]

HI

1) Use the FM DATE_GET_WEEK to convert the date to week

2) Use the FM DATE_TO_PERIOD_CONVERT to convert the date to fiscal period/month

Check this link:

Regards

Chandra Sekhar T