cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic Expiration date calculation and updation to process Order

Former Member
0 Kudos
1,689

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

RohitMoghe
Discoverer
0 Kudos
Did you get the solution. i am also having same scenario.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184655
Active Contributor
0 Kudos

Dear Shyam,

In my understanding the system calculates the SLED based on the total shelf life maintained in the

Plant Data/storage 1 view and it calculates to the day level and not at least by the exact time.

A material can be consumed at any point of time before the date of the expiry.

You can activate the expiration date check in T.code OMJ5, either at the plant level or else for the

movement type.So for the product based on the total shelf life maintained in the material master, and

the date of manufacture the system will calculate the SLED.

Regards

Mangalraj.S

Former Member
0 Kudos

All the settings necessary for calculation of expiration date has been maintained successfully.

My Question is how to automate the calculation of expiration date and update to the batch master from PI Sheet. In PI Sheet only the Date and Time of Manufacture is being entered. Based on the Time we need to add 12 hours (as product expires in 12 hours time) and update the Date / time of expiration in Batch Master . We have custom characteristics for updating the Time of expiry.

Need your valuable suggestion to achieve this functionality.

Regards,

Shyam