Remove Duplicate Business Partners Using Cleansing Cases in SAP CRM 5.0 and 7.0

  • by Veeranna Battula, SAP CRM Senior Consultant
  • November 16, 2011
Learn three methods for removing duplicate business partners in SAP CRM: SAP CRM 5.0’s BUPA_CLEAR transaction, SAP CRM 7.0’s Merge Accounts function, and SAP CRM 7.0’s Duplicate Check function. Also sample the functions in SAP CRM 7.0’s Data Quality Administration Framework.
Key Concept
Cleansing case management is a framework that helps you to effectively consolidate duplicate account and employee records and automatically archive the redundant records in the background.

Clean business partner data is vital to the success of any organization, especially in handling customer relationships. Although a company may maintain data that is relevant and current, corrupt or inaccurate records may exist owing to multiple means of data collection, incorrect data entry, or failure to check for preexisting records before entering a new business partner.

Companies must therefore identify incomplete, inaccurate, or irrelevant parts of the data, and they must then replace, modify, or delete them. This process is called data cleansing. You can identify duplicate records for accounts or employees, consolidate the duplicates into a single record, and archive redundant records, thus ensuring that your data is consistent. A single instance of potential duplicates that need to be cleansed is called a cleansing case.

SAP CRM has several tools for creating and executing cleansing cases, three of which are explained in detail in this article. These tools are the transaction BUPA_CLEAR in the SAP CRM 5.0 GUI and the Merge Accounts and Duplicate Check functions in the SAP CRM 7.0 Web UI. All three provide an effective way to remove duplicate business partners without purchasing third-party software. I also briefly mention the Data Quality Management functions in SAP CRM 7.0, but explaining how to use them step-by-step is beyond the scope of this article.

This article covers cleansing cases in SAP CRM 5.0 and 7.0. To learn how to execute cleansing cases in SAP CRM 2005, see Jan van Hoof’s article, “3 Steps to Cleaner Data (and Happier Customers).”

Veeranna Battula

Veeranna Battula is an SAP CRM senior technical consultant with more than six years of experience in design, development, and implementation of SAP CRM 5.0, 6.0, and 7.0 enhancement package 1. He has hands-on technical and functional experience in SAP CRM Lead, Opportunity, Activity, Business Partner, Base Customizing, Sales Order, Quotation, Pricing, Campaign, Target Group, External List Management, and Service processes, as well as CRM Web UI BOL programming.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.