Question Re: SAP IBP Calculating current week and aggregating it to next wekk in Supply Chain Management Q&A

SAP IBP Calculating current week and aggregating it to next wekk

snlak — Mon, 16 Oct 2023 18:18:05 GMT

WE have a requirement were in the current week to be displayed as 0 and next week as 1 and second week as 2 and so on

How do we achieve this in SAP IBP through key figure

Re: SAP IBP Calculating current week and aggregating it to next wekk

Irmi_Kuntze — Tue, 17 Oct 2023 05:31:11 GMT

Hey Sravanthi

Check the Configuration guide: Using Time Periods in Key Figure Calculations :

You could have a Helper KF1 with calculated value IF(PERIODIDn <= $$PERIODIDnCU$$, 0, 1) and add an additional KF as input on the same planning level.
If your time profile provides Y, Q, M, CalWK, TW and D, and your calculation should be on Calendar Weeks, then n would be 4 and PERIODID4 <= $$PERIODID4CU$$

Then you have according to Cumulative Aggregation:

KF@CALWKxxx = IBP_CAGGR(KF1@CALWKxxx, ,''SUM'',''FORWARD'',''CURRENTFUTURE'')

Good Luck, Irmi

Re: SAP IBP Calculating current week and aggregating it to next wekk

snlak — Tue, 17 Oct 2023 15:06:40 GMT

Thank you for the response ,I have tried to apply the above logic but its getting errored out

"The key figure can't have the same calculation more than once"

IBP_CAGGR("ZCURRENTSAPWEEKS@CALWKPRODLOC" ,''SUM'',''FORWARD'',''CURRENTFUTURE'',10)

Re: SAP IBP Calculating current week and aggregating it to next wekk

Irmi_Kuntze — Thu, 19 Oct 2023 10:34:13 GMT

Why the 10 at the end? A normal time profile is only going up to 5, 10 usually does not exist. The Parameter is optional. Do you get the error message as well if you leave it out?

The error message sounds as if you have for the same KF two calculations at the same planning level. Are you really working with 2 different KF as described? Cannot work in one step

Re: SAP IBP Calculating current week and aggregating it to next wekk

snlak — Thu, 19 Oct 2023 11:44:43 GMT

Thank you for responding!!

I am getting the error message even when I have not given the parameter and yes its 2 diff Key figures only i have tried out

Re: SAP IBP Calculating current week and aggregating it to next wekk

piyush_parekh — Thu, 19 Oct 2023 19:33:14 GMT

Hi Sravanthi,

You can also try below

Define a key figure KF1 as : if periodid = current period id then 0 else 1 (give input as any stored key figure same as that of base planning level of this KF1) and another key figure KF2 as : IBP_CAGGR ( KF1, SUM, FORWARD, CURRENT FUTURE) KF2 should reflect what you're looking for.

Please refer the correct syntax from IBP model configuration guide.

Regards,

Piyush

Re: SAP IBP Calculating current week and aggregating it to next wekk

Irmi_Kuntze — Thu, 19 Oct 2023 20:08:00 GMT

Hey Sravanthi

Without having a look into the system, I dont know how to find the error. So you could open an OSS ticket

And bye the way, what Piyush has written is exactly the same approach as described by me.

Yours

Irmi