Skip to Content

Use previous month value of a key figure calculating the same key figure value for current month

Sep 26, 2017 at 11:30 AM


avatar image

Dear SAP,

I have an issue and I´d appreciate any help on this subject.

I need to use previous month value of a key figure to calculate current month in rolling horizon.

Let´s say that I have KFA, KFB, KFC and KFD, all in base planning level MTHPRODCUST.

For month 0 the KFA should receive the value of KFD.

For months 1 on we should have the following calculation:

KFA = KFA (m-1) + KFB - KFC

Similar to stock balance macro of SAP APO SNP.

I tried using offset of KFA in a KFE:



When trying to activate the planning área I receive the following error:

E - Cycle found in the key figure calculation chain.

After raising na oss message about this I´ve been advised to ask for a L-Code that could control the cycle reference.

Even after SAP developed the L-Code I´m still having the cycle reference.

Do you have any idea on how to avoid this cycle and attend the business requirement?

Thanks and Regards

André Val

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lingaiah Vanam Sep 26, 2017 at 02:06 PM

Hi Andre,

The first step doesn't go with the complete solution.

Breakdown the key figure calculations into another key figure and input to main key figure. Provide the complete scenario details to SAP they will provide the solution or send me the scenario with simple example in excel.

Best Regards,


10 |10000 characters needed characters left characters exceeded