SAP Knowledge Base Article - Public

3451467 - MDC- BP Assigning multiple locations to a one account

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

  1. Open fiori
  2. Got to Import Data for Consolidation – Business Partner Relationships 
  3. 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

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions