cancel
Showing results for 
Search instead for 
Did you mean: 

Need standard techniques for address duplicate checks.

Former Member

Hi ,

I need to use sap standard techniques for standardization and duplicate check.

I have checked the bogs

I have checked ,BUT000 index is active customizing table TSADRVGRPC.

But still show duplicate button ,no pop up is triggered.

Checked

IMG => SAP NetWeaver => Application Server => Basis Services => Address Management => Duplicate Check

BUT000 PARTNER index active 90,0 SAP Business Partner

BUT052 ADDRNUMBE index active Contact Person Relationships (SAP Business Partners)

are maintained.

Still i need to implement BUPA_ADDR_CHECK ?

or any other BADI's ?

Thanks,

Anitha.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ani,

In order to have duplicate check activated in your system, you would need a TREX server and an RFC created between CRM and TREX. Once its in place follow steps:

1. Goto SPRO->SAP NETWeaver->Application Server->Basis Services->Address Management->Duplicate check

Here maintain limit for duplicates. Say if you maintain 70 here then only partners above similarity of 70% would be shown as duplicates.

2. Activate Badis Address_search and address_update. If you dont want to activate these badis then create custom implementation of them.

3. Go to t code SES_ADMIN.

Here go to->customizing->system settings and give details like name of RFC connetion between crm and TREX server and then search engine as CL_COM_SE_TREX.

come back and again in customizing->business addresses and indexes, create business object named BAS_BUPA with class CL_IC_INDEX_SES. Once you create this entry go to settings subnode and maintain object type as 1.

Now come back to Ses_admin main screen and from top menu select index->create/activate indexes. Here select bas_bupa.

4. Click on index immediately.

5. Run report SIC_BAS_RSADRINI.

See the magic of TREX...Duplicate check would start working...

Now for standardization you can do it directly from SAP except for postal code, region, country but not for free text like street address, house number(Functional consultant can do it in SPRO). If you need this functionality then you need to have interface with third party system.

Hope that helps,

Regards,

BJ

Former Member
0 Kudos

Thanks Andrey and bhushan.

We are not using any trex server.

I have implemented BADI address_search ,dint write any code.

and also kept external breakpoint in the method address serach.

Tried to created BP and save ,but badi dint get triggred ,any external debugger dint start.

How to check if it has got triggered?

Former Member
0 Kudos

Hi,

If you are not using TREX then address search would not be of any use for duplicate check i believe.

Without seach tool you wouldn't be able to implement error tolerant search. What i mean by that is - if street address is '21st street' then user can enter it as 21 Strt/ 21st str... for users its all the same..

If you write your logic then you would end up in writing select queries(performing exact search so u would never get a duplicate for 21st street if user enters it as 21 street) hence scope of getting possible duplicates would be less.

Please talk to concerned people, if this functionality is required then either you need to have TREX or a third party tool. There is nothing you can do with sole SAP CRM.

Hope that helps.

Regards,

BJ

Former Member
0 Kudos

Thanks Bhushan for your inputs.

Req is :

The fields to capture the Address and communication data already exist in the Account page. Once the user enters these fields and hits enter/or clicks the save button, the Address standardization logic will be called. If the address information is incorrect, a pop-up will appear to display the Original Address v/s Validated Address.

Address check needs to be performed on the following address related attributes:

Street, City, Region, Postal Code and Country.

The user will have an option to choose between the validated and original address.

For Address standardization logic

ADDRESS_CHECK has to be implemented?

Once the user enters these fields and hits enter/or clicks the save button, first the Address standardization logic will be called. The address is corrected, if required, and then the de-duplication check will be performed. In case of duplicate records, the u201CShow Duplicatesu201D will become active.

De-duplication check will be done based on the accountu2019s General Data, Main Address and Communication Data

So now which BADI should i implement address_check ,address_search or bupa_addr_check?

Former Member
0 Kudos

Hi Anil,

As I stated earlier. for de duplication logic you need to have some search engine associated with SAP CRM.

In order to have your address standardization work, you would end up in UI enhancement and address_check badi.

As far as Badi for deduplication is concerned, address_search is the correct badi.

Hope that helps.

Regards,

BJ

Answers (1)

Answers (1)

VishnAndr
Active Contributor
0 Kudos

Duplicate check is not a part of standard SAP CRM.

It should be implemented by yourself or any providers.

SAP only provides the BAdI interfaces for the functions described here. The implementation of the functions of the software connected by the interfaces is the responsibility of the providers or writers of this software. This description of functions refers to the functions proposed in the specification of the interfaces.

Refer to [this help topic on help.sap.com|http://help.sap.com/saphelp_crm70/helpdata/EN/c8/13b237b9a9a968e10000009b38f8cf/frameset.htm]. Check "Address Checks" in general. And "Checks Using Business Add-Ins" for duplicate check.

Former Member
0 Kudos

Thanks Andry ,

I need to trigger a pop up,i.e i have a show duplicate button on bp accounts page.

"Show Duplicate" Button you have to activate the BUT000 index in customizing table TSADRVGRPC.

IMG => SAP NetWeaver => Application Server => Basis Services => Address Management => Duplicate Check

done the steps.

but no pop up triggered.

Thanks,

Anitha.

VishnAndr
Active Contributor
0 Kudos

There is no standard algorithm in SAP CMR 7.0 for duplicate check. There is just nothing there.

All these customizations probably will be needed when you implement the BAdIs mentioned in help topics above. Or probably not. It depends on the implementation.

As mentioned here http://help.sap.com/saphelp_crm70/helpdata/EN/b1/eda43ab9db4814e10000000a11402f/frameset.htm (check the thread below this link - it's really usefull for understanding) you need to implement BAdI ADDRESS_SEARCH. And its method ADDRESS_SEARCH has exporting parameter "The hit list". This is a list of duplicates which system will show you in UI. Or you can implement this dialog by your own there and provide the result in "The selected address" parameter.

The main idea is: you implement BAdI ADDRESS_SEARCH and then in method ADDRESS_SEARCH implement some logic for the duplicate check. It can be simple selects or it can be some sort of connection to external services.

To convince you: till there isn't any implementation of ADDRESS_SEARCH BAdI the button "Show duplicates" will not be available at all in WebUI. As I remember.

Also you can refer to the [Note 176559 - Interfaces for Business Address Services|https://service.sap.com/sap/support/notes/176559].

VishnAndr
Active Contributor
Former Member
0 Kudos

We use the TREX search for duplictates, while the show duplicates icon is not active on the Accounts, implementing note 1629853 - "Show Duplicates button not working in Contact" made the button active on the contacts page,   I'm going to ask my developer to activate ADDRESS_SEARCH to see if that activates the icon on the account page.

Are the possible duplicate accounts stored in any table? where we could create a report to review the possible duplicates versus providing the data to a 3rd party to manage.