Your requirement is to upload the Payment Method for Suppliers. Upon trying to upload the Payment Method for Suppliers using Migration of Suppliers, system throws the error:
Insertion of data failed; data with key XXXXX already exists for node ROOT
Reproducing the Issue
- Go to Business Configuration work center
- Select Implementation Projects view or Overview
- Search and Open the activity Migration of Suppliers
- Select Migrate suppliers using the migration tool
- Upload the Migration File
- Execute Migration for the respective Migration File with Migration Mode Enhance already new records
It is not possible to add Payment Method using the Migration Mode Enhance already existing records in Migration of Suppliers.
We can use the Webservice approach where we can use the Microsoft Excel to add Payment Method to the existing Suppliers.
You may also refer to the link http://scn.sap.com/community/business-bydesign/blog/2015/05/15/mass-changes-of-byd-data-using-excel-and-byd-web-services for more helpful details.
The attached excel template is made to create specific Supplier data – Payment Method.
The precondition is that there must be Payment Data with Company maintained for Suppliers. This excel helps to add only Payment Method to existing Payment data with Company, for which no Payment Method exists. It must not be used as Update for changing existing Payment Method.
See also Terms and Conditions Tab on the provided Microsoft Excel Template. Do not change anything on the Config Tab. You may create your own Microsoft Excel template for performing mass change for further data according the description in the link above. This Microsoft Excel template is a specific solution only for Supplier Data Payment Method.
1. Set up Communication Arrangement
In Application and User Management workcenter the Communication System, Communication Scenario and Communication Arrangement must be created for using the Microsoft Excel template via Webservice.
At first create communication system like above.
Create then new Communication Scenario.
Finally create and maintain Communication Arrangement.
Under View All under Technical Data, you can maintain the User and Password for Webservice User, which is required for the Communication using Microsoft Excel. Do not forget set the Authentification to User and Password and maintain the Password. The user name is automatically generated.
2. Setting up Microsoft Excel template
Operating System is MS Windows8 and higher. Microsoft Office 2013 or newer. User has configured Communication System, Communication Scenario and Communication Arrangement correctly. There is a Webservice User configured, which is required to logon using excel.
- When the provided Microsoft Excel template is opened allow that editing is enabled and Macro can be performed
- There is a Business ByDesign specific area visible on right corner of the Ribbon.
- Select Query
Maintain the System URL and User data.
Here you enter the User and Password you maintained in Communication Arrangement setting.
3. Limit Data by Setting Filter
In order to perform Query for selected Suppliers enter query data on Query Tab.
Go back to _DATA_MASTER Tab and select Query on Ribbon again. Webservice call for Query to Business ByDesign system will be performed and specified Supplier data are pulled. This will take a while depends on number of the found entries.
4. Set Filter for Mass Change
Set filter Blanks for Payment Method.
Set further filter for Company ID
Select all filtered entries and Copy
Create new temporary Tab or new Microsoft Excel sheet and paste copied data with Paste special->As Values
Set the Query parameter so that no entries will be found in the sytem, in order to remove all entries on the _DATA_MASTER tab.
Reset filter before performing Query.
Now the table is empty.
Paste the filtered data back from the temporary excel sheet.
Replace & in the Supplier Name using Find and Replace function. There are & character used for several Supplier used. This will lead to error for the Webservice call, so this character must be replaced by &
5. Prepare data for Mass Change
Enter the data for Payment Method.
All lines in the first column Modified must have the value Modified when these lines should be taken for the Mass Change.
For the verification, select Simulate on the Business ByDesign Ribbon area.
When everything went fine a Success message is shown and the value in the Modified column is changed to OK.
6. Mass Change
Select Update on Business ByDesign Ribbon are to make Mass Change.
In case of some errors the Modified column will be change to value Error. There are also error message created as note for the cell.
7. Check Data
Perform Query and set Filter as beginning and check whether Payment Methods are added. Further, check in the system directly.
KBA , SRD-CC , Cross Components , How To