Automatic Batch Determination Based on Batch Characteristics

[yu_yanagihori]

I have done setting of Automatic Batch Determination Based on Shelf Life and it's working fine when I create delivery order.
(I have done required configuration and created batch search strategy by VCH1)

Now I have a new requirement.
And that is, instead of batch determination by shelf life, I need to determine batch by batch characteristics.

Ex.)

Material / Batch : MAT001 / BTC001
Charcteristics
Warning Date: 2021-9-14

Material / Batch : MAT001 / BTC002
Charcteristics
Warning Date: 2021-9-20

Delivery Date : 2021-9-15

I want batch determination to determine only BTC002 because delivery date is before [Warning Date].

What is needed to achieve above requirement. (Configuration, Master data, etc.)

Appreciate your help. Thank you.

[jignesh_mehta3]

We have a similar requirement to ensure that the batch managed Materials with earlier Goods Receipt Date should be used in Deliveries first.

For this purpose we have used Standard Characteristic - LOBM_LWEDT - Date of Last Goods Receipt and used this in Sort Sequence with Ascending activated.

(Sort Sequence are defined at - Logistics - General - Batch Management - Batch Determination and Batch Check - Define Sort Rules.

We enter the Last Date of Good Receipt in Batch Master under Trading Data Tab.

[yu_yanagihori]

Thank you for your quick reply!

Regarding sort sequence, we need [Date of Manufacture] by ascending, so I am planning to do so.
What I questioned in first post is, how to filter batch by batch characteristics.

Ex.)
Material / Batch : MAT001 / BTC001
Date of Manufacture: 2021-9-1
Charcteristics
Warning Date: 2021-9-1

Material / Batch : MAT001 / BTC002
Date of Manufacture: 2021-9-7
Charcteristics
Warning Date: 2021-9-20

Material / Batch : MAT001 / BTC003
Date of Manufacture: 2021-9-3
Charcteristics
Warning Date: 2021-9-16

Delivery Date : 2021-9-15

I want batch determination to determine only BTC002 and BTC003 because delivery date is before [Warning Date].
And regarding which batch needs to be used first, I use sort sequence for field [Date of Manufacture] ascending.
So, in above example, BTC003 will be used first, BTC002 second, BTC001 not used.