Batch Derivation Scenario

[Former Member]

Dear PP Experts,

We have been using batch derivation functionality for transfer of Mfgr. Date and Expiry Date of Semi Finish to Finish Product. Now we have a new scenario which is as below:

Assume SFG has Mfgr. Date 22.06.2012 and shelf life in material master as 24 months, accordingly Expiry Date is 21.06.2014.

By batch derivation these values are transferred correctly to FG. However, there are 2 different scenarios for the FG wherein I require your expert help. The same SFG is used to produce different FG's.

Scenario 1: If shelf life maintained in material master of FG is 30 months then when process order of FG is released the Mfgr.and Expiry Dt.are updated in batch classification by batch derivation, but when I do GR of FG the SLED is changed from 21.06.2014 to 21.12.2014 according to the shelf life maintained in material master. In this case since I am using an input SFG of 24 months, my Expiry Dt. of FG should remain the same i.e. 21.06.2014.

Scenario 2: If shelf life maintained in material master of FG is 18 months then when process order of FG is released the Mfgr. and Expiry Dt. are updated in batch classification by batch derivation, but when I do the GR of FG the SLED is changed from 21.06.2012 to 21.12.2011 according to the shelf life mainted in material master. In this case since the shelf life of FG is 18 months, my Expiry Dt. of FG should be 21.12.2011.

In short my requirement is that the Expiry Dt. should remain the one whichever is minimum. I cannot change the material master shelf life.

Pl. let me know how can I acchieve both the scenatios.

Thanks in advance.

Regards,

Prashant

[Former Member]

Dear All,

We implemented BADI - DERIVATION and calculated the shelf life date. The issue is resolved. Hope this can be useful to others.

Regards,

Prashant

[Former Member]

Hi Prashant,

As you mentioned you are copying Mfg and Expiry date from SFG then why we need to maintain the shelf life for FG materials.

To achieve the above,

1. If you removed the Shelf life from FG material master the recalcualtion will not happnened.

2. Instead of doing the batch derivation at the time of process order release, try with at the time of GRN.

3. Or there is a customer exit is available for Shlef life calcualtion that you can activate at the time GRN posinting in MIGO.

EXIT_SAPLMHD1_001, Enhancement SAPLMHD1.

Regards,

Ismail.A

[Former Member]

Hi Ismail,

Thanks for the reply.

However, I tried to perform batch derivation at the time of GR, but it didnot work. Pl. tell me if batch derivation can be performed at both the events i.e. Release of Process order and GR of Process Order or is it that the derivation event is performed only once.

Also, my requirement is to update the expiry date values coming from batch derivation in such a way that it should calculate the expiry date from the shelf life maintained for FG material and then compare with the expiry date coming from SFG by batch derivation and maintain the one whichever is minimum out of the two.

I think standard functionality shall not support this requirement. If I m correct, pl. let me know any exit which can be used during batch derivation which I can maintain in DVR1 / DVR2.

Regards,

Prashant

[Former Member]

Hi Prashant,

As per my knowledge we cannot achieve the above requirement in std SAP.

You can use the Customer exit which i mentioned in my previous post to achieve the requirement.

as you know that at the time order release, characterstic will get copied only in the batch master. The recaculation will happened only at the time GRN, based on the entry of Date of manufacturing. Once the stadandard calcualtion is completed, compare the expiry date entry in the batch master with the new calcualted date and update the expiry date as per your requirement by activating the above user exit.

Regards,

Ismail.A