Data cleansing part 1 – Customizing, cleansing case creation and processing

[gregorw]

Business Case

If you don’t use error tolerant search and duplicate check provided by SAP with mySAP CRM AddOn for Service Industries, CRM 5.0 or available from SAP Partners (Search for Sulution Category: “Address Services” in the Partner Information Center) it will happen that you get duplicate business partner entries. To clean them up you can use transaction BUPA_CLEAR in your mySAP CRM system.

Documentation

The documentation on Data Cleansing is available in the SAP Help Portal.

Customizing

Activate Duplicate Check Index Pool

Start transaction SPRO, open the SAP Reference IMG and navigate to SAP Web Application Server -> SAP Web Application Server -> Basis Services -> Address Management -> Activate Duplicate Check Index Pool:

To clean up Organizations this setting is fine. With the threshold setting you can define the percentage when record is identified as a duplicate. The value depends on the tool which implements the duplicate index.

Maintain Number Ranges

Next navigate to Cross-Application Components -> SAP Business Partner -> Data Cleansing -> Maintain Number Ranges in the IMG:

Enter the object name COM_CLEAR in the Number Range Object Maintenance and choose the pushbutton Number Ranges. Choose the pushbutton Change Intervals to maintain the number range interval. Create the number range interval 01 with internal number assignment and save your entries:

Define Priorities

Now go to Cross-Application Components -> SAP Business Partner -> Data Cleansing -> Define Priorities if you want to change the default:

Activate Duplicate Cleansing

As the last step in customizing check out Cross-Application Components -> SAP Business Partner -> Data Cleansing -> Activate Duplicate Cleansing:

Set Dependent to X to look up dependent Business Objects.

Correct Where-Used List View variant CLEARING

Unfortunately the default delivery comes with a error in the where-used list view variant CLEARING. This error causes the message “Customizing not avaliable (Table TBZ5*) when you leave the transaction BUPA_CLEAR. The solution is to start transaction BUSWU02 and double click on the View variant CLEARING:

On the right hand side click on the folder without description and click on the “Delete node” button:

Create cleansing case

Now we’re ready to create our first cleansing case. Start transaction BP and search for the business partners which you know that they are duplicates. In my Example it’s the “Metzgerei Grundner” (Butchery of my mother in law):

Mark both business partners and right click on them. Choose “Create data cleansing case” from the context menu:

In the next window you can enter additional information for this case like a Note and Priority:

When you confirm the window you will get a message that the clearing case was created:

Process cleansing case

Leave transaction BP and start transaction BUPA_CLEAR. Here you can do a search for the just created cleansing case. Double click on it and you will get this window asking if determination of referencing objects should be started. Please answer “Yes” to get all references.

Both partners are now opened side by side and you can use drag & drop to move i. e. business transactions from one partner to another:

In gregor.wolf3/blog/2006/04/15/data-cleansing-part-2-150-import-cleansing-cases-from-external-source I show how to create cleansing cases from external sources.