Import Planning Data from M3

The M3_EXECUTE_IMPORT program is used to import planning data from M3 to specific import staging tables designed for M3. This program uses the M3 Business Object Interface (BOI) definitions.

These parameters are used in the M3_EXECUTE_IMPORT program:

IMPORT_MODE

The different modes in which data can be imported.

• Full
• Partial
• Incremental

PARTIAL_IMPORT_START_TIME

The time from when the data importing begins.

Note:  A value must be specified in this field, only if the IMPORT_MODE field is set to Partial.

TARGET_DELETE_MODE

Indicates whether to delete records in the target table during the import process.

• Physical
• None

Note:  By default, the value is set to Physical.

TARGET_UPDATE_MODE

The method that determines how data is updated.

• Insert: New records are only added.
• Merge: Existing records are updated, and new records are added.

Note:  By default, the value is set to Insert.

TARGET_TABLE_NAME

The name of the target table where the data is imported.

TARGET_TABLE_GROUP_NAME

The name of the table group that contains the target tables for data import.

TARGET_TABLE_AREA

The name of the table area that contains the target tables for data import.

Source

The specific subset of planning data to import from M3.