how to exclude expiring batches from the MRP run

[Former Member]

Does anyone know how to run MRP to make sure that batches are not to be considered for planning after their expiration date?

any help is greatly appreciated

[Former Member · Accepted solution]

Hi Uwe

to the best of my knowledge  standard SAP does not take into the batch expiry date during the mrp run. If the quantity is there, then it's taken into account irrespective of expiry date - but I am happy to be proven wrong.

Have you thought of coding a mrp user-exit ?

Best regards.

[Former Member]

thanks Pascal... that's what I feared is the case. It is a little unfortunate because I have quite a few clients who have this problem 😞

[Haags]

Hello,

you have discussed about MRP run in ERP.

Looking into APO our friends from Chemical / Food industries using following functionality:

Planning with Shelf Life Data in PP/DS

http://help.sap.com/saphelp_scm70/helpdata/en/4c/4e5ac8eb096ad8e10000000a42189c/frameset.htm

Greetings,

Stefan Haag

[Haags]

A potential workaround:

1. Select by reporting the batches, which are close or at the expiration date.
2. Post them manually into blocked stock.
3. Next MRP run would create new planned orders

If you have many batches, probably you need to develop for step 2 a z-transaction, to do a mass posting into blocked stock.

[former_member383287]

This message was moderated.

[Former Member]

Thanks Vijay. This is greatly appreciated

[PEHAM]

Hello Vijay,

would it be possible for you to share informations about this solution?

Many thanks for your answer.

[former_member383287]

This message was moderated.

[PEHAM]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[tedji]

This message was moderated.

[Caetano]

Hello Uwe

I know that this is an old thread but I see that many users keep posting questions here.

MRP does not run at batch level and it does not carry out any kind of check for the batch expiration date. I think that the easiest way to exclude expired batches from MRP is using BAdI MD_CHANGE_MRP_DATA. With method CHANGE_MDPSX_MARD of this BAdI you can manipulate the stocks and exclude the expired batches.

See the following document with an example of this BAdI:

BR

Caetano

[kishore_sirigiri]

This message was moderated.

[Former Member]

Hello,

There are two known solutions for this issue.Either buy and connect a software that takes expiry dates into account (like SAP APO), or develop a solution to upgrade MRP runs. For example, create a program that:

_ runs MRP in order to generate stock reservations.

_ compares (incrementally) expiry dates of the available batches with the reservation dates.

_ in case of expiry date < reservation date, the system creates a new reservation for the predictably expiring batch. the reservation aims to block this batch, it should be linked with a new movement code that do not really 'move' this batch, until his expiry and destruction.

_ run again MRP. It will only consider 'safe' batches.