Skip to Content
avatar image
Former Member

Validation Function in PI sheet

Hi Team,

In PI sheet, we have created one FM for date validation. The FM will trigger when the quantity field is maintained and entered. Quantity field is by default as zero. Once user is entering any new quantity and press enter button, validation should trigger. If the validation is getting failed, it should trigger error message and change quantity field back to zero again.

With the FM, validation is triggering correctly with error message but the quantity field is not getting back to old quantity zero. FM is having one QUAN _IN field as IMPORT along with date fields and one QUAN _OUT field as export along with error message flag. Configuration is maintained as below

PPPI_REQUESTED_VALUE Stagging Quantity

PPPI_VALIDATION_FUNCTION FM Name

PPPI_EXPORT_PARAMETER Date1

PPPI_STRING_VARIAB LE VAR1

PPPI_EXPORT_PARAMETER Date2

PPPI_STRING_VARIABLE Var2

PPPI_EXPORT_PARAMETER Date3

PPPI_STRING_VARIABLE Var3

PPPI_EXPORT_PARAMETER QUAN_IN

PPPI_FLOAT_VARIABLE X

PPPI_INPUT_REQUEST Date Diff

PPPI_IMPORT_PARAMETER CAL_DATE

PPPI_STRING_VARIABLE 2

PPPI_INPUT_REQUEST Changed Quan

PPPI_IMPORT_PARAMETER QUAN_OUT

PPPI_FLOAT_VARIABLE Y

In the debug mode, it is checked that QUAN_OUT is getting changed to zero in case of error (CAL_DATE =2), but it not reflecting / coming back to PI sheet properly.

Please help.

Thanks

Krish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers