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.