Automatic Expiration date calculation and updation to process Order

Hi All,

There is a requirement to calculate the expiration date based on the date entered in the PI Sheet and update to the corresponding Process Order.

The expiration time for the Product is 12 hours only. Once the product is produced it last only for 12 hours and it expires.

As per standard SAP expiration date calculation shall be based on Days,Months,Years etc.. Hence it requires a custom logic/development to calculate the expiration date.

Date of manufacture and Time of Manufacture is entered manually for the process order in PI Sheet. And based on that Date and Time the expiration date has to be calculated and updated automatically for the batch created for the Process Order:

Eg: Process Order A, Material A and Batch A

Date of manufacture: 07/10/2013 and Time is 10:00:00 AM

Expiration date should be: 07/10/2013 and Time shall be 10:00:00 PM.

In order to perform this calculation automatically and update to the process order what would be the optimum solution to perform this.

If any of you have come across the similar scenario please share your thoughts.

Appreciate your early response.

Regards,

Shyam