Validate Planning Data
The EXECUTE_VALIDATION program is used to validate planning data (user and inbox) in SCV using validation rule definitions. The program first validates user data, if specified, and followed by inbox data. When validating records that reference another record in inbox, core, or user data tables, the program validates all records by using one of these methods:
- Checks whether a referenced record exists.
- Checks whether a referenced record exists and has a valid status (default method).
When validating user data, the program:
- Gets the current entity name (for example, <ITEM>)
- Validates SM_ITEM using validation rules defined for SM_ITEM
- Validates SI_ITEM using validation rules defined for SI_ITEM
- Validates SI_ITEM using the USERDATA validation rule, considering only valid records in the SM_ITEM table.
The EXECUTE_VALIDATION program generates multiple log records if invalid data is loaded in a table. The SCP_VALIDATION_MAX_NUMBER_LOGS parameter is used to limit the log records for each validation rule. When the limit is reached, remaining records that are not validated are not updated with the Success status.