Shelf life quantity based planned order in MRP

[former_member43157]

MTS scenarios

Customer x wants 100 qty of FG with shelf life more than 10 months. Plant stock is available for 200 but all are less than 10 month shelf life. When MRP run happens I want sales order demand not to consume from stock as we don’t have 10 month shelf life. System should create a new planned order to produce new batches .how to achieve this ?

[Caetano · Accepted solution]

Hello

MRP does not consider the batch expiration date when planning a material. In standard, you can use transaction QA07 to automatically make batches close to the expiration date not relevant to MRP.

Another alternative is to create your own solution using a BAdI, to exclude batches expired from MRP. If you are using classic MRP, you can consider BAdI MD_ADD_ELEMENTS and if you are using MRP Live you need to consider the equivalent AMDP BAdI.

Regards,
Caetano

[former_member43157 · Accepted solution]

Yes Caetano , We plan to restrict batches with are closer to expiration and make mrp not count restricted batch, but even we figured out Batch is not a standard MRP element.

[Raja_S_Reddy_B]

Hi Poorvi,

Please take a look of the attached Blog, which helps to fulfill the Business requirement shared by you.
https://blogs.sap.com/2017/03/14/excluding-expired-batches-from-mrp-run/

Let me know your feedback, for any other details required
Thanks & Regards : Raja

[former_member43157]

Good blog , but not my requirement

[P2003523347]

Hello,

You can try MRP run at Storage location MRP area level by excluding stock of other storage location.

Best regards

Sunil Patil