SAP C4C account duplication check and merging
This blog post gives a detailed approach on account duplication check and account merging.
Business Requirement: Clean and consistent data is the key check point in measuring the success of C4C implementation. We can see this in two folds
1) How clean and consistent is the data that has been migrated from external source?
2) Is the application has capability to help user to identify the duplicates while creating the master data?
Duplication check: This check will help users in identifying the duplicates while creating the masters like accounts/contacts, which helps avoiding duplicate entries.
Duplication check->Approach in C4C:
When you attempt to create an account or contact with details matching the existing record, users are notified that potential duplicate accounts were found. Users can decide whether the duplicates displayed can be used for further processing or he/she can continue to create new account by ignoring the duplicates displayed.
The following are the configuration steps required to make sure duplication check works during the creation of account/contact
Specify whether duplicate checks are to be performed with strong, medium or weak rules in Scoping.
Scope the Duplication check: > Business Configuration > Edit Project Scope > Questions > select the checkbox as per requirement
In the Business Configuration Scoping you can configure this threshold. You can choose if you want a Strong, Medium or Weak Duplicate Check for Business Partners.
Here are the respective thresholds:
‘Strong – Duplicate Check for Business Partners’:85%
‘Medium – Duplicate Check for Business Partners’: 80%
‘Weak – Duplicate Check for Business Partners’: 70%
The default setting is ‘Medium Duplicate Check for Business Partners’, i. e. a threshold of 80%.
Fine- Tuning settings:
The Duplicate Check considers below “nodes” (= collection of attributes) when calculating the similarity score: name, postal address, e-mail, fax, phone, birth date (only for persons), additional identifiers. I. e. It calculates the single similarity of the above mentioned nodes compared to an existing business partner on the database and finally aggregates the single similarities to a total similarity. In this step the nodes contribute to the total similarity with different weights which are configured in the Business Configuration Fine tuning “Duplicate Check Weighting For Business Partners”.
Front End Visibility for duplication check while creating account:
Account merging: Is the functionality of merging the identified duplicate records with the option of choosing the required attributes from any of the duplicate records. For the detailed explanation, please check the below information.
Account / Individual Customer / Contact Merge Use Case
In case there are multiple duplicate records for the same customer in C4C and this may results in inconsistencies in the system.
Merge functionality will enable duplicate records by merging them into a one record.
Customer Merge: – Configuration Steps
In order to enable customer merge in your tenant, go to
Scoping questions à General business Data à Business Partner à Handling of Business Partners and select the scoping question ‘Do you want to enable account merge’.
Once the scoping question is checked, you can assign the ‘Data Cleansing’ work center to the user who will be triggering the merge process in the tenant.
Steps to Perform: The following steps help you understand the procedure involved in identifying the duplicates and merging the as per the required attributes.
Step: 1 – Select more than one records from accounts search and initiate merge as per shown below. Give it a name.
On click and save the user will be navigated to the merge object attribute selection view.
A new Work center view called ‘Data Cleanse’ has been introduced to manage customer merge objects
Goto-> Data cleanse facet-> select the Merge object initiated from account facet.
- User has option to choose which records should be the master record.
- User has also options to select which attributes should be selected from which record and create the required record manually
- For example; the user can select business partner 1 as the master record and then choose that the address should be copied from business partner 2
- Step: 3 – User can then save the merge instance and trigger ‘Initiate Merge’
Result Log facet lists down the application logs created by the system for each Merge transaction execution.
It shows if the execution resulted in any errors, warning or any other information message.
User can check the complete log by clicking on the application log hyperlink and navigating to the Results section of the application log.
Once the merge completed successfully we can see the status of customer merge as completed.
After Customer merge is successful, all the duplicate records are merged with master record.
Step7: All the transactions like Leads, Opportunities, Quotations etc created with Business partner 2 ( slave) can no longer be in use as they are not allowed to change any further..
BP1 has 2 transactions (1 lead, 1 opportunity)
BP2 has 2 Transactions (1 opportunity, 1 Quote)
After merging BP1+BP2, where BP1 is chosen as the master and BP2 as slave. All the transactions created with BP1 as partner in transactions remains unchanged. Transactions created with BP2 as prospect/sold-to-party will not be allowed to edit any further, as BP2 has become in active.