Calmonth Offset Problem

[Former Member]

Hi Experts,

I have a report where users enter Calmonth Interval as a selection . For eg . if User gives selection 01.2007 to 03.2007 . Then report Output should be

Material PLant Calmonth Amount-opening Amount-Closing

M1 P1 01.2007 Amount(12.2006) Amount(01.2007)

M1 P1 02.2007 Amount(01.2007) Amount(02.2007)

M1 P1 03.2007 Amount(02.2007) Amount(03.2007)

I have created two RKF's named Amount Closing and Amount-opening . But Problem is I have PLaced Calmonth Variable - 1 in the RKF Amount Opening . THis Figure is not getting calculated correctly and both Opening and Closing is showing the same vales except for the last month ( in this eg . 03.2007 ) .

Regards,

Vijay.

[Former Member · Accepted solution]

Hello ,

Can you please run T-code RSRT and let me know what is the value showing for the Offset variable??

Note: See that u have not ristricted any time infoobjects in Filter areas...!

--> EnjoySAP

[Former Member]

Hi Vijay,

You cannot use offset for Section option. It should be type "Single entry Value only".

Regards

Ajay

[Former Member]

Hi Vijay,

If the user you would like to see only 3 month or data.

Then Create 3 Restricted Key figures and restrict them using offser as per you logic. But Remeber you can use only single entry variable

hope this helps you

Regards

Ajay

[Former Member]

Hi,

User Selection is not constant ...I mean user can give any Range .

Experts any views on it .......

Regards,

Vijay.

[former_member184494]

Vijay,

Going by your definition :

M1 P1 01.2007 Amount(12.2006) Amount(01.2007)

M1 P1 02.2007 Amount(01.2007) Amount(02.2007)

M1 P1 03.2007 Amount(02.2007) Amount(03.2007)

Here once you have 01.2007 - even if you have an RKF or an exit - you cannot get data for 12.2006 ... hence by normal methods , or by using an exit - this would not be achievable. The reasons being that you have a filter of 01.2007 on the row and within it you want to fetch the value for 12.2006 -

An option to try could be using a Virtual KF...

Or try and define the number of columns and proceed with RKFs...

Arun