cancel
Showing results for 
Search instead for 
Did you mean: 

BP search is slow

Former Member
0 Kudos

Dear All,

we are running SAP CRM 7.0 EHP2. The number of BP records is 1.4 million .

We have implemented TREX search .

Still we face issues in BP search .

BP search by first name is taking approx 12 seconds and search by Last name is taking approx 65 seconds


Is there any specific reason why search by Last name is taking more time compared to search by First name ?

It is  more important for the business to search by last name rather than first name.

we are not able to find the switch (SFW5) CRM_SEARCH_1 which corresponds to the new Enterprise Search functionality recommended by SAP.

Is there any possibility to activate Enterprise search in SAP CRM 7.0 EHP2 ?

Any ideas that would speed up the BP search would be very much appreciable.

Thanks in advance

Santhosini K

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Santhosini,

Please see the below pasted...

Symptom

Composite SAP note for the improvement of the performance during the business partner search.

Other terms

CIC, BP, BUPA, performance, partner search, business partner BP_DIALOG

Reason and Prerequisites

Different notes exist on the performance of the business partner search.
The following text explains the most important notes for the performance improvements of the business partner search briefly.

For a fast business partner search, some notes must be active in the CIC:

Solution

552957 'SAP BP: Performance BAPI_BUPA_SEARCH (*-Search for partners)' (Release 6.20)
If you use function module BAPI_BUPA_SEARCH to find all business partners (*), perrormance problems may occur.
Implement the corrections of this note.

513052 'SAP-BP: BAPI_BUPA_SEARCH: Search for postal code & MC_NAME1' (Release 620) (POSTL_COD1) with module BAPI_BUPA_SEARCH or BUPA_SEARCH The problem is caused by a program error. Implement the corrections of this note.

555241 'SAP BP: BAPI_BUPA_SEARCH: Perform.(Search for country and..)' (Release 620)
If you use module BAPI_BUP A_SEARCH to find a country and a further attribute, for example, e-mail, which is not an address attribute, performance problems may occur.
Solution: Implement the program corrections of this note or import the corresponding Support Package.

535827 'Performance CIC BP Search' (BBP/CRM 310)
When you carry out actions in the 'Enhanced business partner' tab of the CIC, sometimes, an unrequired communication between Frontend (HTML control) and backend occurs. This has a negative impact on the performance of functions, for example, the business partner search.
Solution: see the corresponding note (Relevant for CRM 3.0 and 3.1).

559583 'Performance CIC BP Search' (BBP/CRM 310)
If an inbound call triggers a business partner search in the CIC and if the Customizing settings enforce an automatic confirmation of the search, the results are published twice to the other applications in the CIC framework which can have a negative impact on the performance of the confirmation step in some cases (for example, if the alert modeler is running).
Solution: The problem is caused by a program error. Implement the corrections attached to this note..
(Included in SAPKU30013, SAPKU31003)

562492 'Performance CIC BP Search' (BBP/CRM 310)
The business partner search does not have the corresponding performance.
Solution: Please see corresponding note.
(Relevant for CRM of 3.0 and 3.1)

566788 Performance CIC BP Search (BBP/CRM 310)
The business partner search, confirmation and reset do not have the corresponding performance.
Solution: Implement the corrections attached to this note.
(Included in SAPKU30013, SAPKU31003)

also check the following note:

525673 Indexes on address tables (BBP/CRM 310)
The performance during the search for address data is bad.
Which indexes for the address tables does SAP deliver by default?
Which recommendations exist concerning the creation of further indexes? Soution: see the corresponding note (release-independent)

In certain cases, you can also check the following notes:

489074 SAP-BP: Performance problem BAPI_BUPA_SEARCH (BBP/CRM 2.0C)
Function module BAPI_BUPA_SEARCH is only called with wildcards, for example, for the address data (example: City = *). Then the system selects all business partners. This selection can take very long.
Solution: Implement the advance correction attached to this note or import the Support Package specified in the note (CRM 2.0C)

493639 SAP BP: BAPI_BUPA_SEARCH: Performance(Rel.620)
If the call is not suitable, BAPI BAPI_BUPA_SEARCH may try a bit longer to findm, for example, Miller and asterisk (*) for the city.
Solution: Consider that this is a modification which is not included in the standard system.
(SAP basis 620, 50A, 46C -> All Support Packages)

496777 SAP-BP: BAPI_BUPA_SEARCH: Performance (unnecessary SELECT)(Rel. 50A)
The problem is caused by a program error. This is a subsequent error of Note 481533. The system unrequiredly processes the address numbers for address-independent communication data without searching for communication data.
Implement the corrections attached to this note or import the corresponding Support Package.
(Included in SAPKA50A16)

523562 'SAP BP: BAPI_BUPA_SEARCH -> incorrect search' (Rel.620)
If you use module BAPI_BUPA_SEARCH or BUPA_SEARCH to find address-independent communication data and address data at the same time, no business partner is found.
Solution: Implement the correction attached to this note or import the corresponding Support Package.
(Included in SAPKA50A21, SAPKA62004)

431537 'Error when reading address data for partner' (Rel.50A)
When the system reads address data for the business partner, it always determines the current data status.
Cause and solution: BUA_ADDRESS_READ_ALL and BUA_ADDRESS_READ are incorrect. Corrected with 6.20

Related Notes
766827Composite SAP note: Performance SCM 4.0
566788Performance CIC BP Search
562492Performance CIC BP Search
559583Performance CIC BP Search
555241SAP BP: BAPI_BUPA_SEARCH: Perfrmce(Search for country and..)
552957SAP BP: Performance BAPI_BUPA_SEARCH (*-Search for partners)
535827Performance CIC BP Search
525673Indexes on address tables
513052SAP-BP: BAPI_BUPA_SEARCH: Search for postal code & MC_NAME1
496777SAP-BP: BAPI_BUPA_SEARCH: Performance (unnecessary SELECT)

Hope it useful for you...

Thanks,

Vijay SR

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi San,


Enterprise Search is available from SAP CRM version 7.0.

former_member186543
Active Contributor
0 Kudos