IBP KF Calculation of Target Stock based on Periods of Coverage

[Former Member]

Hi Experts,

I'm currently trying to solve a new requirement to add a calculated KF that shows the projected safety stock (in quantity) based on a given input of future periods of coverage to maintain an the expected demand.

At first, I think the new function IBP_RAGGR would help (to aggregate key figures across several time periods, for a specified time window ), but it's currently limited on one of the parameters to be a fixed value and my requirement is for it to be variable.

Please let me know any suggestions on how to tackle this other than with a local member (as customer has been clear that as this applies across global regions, local member would not be a sustainable solution over time)

I've made this simple table to explain in detail my requirement, hope it is clear enough, the expected output is the third row " Target Safety Stock (Qty) - calculation"

Thanks!

[former_member766003]

Hi German, Could you achieve the calculation of the KF Target Safety Stock (Qty) according to the table you present?, I would appreciate your help with some information.

Best regards,

Lucas

[former_member738149]

Yes, now with Dynamic Rolling Aggregation feature it can be achieved.

Hope it works for you as well.

[lev_degtyarov · Accepted solution]

Hello,

currently SAP dev team are working on such function. it will be released in next ot may be after nex version.

There is also a workaround for custom calculations. U may need to do offset for demand KF. Then it is easy to convert days to units.

Regards,

Lev

[victorhugo_leao · Accepted solution]

Hi!

Do you know if it is already available?

Is it possible to set the target coverage days of supply to be considered in S&OP optimizer instead of SafetyStock in units?

Thanks a lot!

Best regards!

Victor Leao

[riyazahmed_ca2]

Hi German,

IBP_COVERAGE is the new function to help this problem. Review the detailed documentation here.

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/2008/en-US/c75f25cd5f184d33ae6da1b5594e...

Regards,

Riyaz

[neeraj_deshkar1]

There is no standard solution to this problem so far. However you can reach out to SAP & they will give you L code to suffice the need.

[piyush_parekh]

Hi,

Here, the duration of aggregation is dynamic in nature (target periods of supply). This will be difficult to achieve using IBP rolling aggregation function. If you can establish a max limit on target coverage (for e.g. max 6 periods) as a workaround, you can configure multiple KFs to shift data from future buckets to current bucket (using IBP_SHIFT) and aggregate them in another set of KFs. Then on the basis of user input in Target Coverage, the required KFs can be passed on to Target Safety Stock calculation KF. Refer below sample illustration.

Hope this helps!

Regards,

Piyush