Skip to Content
avatar image
Former Member

How To Identify Duplicate Business Partners (Contact Persons)

Hi Gurus,

We are in CRM 7.0 SP4, B2B scenario and currently have several duplicates for same contact persons which may or may not be assigned to same account! Per process the criteria to identify duplicate is based on first name and last name. For correction we are sure to use the CRM BUPA cleansing cases so the challenge limits us to identify(major!)

I have couple of ides in mind however not sure if it is well worth to start on them. Here are some:

1. Use an excel based fuzzy search plugin to identify data in a spreadsheet and identify duplicates

2. Use abap code with TREX to figure out duplicates for every contact person and gather a list of them

3. Use the Data Quality Workbench

4. Use a third party data cleansing tool. (At this point, not sure which one)

Has anybody experienced similar situations like this before. If yes any suggestions you would like to contribute here?

Thanks for reading my thread.

Cheers 😊

Ankur

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 19, 2010 at 07:32 PM

    Hello!

    You can identify duplicate Contact Persons also with the help of Data Quality Administration and integrate the Netweaver Duplicate-Check (based on TREX).

    Please see also the blogs:

    CRM 2007: Different use-cases for merging duplicate Account Records

    [/people/arno.meyer/blog/2008/09/11/crm-2007-different-use-cases-for-merging-duplicate-account-records|/people/arno.meyer/blog/2008/09/11/crm-2007-different-use-cases-for-merging-duplicate-account-records]

    CRM - Why is it so important to take care for Data Quality?

    [/people/arno.meyer/blog/2009/10/01/crm--why-is-it-so-important-to-take-care-for-data-quality|/people/arno.meyer/blog/2009/10/01/crm--why-is-it-so-important-to-take-care-for-data-quality]

    Best regards,

    Arno

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2010 at 11:04 AM

    You can set simple duplicate check also just within CRM by implementing badi address_search and writing your ownlogic in it. But of course it would be hard to check similar records. But if it's enough to find the records that are exacly the same, then you could use also this approach.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2010 at 11:45 AM

    Hello!

    Regarding 3rd-Party Tools you can also check this Page:

    [http://www.sap.com/partners/directories/SearchSolution.epx|http://www.sap.com/partners/directories/SearchSolution.epx] about Partner Solutions.

    You can also find additional Information about

    [SAP BusinessObjects Data Quality Management|http://www.sap.com/solutions/sapbusinessobjects/large/information-management/data-quality-management/dqm/dataqualityforsap/index.epx].

    This is also one powerful option in this context.

    Best regards,

    Arno

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you Arno for links. I have already looked at them and I am still seeking a way to figure out duplicates in a massive database.

      I would also check for business objects solution to see if we could leverage that in our scenario.

      Cheers 😊

      Ankur