Business Partner records with large numbers of addresses -- Move-in issue

[Former Member]

Friends,

Our recent CCS implementation (ECC6.0ehp3 & CRM2007) included the creation of some Business Partner records with large numbers of addresses. Most of these are associated with housing authorities, large developers and large apartment complex owners. Some of the Business Partners have over 1000 address records and one particular BP has over 6000 addresses that were migrated from our Legacy System. We are experiencing very long run times to try to execute move in's and move out's due to the system reading the volume of addresses attached to the Business Partner. In many cases, the system simply times out before it can execute the transaction. SAP's suggestion is that we run a BAPI to cleanse the addresses and also to implement a BADI to prevent the creation of excess addresses.

Two questions surrounding the implementation of this code. Will the BAPI to cleanse the addresses, wipe out all address records except for the standard address? That presents an issue to ensure that the standard address on the BP record is the correct address that we will have identified as the proper mailing address. Second question is around the BADI to prevent the creation of excess addresses. It looks like this BADI is going to prevent the move in address from updating the standard address on the BP record which in the vast majority of cases is exactly what we would want.

Does anyone have any experience with this situation of excess BP addresses and how did you handle the manipulation and cleansing of the data and how do you maintain it going forward?

Our solution is ECC6.0Ehp3 with CRM2007...latest patch level

Specifically, SAP suggested we apply/review these notes:

Note 1249787 - Performance problem during move-in with huge addresses

**applied this ....did not help

Note 861528 - Performance in move-in for partner w/ large no of addresses

**older ISU4.7 note

Directly from our SAP message:

use the function module

BAPI_BUPA_ADDRESS_REMOVE or run BAPI_ISUPARTNER_CHANGE to delete

unnecessary business partner addresses.

Use BAdI ISU_MOVEIN_CUSTOMIZE to avoid the creation of unnecessary

business partner addresses (cf. note 706686) in the future for that

business partner.

Note 706686 - Move-in: Avoid unnecessary business partner addresses

Does anyone have any suggestions and have you used above notes/FMs to resolve something like this?

Thanks,

Nick

[william_eastman]

Nick:

One thing to understand is that the badi and bapi are just the tools or mechanisms that will enable you to fix this situation. You or your development team will need to define the rules under which these tools are used. Lets take them one at a time.

BAPI - the bapi for business partner address maintenance. It would seem that you need to create a program which first read the partners and the addresses assigned to them and then compares these addresses to each other to find duplicate addresses. These duplicates then can be removed provided they are not used elsewhere in the system (i.e. contract account).

BADI - the badi for business partner address maintenance. Here you would need to identify the particular scenarios where addresses should not be copied. I would expect that most move-ins would meet the criteria of adding the address and changing the standard address. But for some, i.e. landlords or housing complexes, you might not add an address because it already exists for the business partner, and you might not change the standard address because those accounts do not fall under that scenario. This will take some thinking and design to ensure that the address add/change functions are executed under the right circumstances.

regards,

bill.

[Former Member]

Bill,

Very helpful. Thanks!

Nick

[Former Member]

We never really found an easy fix. Our dev team wrote some programs to manually clean these BPs up.