Skip to Content
avatar image
Former Member

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

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:

KFE@MTHPRODCUST = KFA@MTHPRODCUST

KFA@MTHPRODCUST = KFE@MTHPRODCUSTM1 + KFB@MTHPRODCUST - KFC@MTHPRODCUST.

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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,

    Lingaiah

    Add comment
    10|10000 characters needed characters exceeded