SAP Knowledge Base Article - Public

2914401 - After Account Merge is Completed, is it Possible to Capture in a Report the Respective Business Partner IDs Involved in the Merge Activity?


You performed the Customer Merge and your requirement is a report to view the Business Partner IDs involved in the merge and the date on which the Customer Merge was initiated.


SAP Cloud for Customer

Reproducing the Issue

  1. Go to Data Cleansing work center
  2. Go to Customer Merge view
  3. Find the Merge ID
  4. Status is Completed
  5. There is no option to Export to Microsoft Excel in Data Cleansing work center to view the Business Partners involved in the merge.


There no standard report or data source available on Customer Merge.


Data Workbench export can serve as report for Customer Merge execution. During Account Merge you are creating a Relationship of Category 'is Replaced By'. Relationships are only created and not updated. So there is no difference between CreatedOn / ChangedOn.

You may perform a Data Workbench Export, constraint on RelationshipType equal to BUR013 (Replacement Relationship) + EntityLastChangedOn (CreatedOn) to restrict the creation.

  1. Go to Data Workbench workcenter
  2. Go to the Export view
  3. Search for the object Business Partner Relationship
  4. Select the radio button Select Data
  5. Apply the filters
  6. Example:
  7. Relationship Type Equal to BUR013 - Replacement Relationship
  8. Entity Last Changed On Between DD1.MM1.YYYY1 - DD2.MM2.YYYY2
  9. Select Next
  10. Select Yes
  11. Select Export Data
  12. Go to the Monitor tab
  13. Download the exported file

You can find the Business Partner IDs involved in Customer Merge and the date as on which the Merge was created in Data Cleansing.


Replacement Relationship, Business Partner, Account Merge, Customer Merge, Data Cleansing, BUR013, Relationship Type, Business Partner Relationship, CreatedOn, ChangedOn, Data Workbench, EntityLastChangedOn , KBA , replacement relationship , account merge , bur013 , business partner , customer merge , data cleansing , relationship type , changedon , createdon , entitylastchangedon , business partner relationship , data workbench , LOD-LE-BP-MRG , Business Partner Merge , Problem


SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions