Conversion Table for Items (bcmtc1119m000)
Table is created to determine which items to migrate, for example to prevent migrating items twice and causing duplicates in ERP LN 6.1.
Preparation
Fill table by premigration run.
Execution
It is always mandatory to run this session.
Process logic
Because some queries are not supported by the database a workaround has been created. All items from MANDB.IM and FINDB.PROMAS are placed in the mapping table for items bcmtc119. Some items appear in both manman tables. ERP LN 6.1 only needs one version of each item. After running the specific command Determine Items to Migrate it is garanteed that no duplicate items will exist among items with migrate flag switched on. The data cannot be changed manually: the user can only execute Specific command.
Duration
Session will take some time depending on the number of items in table bcmtc119.
- MANMAN Origin Table
-
Field is filled during premigration and cannot be edited by user.
Allowed values
FINDB_PROMAS or MANDB_IM
- MANMAN Item Code
-
Field is filled during premigration and cannot be edited by user.
Allowed values
Items from tables FINDB.PROMAS and MANDB.IM
- MANMAN Item Description
-
The description of the Item.
- Unit
- Item Product Type
- Product Active
- Country of Origin
- Commodity Code
- Migrate
-
Field is filled by executing specic command Determine Items to Migrate and cannot be edited by user.
Allowed values
The allowed values are Yes or No.