Skip to Content
0

Validation Formule for expiration date in PI sheet

Feb 22, 2017 at 02:47 PM

40

avatar image

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

10 |10000 characters needed characters left characters exceeded

Any Comment?

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers