How to take expiration date of batches into account in MRP on S4HC system?

[SAPSupport]

By standard in SAP S/4HANA Cloud system, MRP does not take into account the expiration date of products during the MRP run. That means certain batches of stocks will be treated as available during MRP even though they will be expired at the actual delivery date, which will cause a backorder situation.

In On Premise system, it is possible to use function module MD_STOCK_REQUIREMENTS_LIST_API or MRP BADI as workaround which however is not available on S/4HANA cloud system.

Is there any resolution in the cloud system to make the MRP take into account the expiration date of a material?

[jerryjanda]

Learn more about the SAP Support user at https://blogs.sap.com/2021/09/20/maximizing-the-power-of-sap-community-at-product-support/.

[SAPSupport · Accepted solution]

MRP doesn't consider batches -- it only considers stocks on material level, which means there is no standard solution for the scenario in respect of MRP.

However, please have a try of using multiple APIs to meet your requirements as a workaround:
e.g. First, using API_MATERIAL_STOCK_SRV/A_MaterialStock, you can get batch and stock information of the material.
Then, using API_BATCH_SRV /Batch, you can get the expiration date of the certain batch.
Finally, per the data above, using API_RESERVATION_DOCUMENT_SRV to create a reservation for a transfer posting on the expiration date. Then the available stock will be consumed by the reservation on the expiration date to avoid backorder.

This is an example, please test the feasibility per your business scenario.