Variables for Fiscal year YTD, MTD and Quarter to data

[Former Member]

Hello Gurus,

I have a fiscal year that runs from September to August. Is it possible to create a customer exit variable for Fiscal year YTD, fiscal year MTD and fiscal year QTD (quarter to date) based on sy-datum and not though user entry.

If yes, then how should I restrict my key figures so that the user don't have to enter any date and the varaibles derive the data based on sy-datum.

Looking forward to your expert advices

Thanks,

Rishi

[Former Member · Accepted solution]

Hi Rishi,

I understand your query some extent,You can create Characteristic varaible with processing type Customer exit for fiscal year MTD and fiscal year QTD (quarter to date) based on sy-datum.

If you want to see fiscal year MTD and fiscal year QTD values in the column level, you have to create Text variable with replacememnt path.

Do as follows.

1) Create Characteristic varaiable with processing type Customer exit. Search for required code in the SDN.

2) Create the restricted keyfigure on required keyfigure. Restrict it on fiscal year MTD and fiscal year QTD with Char variable to enter year value.

3)After maintaining the restricted keyfigure (In the same step ) Create a text variable to get the value populated with the year specified with the processing type Replacement path with characteristic Fiscalyear.

I hope above steps definetely help full for you.

If any case you need help let me know.

Thanks,

Chandu.

[Former Member]

Hi,

Take a look at the How to Guide for YTD and MTD reporting.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/25d98cf6-0d01-0010-0e9b-edcd4597...

Regards,