Validation of input parameters
The values specified for the input parameters are validated. These are the validation rules for each parameter in the M3_EXECUTE_IMPORT program:
- IMPORT_MODE: The specified value must be Full, Partial, or Incremental. Else, an error message is displayed, and the execution is stopped.
- TARGET_DELETE_MODE: The specified value must be Physical or None. Else, an error message is displayed, and the execution is stopped.
- TARGET_UPDATE_MODE: The specified value must be Insert or Merge. Else, an error message is displayed, and the execution is stopped.
- TARGET_TABLE_NAME: The specified table name must exist in SZ_REG_TABLE. Else, an error message is displayed, and the execution is stopped.
- TARGET_TABLE_GROUP_NAME: The specified table group name must exist in SZ_REG_TABLE_GROUP. Else, an error message is displayed, and the execution is stopped.
- TARGET_TABLE_AREA: The specified value must be M3_Import and must exist in SZ_REG_TABLE. Else, an error message is displayed, and the execution is stopped.
- SOURCE: The specified value must match with a Warehouse Group name in M3. Therefore, only the data linked to the warehouses in that group is imported. If the value is not specified, all data is imported.
Note: You must specify only one of these parameters at a time:
- TARGET_TABLE_NAME
- TARGET_TABLE_GROUP_NAME
- TARGET_TABLE_AREA