Skip to Content
0

More than one Validation validation formule in PI sheet

May 29, 2017 at 04:30 PM

16

avatar image
Former Member

HI Team,

How should one use more than one validation within one process instruction?

In PI sheet output I have inspection date, expiry date and staging date. Current I am using one FM as validation function to pass expiry date and staging date (std validation formule does not work as the dates are in different format). The FM checks and generate error in case expiry date is in past than staging date when the staging quantity is entered. There are 2 issues:-

  1. While staging date is past, error message is coming properly but the quantity field is not getting cleared. As a result in the next one can go ahead with the same quantity. How to clear the value?
  2. New requirement to validate inspection date also like expiry date and if any of these two is getting failed, error should get generated. I tried to pass the input with OR like, EXPORT PARAMETER1 PPPI_VALIDATION_FUNCTION = Expiry date PPPI_VALIDATION_FUNCTION = OR PPPI_VALIDATION_FUNCTION = inspection date EXPORT PARAMETER 2 as staging date but these are not working , if any one used this? Thanks, Krish
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers