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
- Go to Business Configuration work center
- Select Implementation Projects view or Overview.
- Search and Open the migration activity
- Execute Migration for the respective Migration File
Note: Migration Mode - Enhance Existing Records.
If you are trying to enhance the Payment Data with the SEPA Mandate then it is not possible.
The Structure of the SEPA Mandate is,
The structure is like this:
--->Payment Data ** Child to General
---->SEPA Mandate ** Child to Payment Data.
The 2nd level child can not be maintained until data is being maintained for 1st level child in the same file.
If the Payment Data is already maintained then Enhancement of SEPA Mandate cannot be done through Migration.
Currently the creation of SEPA Mandate is possible along with Payment Data.
This behavior is not only for this but also for similar structures where ever found in migration. If Payment Data is already maintained, Only SEPA Mandate can not be maintained. Similarly, It is not possible to enhance the Payment Method, if the Payment Data is already maintained.
KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , How To