| # 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. Validate Click Validate to check references, duplicates and if all mandatory fields are filled. A so called integrity check of the supplied data. It is mandatory to run validate. Determine Items to Migrate This Specific command will switch on the migrate flag for all items that need migration. |