formula fiscal year to fiscal year period

[madanmohan_madala3]

Hi

I need to convert fiscal year to fiscal year period.

what formula i need to use.

Regards
Mohan

[MGrob · Accepted solution]

Hi

You can't convert fiscalyear into fiscalyear/period only the other way around.

SUBSTRING(0FISCPER,0,4) in a transformation would give you the year from fiscalperiod

hope it clarifies

Martin

[anilkumar_kalkivai]

Hi,

Try Below links

http://www.sapdev.co.uk/fmodules/fms_fiscalyr.htm

http://scn.sap.com/thread/827282

Regards,

Anil.

[KamalMehta]

Check if you can use FM DATE_TO_PERIOD_CONVERT .

Input parameter : Fiscal year variant and SY-DATUM.

Output parameter : Fiscal year period.

Thanks

[RamanKorrapati]

Hi Madan,

From Fiscal year(4 digits) to Fiscal period(7digits) never possible. If you have any other date field along with fiscal year then based on that you can get period and club to fiscal year Look for any other date field(month or day dates) was existing at your data source then with help of abap you can achieve.

Thanks

[anshu_lilhori]

Hi,

As mentioned by Martin...You cannot get fiscal year period from fiscal year.

If you have some other requirement where you need to hard code or something like that.

Please share and confirm.

Regards,

AL