Derive Fiscal Period based on start and end date.

[Former Member]

Can we derive Fiscal period based on Start and End Date in transformations , instead of Posting date or Created on Date?

[Former Member]

Hi Manasvi,

Where do u want to do this derivation transformation level or query level.

In transformation level you can achieve this by writing a formula or an abap code.

In query level to derive the same, you will have to create an exitvariable/badi.

Reg,

Rahul

[Former Member]

Hi Guys,

Thanks for your replies. my question is how to derive fiscal periods based on a range (start and end dates) not based on one date.

I did not find any standard function/formula in transformations to derive fiscal periods based on 2 dates ( start and end dates)

Thanks!

[Former Member]

Yes you can derive fiscal year/period using the standard Function module "DATE_TO_PERIOD_CONVERT".

If you input date and fiscal year variant to the above mentioned function module, you will get posting period and fiscal year as output.

--- Thanks...