Skip to Content
avatar image
Former Member

Validation Formule for expiration date in PI sheet

Hi,

We have a requirement to validate that the components materials those are going o consume is not expired during PI sheet execution date. SLED is implemented and getting SLED date in browser based PI sheet. Now to make validation, we have tried 2 ways

1. using formula VDATE 0001 (Staging date) > VWRT001PPPI_BATCH...here for non expired material also it is showing error message as internal error in formul VDATE>VWRT001

2. tried to calculate duration between staging date and SLED usng FM:

COPF_DETERMINE_DURATION...then validating whether it is greater than zero or not. here error is internal date error (YYYYMMDD).

Assume method 1 is easy, but please help if you face the same issue.

Thanks

Krish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers