Re-Order Point Planning in IBP

[aishani_das]

Hi Experts,

Below is the requirement to generate Transport Receipts based on Re-Order Point planning:

• We have two key figures -

1. Minimum Planned Months of Supply
2. Maximum Planned Months of Supply

• Implement the following logic to generate Planned Transport Receipts:

• IF Projected Months of Supply goes below Minimum Planned Months of Supply value, THEN IBP generates a Planned Transport Receipt in that period to increase Projected Months of Supply up to the Maximum Planned Months of Supply

We have been using key figure 'SUBPERIODSOFSUPPLY' as the standard logic provided by SAP. However, when we change the definition of 'SUBPERIODSOFSUPPLY' to suit the new requirement, the functionality does not work.

Request your suggestions on how to go about re-order point planning based on the above logic.

Regards,

Aishani

[mohnotrahul · Accepted solution]

Hi Aishani,

Follow the steps:

1.You will have to use "Dynamic Losize Policy" i.e. 2 in Location Product Master data then

2. Convert the "Minimum Planned Months of Supply" to quantity using IBP function IBP_RAGGR and use that value in standard keyfigure INVENTORYTARGET (input for Supply planning)

3. Use SUBPERIODSOFSUPPLY as calculated difference between Maximum Planned Months of Supply and Minimum Planned Months of Supply.

I assume that you are doing planning at monthly level (Subperiodnum=1).

With dynamic lotsize, it will always respect the Inventory Target which is your minimum and as soon as IBP SOP operator sees it falling below it will replenish it with Subperiod of supply which is you Maximum planned months.

It will work.

Regards,

Rahul Mohnot

[aishani_das · Accepted solution]

Hi Rahul,

Thank you very much for the kind response.

I have tried implementing the logic, however, I am not sure how exactly to convert "Minimum Planned Months of Supply" to quantity using the IBP_RAGGR function. The requirement is to have a default value of 0 for "Minimum Planned Months of Supply" unless a non-zero value is manually entered by user. Apologies if I misinterpreted your solution.

Are you suggesting something like - INVENTORYTARGET = IBP_RAGGR("DEMAND@xyz", 0, ' 'Minimum Planned Months of Supply@xyz' ',' 'CURRENTFUTURE''). If this is the case, I think I can make it work.

Also, we are using Shelf-Life based heuristics and the planning level is monthly, as I missed to provide this information earlier. Thanks a lot in advance.

Regards,

Aishani Das

[mohnotrahul]

Please ensure that the INVENTORYTARGET is marked as " Input to Supply Operator", as i have seen that when we change the KF, this field gets the blank value.

[aishani_das]

Thanks, Rahul. The key figure is marked as Input for Supply Planning, still it's failing. Below is the standard calculation:

Regards,

Aishani

[mohnotrahul]

That's Correct ! Aishani, for your case IBP_DYNAMIC_RAGGR is more suited.

[aishani_das]

Hi Rahul,

Thanks for all the help. Unfortunately, heuristic fails because of the change in calculation in INVENTORYTARGET.

As I am trying to figure out alternative expressions for the calculation, do you have any workaround to suggest, if possible? Thanks.

- Aishani

[mohnotrahul]

Yes Aishani,

You got it right. Inventory Target calculation should be considered as you have shown. This would work.

-Rahul

[aishani_das]

Hi Rahul,

Thanks a lot for confirming.

I think the IBP_DYNAMIC_RAGGR function is suitable here since IBP_RAGGR function does not support dynamic parameters. I gave it a try and it did work with IBP_DYNAMIC_RAGGR. However, heuristics failed due to change in calculation in INVENTORYTARGET key figure. Only the conversion from re-order months to quantity is happening as expected.

Please let me know if you faced similar situation while trying to edit the INVENTORYTARGET key figure copied from SAP4S planning area.

Regards,

Aishani Das