How to get 0fiscper and 0fiscvarnt

[victor_yang2]

Hi, all

Does any one know how to convert Date to 0fiscper and 0fiscvarnt on R/3 side?

Thanks

[dielom · Accepted solution]

Victor,

The fiscal variant cannot be taken from a Date. You can take it from a Controlling Area. There is where you select the fiscal variant. Once you got the variant and the date, there is no need to convert it in R/3 side. You can use automatic date conversion from BW in update rules. There you can assign the fiscal variant to the corresponding infoobject and then assign the date to fiscal period. this will automatically convert the date according to the fiscal variant it was loaded.

Hope it helps.

Regards,

Diego Lombardini

[victor_yang2 · Accepted solution]

Why in business content, SAP create 0fiscper on R/3 side?

[dielom · Accepted solution]

Victor,

Thats because financials always works with Fiscal Periods, instead of natural dates.

If you still want to get fiscal period, you should check a function module to get you that information. You can try with FTI_FISCAL_YEAR_MONTH_GET.

Hope it helps.

Regards.

Diego Lombardini

[dielom · Accepted solution]

Here is another FM: GET_CURRENT_YEAR

Regards,

Diego

[victor_yang2 · Accepted solution]

Thanks.

[Former Member · Accepted solution]

Hi Victor,

Why do you want to convert the date to fiscal period in the datasource, it should be possible to do it in the update rules when you are updating the target using conversion routine PER5/PER6, don't remember the exact name. Check the BW help for details.

But when you assign the date to the Fiscal period characteristic the system automatically assigns the conversion routine for conversion provided you have the Fiscal year variant in the source.

Hope it helps.

[Former Member]

Hi Victor,

You would not convert them. basically they would be created by FI Consultant using the transaction OB29.

Bye

Dinesh

[victor_yang2]

How about I want to create generic data source, I have to convert the date to fiscper, right?