Skip to Content

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

Scoping

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.

Step2:

 

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’

Step: 4

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.

Step: 5

Once the merge completed successfully we can see the status of customer merge as completed.

Step: 6

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..

Example:

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.

7 Comments
You must be Logged on to comment or reply to a post.
  • Dear Venkata,

    Thank you for this wonderful blog and introducing to me a great feature.

    I just have a one question, does the records of BP2 are getting deleted after the merge or is it still remaining in the system?

     

    Best regards,

    Daniel.

  • Hi Daniel

    No we cannot delete master data records in C4C , we mark BP2 as obsolete so that the record is not usable for any business process at a later stage .

    Regards

    Ajitabh

  • Hello,

    Is it possible to enable Duplicate check only for Accounts creation and not for contacts? I see scoping is done for BP altogether but I wanted to check.

    Thanks,

    Ravi

  • Thank you for this post. Does it also work for individual customers? We have a use case for merging individual customers that are automatically added to the system via social media channel integration. I am assuming we cannot de-duplicate them as they are being added via web-services automatically, not manually; however a manual merge as shown in your post could help.

     

  • Hi Venkata,

    Please suggest how this duplicate check feature can be used while mass upload of Accounts/ Contacts etc. Will system check the duplicate records and provide a log for the same?

    Thanks,

    Hemant