Input parameters and validation rules
The EXECUTE_VALIDATION program considers these input parameters:
- SOURCE
- The source system that provides the planning data for validation.
- TABLE_GROUP_NAME
-
The name of the table group to validate.
Note:
- If this value is specified, an existing entry must be available in the SZ_REG_TABLE_GROUP table. If there are no entries in the SZ_REG_TABLE_GROUP table with the provided table_group_name value, an error message is logged, and the execution is stopped.
- The program can only use the TABLE_GROUP_NAME or TABLE_NAME parameter. If both parameters are specified, an error message is logged, and the execution is stopped.
- TABLE_NAME
-
The name of the table to validate.
Note:
- If this value is specified, an existing entry must be available in the SZ_REG_TABLE table. If there are no entries in the SZ_REG_TABLE table with the provided table_name value, an error message is logged, and the execution is stopped.
- The program can only use the TABLE_GROUP_NAME or TABLE_NAME parameter. If both parameters are specified, an error message is logged, and the execution is stopped.
- INCLUDE_USER_DATA
-
Indicates whether user-created records are included when validating the inbox table. Possible values:
- Y: Includes user-created records in the Planning Configuration table that corresponds to the inbox table.
- N: Validates only the inbox data table without the Planning Configuration table.
- CHECK_REFERENCE_STATUS
-
Indicates whether the program applies the reference_validation_status check on validation rules. Possible values:
- Y: Checks if the referenced record exists and validates the status for the specified reference_validation_status in the reference validation rule or the default reference status.
- N: Checks only if the referenced record exists.
The EXECUTE_VALIDATION program validates all validation rules in scope of the current execution. If all validation rules in scope are valid, it continues with execution. Else, an error message is logged, and the execution is stopped.