Symptom
You are trying to migrate materials in the system, however in the Simulation step the migration raises the following error message:
"Combination of Sales org. X and Distribution Channel Y Already Exists" (where X represents an org unit, and Y represents a distribution channel).
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Configuration work center.
- Enter the Overview view.
- Search for the activity Migration of Materials.
- Click on the name of the activity to open it.
- Click on the sub-activity Migrate Materials Using the Migration Tool.
- Select the file to be imported, or upload a new file.
- Click on the button Execute Migration.
- Click on Step-by-step.
- Proceed until the step 3 - Simulation.
After the simulation is finished, the error message appears in the log.
Cause
You have mapped different source values of Sales Organization to a single target value. This is causing duplicate entries in the migration if both Sales Organizations are being imported with the same Distribution Channel.
For example, consider the following dataset in a migration template:
- Sales Organization X - Distribution Channel Y
- Sales Organization Z - Distribution Channel Y
In this scenario, the migration would not raise any errors. However in the step 2 of the migration process (Value Mapping), both Sales Organizations were mapped to a target Sales Organization W. This causes the data set to be considered as the following:
- Sales Organization W - Distribution Channel Y
- Sales Organization W- Distribution Channel Y
This causes the error in the simulation, as there are duplicate entries being imported.
Resolution
In order to fix the issue, check the Value Mapping step of the migration process and ensure that no concurrent source values are being mapped to a single target value.
To check the mapping task, you can follow the below steps:
- Go to the Business Configuration work center.
- Enter the Overview view.
- Search for the activity Migration of Materials.
- Click on the name of the activity to open it.
- Click on the sub-activity Migrate Materials Using the Migration Tool.
- Select the file to be imported, or upload a new file.
- Click on the button Execute Migration.
- Click on Step-by-step.
- Proceed to the step 2 of the migration wizard.
Keywords
Excel, Template, Org Unit , KBA , SRD-MD-PRD-PRD , Product , Problem