‎2006 Aug 29 1:51 PM
I want to convert calendar month to a fiscal period, calendar year to a fiscal year, ( vice versa given a fiscal period how to find calendar month and given fiscal year the calendar year).
Please note that in both cases I will have the fiscal variant as well.
Please Help
Regards
‎2006 Aug 29 3:18 PM
It depends on how the fiscal periods are defined.
If the fiscal period begin the first day of the month and end the last day you could use the following fms...
DATE_TO_PERIOD_CONVERT -> given a date it returns the fiscal period...
PERIOD_DAY_DETERMINE -> given a fiscal period it returs start and end date.
(check OB37 for the Fiscal year variant)
If the fiscal period are defined across months (e.g. 2003.01 starts 23.09.2002 and ends 20.10.2002) It won't work...
Reward Helpful
Regards
‎2006 Aug 29 1:59 PM
hi,
1) FTI_FISCAL_YEAR_MONTH_GET
2) G_POSTING_DATE_OF_PERIOD_GET
Message was edited by: Andreas Mann
‎2006 Aug 29 3:18 PM
It depends on how the fiscal periods are defined.
If the fiscal period begin the first day of the month and end the last day you could use the following fms...
DATE_TO_PERIOD_CONVERT -> given a date it returns the fiscal period...
PERIOD_DAY_DETERMINE -> given a fiscal period it returs start and end date.
(check OB37 for the Fiscal year variant)
If the fiscal period are defined across months (e.g. 2003.01 starts 23.09.2002 and ends 20.10.2002) It won't work...
Reward Helpful
Regards