Symptom
You are looking to load multiple Ship to/Bill to locations to one Account in a single upload. When doing so, the system is saying you have duplicates in the file. So it is only creating the relationship between one location and account at a time, and saying there are duplicates for the rest.
Environment
SAP S/4 HANACLOUD
Reproducing the Issue
- Open fiori
- Got to Import Data for Consolidation – Business Partner Relationships
- During the import of the file a warning is displayed "Entries already in "&2" (table &3): &1 of &4 "
Resolution
In order to load several business partner relationships (or any other business object) they must have a unique source key (consisting of fields SOURCE_SYSTEM and SOURCE_ID). When uploading the file with those objects, the source system is declared once for all records in the file. The source ID is taken from the column "SOURCE_ID" within the file.
See Also
See also SAP Help documentation and _README_BPREL.txt in File Import Example Files of "Import Data Business Partner Relationships" - App for more information.
Keywords
BP relationship, F6552, import data, MDC_LOAD131, SOURCE_ID, SOURCE_SYSTEM , KBA , CA-MDG-CMP-BP , Business Partner , How To