Question Re: KF calculations - Price changes in Supply Chain Management Q&A

KF calculations - Price changes

d_lucas — Tue, 18 Oct 2022 15:50:16 GMT

Hi experts,

we're trying to create a KF calculation that will calculate the projected price based on an initial price and monthly raises in % as shown in the picture.

Projected price (month n) = projected price (month n-1) * (1 + Price change(n))

Does anybody know how to do this in kf calculations? we tried using IBP_LPA and IBP_PERIODSHIFT but anything seems to work.

Any advice is greatly appreciated. Thanks!

Re: KF calculations - Price changes

AyanBishnu — Tue, 18 Oct 2022 19:06:29 GMT

Hello szuffiaurre

Whether you use IBP_LPA and IBP_PERIODSHIFT or CAGGR along with, you cannot acheive the desired caluclation using standard KF expressions available. The reason behind is your calculation formula is having n dynamically calculated in 2 different inputs in the calculation. This cannot be done using KF expression as it will form a loop cycle in the calculation.I think this calculation will be a good candidate for Lcode. My suggestion would be to raise an OSS for Locde to SAP and see what they can come up with.

Re: KF calculations - Price changes

Praveen_Jadhav — Fri, 21 Oct 2022 20:28:29 GMT

Hi Lucas,

Assuming the price change is constant throughout the periods, you can use below key figures as a calculation of the projected price:

KF1: Copy the price to each bucket in future buckets.

KF2: The "Price change %" key figure in your example. (preferred this as an Attribute as KF)

KF3: Count key figure, Current bucket = 0; next month = 1; next to next month = 2 and so on.

KF4 (Projected Price) = KF1 *(1+ KF2 %)^KF3. Note: for power operator use ** instead of ^.

Please find attached the KF calculation details for reference.

Hope it helps.

Regards,

Praveen Jadhav

Re: KF calculations - Price changes

d_lucas — Wed, 07 Dec 2022 13:30:57 GMT

Hi Praveen,

thanks for your answer. This issue appeared when working for a company in Argentina where prices usually change a lot, so unfortunately the price change is not the same throughout the periods and therefore we cannot use your solution. We ended up calculating the projected price with a local member (the calculation is super simple in Excel) and then copying those values to the key figure using a macro with VBA code.

Hopefully SAP will come with a better solution in the future.

Regards,

Re: KF calculations - Price changes

former_member811144 — Tue, 13 Dec 2022 17:05:40 GMT

Hi Lucas, you mentioned you guys did use a Local Member to achieve the goal, but wouldn't a CPI do the job as easy as well?