Symptom
You upload a migration file in the Migration of Customers activity. This file includes hidden columns that are filled with data. But you are not able to upload this data and an error message appears:
The file you are uploading includes the following column(s) that is not part of active source view:
ABC - XYZ (ABC represents the name of the sheet, XYZ represents the name of the hidden column).
Data from these columns will not be uploaded.
Even unhidden and populated, the related tabs do not show up during during Validation step.
Reproducing the Issue
- In your Migration File, unhide and maintain the column XYZ.
- Go to the Business Configuration work center.
- Select the Implementation Projects view.
- Click on the Activity List tab.
- In Show field, select All Activities.
- Search for Migration of Customers.
- Choose Open.
- Select Migrate Customers using the Migration Tool.
- Upload the filled Migration Template.
The following error message appears:
The file you are uploading includes the following column(s) that is not part of active source view:
ABC - XYZ
Data from these columns will not be uploaded.
Cause
Hidden fields exist only for reference purposes. The migration tool ignores the data in these fields. This is the expected system behaviour for the Migration of Customers and valid for all migration methods (add new records, modify, enhance, replace).
Resolution
Please use Data Workbench to upload such data. To modify existing data and for example to upload Contacts-Marketing Permission, also the Mass Data Maintenance scenario is applicable.
See Also
2444581 - Issue with the Hidden Tab 'Contacts-Marketing Permissions' during Migration of Customers
Keywords
KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , Product Enhancement