Symptom
You have a requirement to update/enhance the Payment Data of some Customer and system throws below error message while trying to do it through Migration (Mode: Enhance Existing Records)
Insert not possible; specified data for CUSTOMER-PAYMENT_DATA already exist
Reproducing the Issue
1. Go to Business Configuration work center
2. Select Implementation Projects view or Overview.
3. Search and Open the migration activity
4. Execute Migration for the respective Migration File
Note: Migration Mode - Enhance Existing Records
Cause
The problem here is caused when some accounts are also supplier. In Supplier Base Work Center we can see that there are already payment data maintained for the supplier but there will be no payment data maintained for Accounts.
Resolution
Currently it is not possible to enhance the payment data for customers that already have payment data for the same company in the role as supplier.
So please exclude those accounts from your file that have payment data already maintained in the role of supplier.
Keywords
KBA , SRD-MD-BP , Business Partner , How To