Calculation for Pipeline Stock (Target) SAP IBP for Inventory

[former_member623960]

Hello Experts,

I am trying to understand/validate how the Pipeline Stock (Target) key figure is calculated in IBP. The key figure is an output of the Calculate Target Inventory Components Operator. I understand that the drivers of pipeline stock are demand and lead time, but I am not able to validate the results using the PROPAGATEDDEMANDMEAN and lead time key figures. Can you shed some light on how this key figure is calculated or at least how I can validate the results for Pipeline Stock (Target).

Regards,

Shiv

[former_member1094184]

Hi Shivam,

I had the same question... There is a KBA that is very helpful.

Refer to this note:

2841454 - How to validate the value of IOTARGETPIPELINESTOCK in your planning area

I hope it helps!

[former_member623960]

Hi Joao,

The KBA is exactly what I was looking for!

Thank you for the response!

[lev_degtyarov · Accepted solution]

Hi Shivam,

It's hard to say what is wrong with you calc wihout having even an example.

When calculating pipeline stock I suggest you should consider:

• DEPENDENTLOCATIONDEMANDMEAN
• minimum lot size and incremental rounding
• lead times

Have you checked these notes?

2808369

2562948

[former_member1094184 · Accepted solution]

Hi Lev,

I will join this question to make a similar one. I have the operator resulting in fine pipeline values for finished goods (when comparing to lead time). But for components, pipeline is resulting in approximately half than expected. See the example below:

I have a TLEADTIME of 27 days, so I am expecting Pipeline for W37 to be: 12720 + 15000 + 23520 + 11160*0.86, which leads to 60834. IBP is returning 37337,3 which is 16 days. And repeat for next periods.

Location ratio is 1, and incremental lot size is 1 as well. There is no minimum lot size.

Do you have a clue about these results. Why values are lower than lead time.

Thanks,

João