2661115 - SBWP / My Inbox Fiori application performance is slow

Symptom 1:

• SBWP transaction initial load is slow.
• Performance is slow when navigating in user Inbox (switching folders, selecting workitems, etc.) or starting workflows.

AND

• Experiencing high execution time (in SE30, SAT, ST12 traces) in case of SELECTs on HRP1001 table (Include LRHASF00, Function module RH_READ_INFTY_1001_EXT).
  
  

Symptom 2:

• My Inbox tile opening is slow (even the Inbox is empty).

AND

• Experiencing high execution time (in SE30, SAT, ST12 traces) in case of SELECTs on SWWUSERWI table (Include LRHW9F01) OR  in case of SELECTs on SWWORGTASK table (Function module RH_WI_SWWORGTASK_SELECT)

• SAP Business Workflow
• SAP NetWeaver
• SAP Web Application Server for SAP S/4 HANA
• Database independent
• ABAP PLATFORM - Application Server ABAP
• Task Gateway
• My Inbox Fiori application / Business WorkPlace (Transaction SBWP)
• SAP Note 2469106 corrections are implemented (manually or with Support Package)

SWF_WORKFLOW, SELECT * FROM hrp1001 CLIENT SPECIFIED "#EC CI_CLIENT, SELECT * FROM hrp1001 CLIENT SPECIFIED, Unique Index HRP1001~0, SBWP performance loss after upgrade, Business Workplace execution time SWD_NODES, SAPLSWDB_RUNTIME DB, SWD_PROPTS, SWD_BINDEF, SWD_LINES, SWD_EXPR, SWD_CONDEF, RH_HRS_DESCRIPTION_READ, SAPLSWDO_RUNTIME DB, SAPLRHWR, SAPLRHWS, SAPLSWL1, SWD_HEADER, SAPLRHAS, SAPLSEUS, SAP_GWFND, IW_PGW, /IWPGW/TGW, /IWWRK/WORKFLOW, WF_GDPR, SELECT * FROM SWWUSERWI INTO TABLE ACT_USER_WI, LOOP AT LOC_USER_TAB, SAPLRHW9 DB, FOR ALL ENTRIES IN USER_TAB, My Inbox slowness, SELECT * FROM swworgtask, FOR ALL ENTRIES IN task_objects, FUNCTION RH_SWWUSERWI_FILL_FOR_USER, METHOD /IWWRK/IF_TGW_RFCS~WF_TGW_QUERY_TASKS, FUNCTION /IWWRK/WF_TGW_QUERY_TASKS , KBA , BC-BMT-WFM , Business Workflow , BC-BMT-OM , Organizational Management , OPU-BSE-WFM , Gateway Business Workflow Enablement , OPU-BSC-TGW , Task Gateway , Problem