Question Re: IBP KF Calculation of Target Stock based on Periods of Coverage in Supply Chain Management Q&A

IBP KF Calculation of Target Stock based on Periods of Coverage

Former Member — Wed, 02 Sep 2020 01:54:26 GMT

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!

Re: IBP KF Calculation of Target Stock based on Periods of Coverage

piyush_parekh — Wed, 02 Sep 2020 03:01:35 GMT

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

Re: IBP KF Calculation of Target Stock based on Periods of Coverage

neeraj_deshkar1 — Thu, 03 Sep 2020 19:23:09 GMT

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.

Re: IBP KF Calculation of Target Stock based on Periods of Coverage

riyazahmed_ca2 — Sat, 05 Sep 2020 07:32:52 GMT

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/c75f25cd5f184d33ae6da1b5594e4f2f.html

Regards,

Riyaz

Re: IBP KF Calculation of Target Stock based on Periods of Coverage

lev_degtyarov — Thu, 17 Sep 2020 14:58:38 GMT

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

Re: IBP KF Calculation of Target Stock based on Periods of Coverage

victorhugo_leao — Fri, 05 Mar 2021 14:19:48 GMT

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

Re: IBP KF Calculation of Target Stock based on Periods of Coverage

former_member766003 — Sat, 14 Aug 2021 16:31:23 GMT

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

Re: IBP KF Calculation of Target Stock based on Periods of Coverage

former_member738149 — Mon, 16 Aug 2021 10:23:53 GMT

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

Hope it works for you as well.