Restriction on Restricted Key Figures according to Years

[Former Member]

Hi,

If i have a restricted Key Figure based on some Document Type then how can we Restrict this RKF year wise in such a way that it displays the data for all the previous years and also for the current years in different RKF.

[Former Member]

Apologies misunderstood.

Take your RKF and just add in the 0FISCYEAR object.

Then restrict this value to a variable 0FYEAR (this is SAP standard one for Current).

To get the previous year then just use the offset function in the restriction to get -1 year.

Ian

[Former Member]

forgot to add this.

If you set the restriction as a value range then you can set the variable from 0 to -1 in the offset and you will get 2 years of data in the one RKF.

Ian

[Former Member]

But what i wanted to know is that HOW to Restrict this RKF on the basis of the Fiscal year so that i can get the data for all the previous years as well as for the current year in the separate Key Figure.

Can you guide me the procedure.

thanks

msh

[Former Member]

or you may want to further restrict the RKF's in the query.

Or think about creating a structure that has a this yr and last yr restriction. Then you can re-use this in multiple queries and do not need lots of RKF's.

Ian

[Former Member]

you can create multiple RKF which are restricted on document type and year.