Batch determination in SAP warehouse based on Expiry date

     Automatic Batch Determination in warehosue based on Expiration date  

This document illustrates how a batch is automatically determined while creating a transfer order of delivery based on the Expiration date of the material in the batch. This concept of batch determination is primarily useful in Pharmaceutical, Chemical and Food industries, where you want a batch closer to its expiration date to be delivered first.

1) Introduction:

  If the product is to be delivered in batches, the system should automatically determine the batches appropriately during the delivery. This concept of batch determination is primarily used in industries involved in the manufacture of Pharmaceutical, Chemical and Food products.

  Below is the following scenario where we can apply this concept of automatic 

Batch determination. 

i) The batch delivered based upon Expiration date of batches.

ii) The batch which has an expiration date that is nearer should be delivered first 

     and the batch which has already crossed its expiration date should not be picked up.

 iii) If the quantity required by the customer exceeds the quantity of a batch, then

      the next batch should also be picked up in the similar manner, that is, it should 

      have its expiration date nearer than the remaining batches.

2) Define Class and Its characteristics

 Create the class Z_FG1 of class type “Batch (023)”  and assign the below characteristics . 

  a. Z_BATCH_NO (Batch No)

  b. Z_MANU_DAT (Manufacturing date)

  c. Z_EXPIRY_DAT(Expiry date)

Define the Characteristics-   Using CT04 we can create the characteristics 

 Create the Class and assign the above characteristics- using CL01 we can create

the class and assign characteristics to this class.

3) Materials Master Settings:

   In this step, we can maintain the created class with the materials  under the classification tab in the material master using transaction MM01.

 

 Besides to enable the material to be maintained in batches, you also need to check “Batch Management” under the “Sales/General Plant‟ tab in the material master.

 4) Creation of selection class 

      Using transaction CL01 we can create the selection class Z_SELECT.

5) Creation of Sort rule:

 The next step is to create a sort rule which tells the system to sort the batches based on the based on the expiration date in ascending order (the batches with the date closest to the present should be the first to go).

Transaction – CU70

 6) Define Batch determination procedure

   

     a) Condition table – In above scenario, we have used the standard condition 

         table ‘011 (Warehouse No./Movement Type)’

 

   

    b) Access Sequence – No need to do anything here.

 

 

7) Creation of batch Search Strategy

a) Strategy Type (Warehouse management)

 

Here we define the strategy type and assign the access sequence with it. 

b) Define the Batch search procedure

 Here we can define the search procedure and assign the search strategy to it.

 Now click on Define Warehouse Management Search procedure 

 

In control data of WM0002 we can assign the search strategy.

 Now Finally assign this procedure to Warehouse / Movement type combination.

Here we have to assign the Search procedure to require movement type.

8) Maintain the condition records in warehouse

a) Create the condition records.

     Using Transaction code LS51 we can create the condition records for 

      automatic batch determination in transfer order creation of outbound delivery.

Here we have to enter the warehouse ‘001’ and movement type ’ 601’

Now we have to assign the selection class and sort rule and then save it.

 Now assign the sort rule here.

 

 So, now all setup done . Now check one example-

when we can create the transfer order of delivery the automatically batch determine will happen for each line item of delivery.

Now check the transfer order

Pls contact me if any concern on Mail ID: Shambhu.abap@gmail.com

Thanks,

Shambhu