SAP Note 1399677 - Agent Inbox: Performance CRM document search

Component : Agent Inbox -

Solution : https://service.sap.com/sap/support/notes/1399677 (SAP Service marketplace login required)

Summary :
This SAP Note addresses performance and search completeness issues in CRM document searches within the Agent Inbox. The primary issue involves extended search times, notably when searches are conducted without specifying a main category, and incomplete results under the same conditions. The reason is identified as an inadequate query in the reporting framework, compounded by effects from a previous note which modified how item data queries are handled. The resolution involves implementing both code and manual adjustments, specifically optimizing the data selection process based on the presence of partner data, adjusting how maximum hit values are managed in searches, and removing specific entries from the SMOFPARSFA table. This note also highlights the necessity of precise search criteria and recommends monitoring common searches via ST05 to ensure proper indexing.

Key words :
dyn method          dyn_inbox_status_hnr db tables        1leading table       crm_jestis setonly header         xonly itemjoin header guid    objnrjoin item guidfrom, software component   bbpcrm                        bbp / crm, db        crm_jest~inact = space, query reads item data, crm_jest~statdyn method        dyn_inbox_status_hcall, main category field blank, sel field         inbox_status_hname, crm_jest~remain fromcall, method manipulate_max_hits_frw, attached code correction

Related Notes :

1380798SAP CRM 7.0 SP-Stack 05 - Release Information Note