IBP Shelf life planning

[Former Member]

Hi All

We are working on a demo and need to showcase shelf life planning functionality. SAP IBP standard 4S planning area that is used for shelf life planning doesn't have Product/Batch related attributes/master data available for planning.

Can we create batch related master data and add them in the planning level for TS shelf life to consider batch information?

Prior to 1908 upgrade SAPIBP1 supported shelf life planning based on L-code key figures, where the Batch/Batch-product master data were mandatory.

Any suggestions on this would be helpful.

[former_member654033 · Accepted solution]

HI Mayank,

Yes you can create custom MDT in shelf life planning area.

You can bring batch level data at MDT Product - Location - Batch level along with remaining shelf life in days / weeks . Later you can do attribute transformation and aggregate this as Product - Location- Shelf life ID to pass as input to Initial inventory key figure which is at Product - location - shelf life ID.

Shelf life heuristic plans at Product - Location - Shelf Life ID level.

Thanks

Girish

[Former Member · Accepted solution]

Hi Girish

Thank you for the quick response. I have few queries and tried to define steps based on your suggestions:

1] Create new MD Batch Id and Batch Id-Product and add them in the planning area.

1] I would need to create a new planning level of Location-product-Batch ID-Remaining shelf life marked them as root.

2] Create a new Stored KF as Z-initial inventory at the planning level Location-product-Batch-remaining shelf life?

3] For shelf life planning since it can only plan at Product-location-Shelf Life ID level, I would need to aggregate the Z-initial inventory KF data and copy it Standard KF of Initial Inventory. I did not understand the attribute transformation part in this calculation?

We can use copy-disagg operator?

[former_member654033 · Accepted solution]

Hi Mayank,

Create new MDT like below

1. Batch MDT (Batch ID as Root)

2. Batch Location Product compound MDT having additional attribute like below

- INITIALREMAININGSHELFLIFE (Integer)

- Batch Qty (Attribute as a Key figure) at - Batch-Product-Location Planning level.

3. Now you have stored KF ZBATCHQTY@PERPRODLOCBATCH

4. Do attribute transformation here to bring attribute INITIALREMAININGSHELFLIFE as SHELFLIFEID to change the planning level of ZBATCHQTY to PERPRODLOCBATCHSHELFLIFEID. (Attribute transformation is required for this purpose because we have to transform INITIALREMAININGSHELFLIFE as SHELFLIFE Attribute to add in planning level)

5. Now using copy operator copy KF ZBATCHQTY@PERPRODLOCBATCHSHELFLIFEID to INITIALINVENTORY@PERPRODLOCSHELFLIFEID.

Thanks

Girish