Batch determination in Prod Order

Hi Experts,

My requirement is to do batch determination in production order, based on Expiration date as well as Vendor batch combination. And the condition is, the whole requirement quantity should be determined from single vendor batch only. How to achieve this, please suggest.

How to achieve this thru configuration and

How to define a routine for above condition.

Example

1. qty = 20 kg

Stock

Vendor Batch 001 – 10 Kg SLED = 15.07.2015

Vendor Batch 002 – 20 Kg SLED = 15.10.2015

Vendor Batch 003 – 25 Kg SLED = 15.09.2015

While Batch determination Batch number 003 should be proposed as it suffices the req. qty. and SLED condition.

Thanks & Regards

Neelima