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