Calculate AOP QTY from AOP Rev in SAP IBP

[sureshkumar_vaniyasekar]

Dear Experts,

I have a requirement that AOP quantity (Key Figure: AOPQTY) has to be calculated from AOP Revenue (Keyfigure: AOPREV).

AOP Qty = AOP Revenue / planned price per SKU.

Since I don't want to modify the standard key figure AOPQTY, I created a new key figure AOPQTYFRREV as stored key figure.

Below is the logic which I needed.

AOPQTYFRREV@MTHPRODCUST = AOPREV@MTHPRODCUSTCURR / PLANNEDPRICE@WKPRODCUSTCURR

Then I will copy the AOPQTYFRREV to AOPQTY using copy operator.

I did the below key figure calculation at AOPQTYFRREV,

But it is not working. Please help me to solve this issue.

Since I am new to key figure calculation, my logic might be wrong.

Thanks in advance!

Best regards,

SureshKumar

[revanchatraban · Accepted solution]

Hi Suresh,

Follow the steps below.

1. Add the below calculation to the KF Planned price

PLANNEDPRICE@MTHPRODCUSTCURR = AVG(PLANNEDPRICE@WKPRODCUSTCURR)

2. Add the below calculation to the KF AOPQTYFRREV

AOPQTYFRREV@REQUEST = SUM("AOPQTYFRREV@MTHPRODCUSTUOMTO")

AOPQTYFRREV@MTHPRODCUSTUOMTO = UOMCONVERSION@PRODUOMTO * AOPQTYFREV@MTHPRODCUST

AOPQTYFREV@MTHPRODCUST = SUM(AOPQTYFREV@MTHPRODCUSTCURR)

AOPQTYFREV@MTHPRODCUSTCURR = AOPREV@MTHPRODCUSTCURR(Stored Input) / PLANNEDPRICE@MTHPROCUSTCURR(Calculated Input)

Thanks and Regards,

Revan C