Hello,
Some users are facing performance issues in BBP_GET_STATUS_2 after application of SP05 of SRM 7.02 or after note 1749585 is applied.
This performance issue is occurring due to the following code, that has been introduced in note 1749585:
* set the source rel indicator to space for PRALT item if basic item is
selected and vice versa.
LOOP AT it_hlp_refdata INTO ls_hlp_refdata.
CLEAR ls_sc_refupdate.
lv_exp_update = abap_false.
SELECT SINGLE expsv_item_type orig_guid FROM bbp_pdigp
INTO corresponding fields of ls_basic_alt
WHERE guid = ls_hlp_refdata-guid.
IF ls_basic_alt-expsv_item_type = 'PRALT'.
SELECT SINGLE * FROM bbp_pdigp
INTO CORRESPONDING FIELDS OF ls_sc_refupdate
WHERE guid = ls_basic_alt-orig_guid.
IF ls_sc_refupdate IS NOT INITIAL.
ls_sc_refupdate-source_rel_ind = gc_clear_sourcing_flag.
lv_exp_update = abap_true.
ENDIF.
ELSE.
SELECT SINGLE * FROM bbp_pdigp
INTO CORRESPONDING FIELDS OF ls_sc_refupdate
WHERE orig_guid = ls_hlp_refdata-guid.
IF ls_sc_refupdate IS NOT INITIAL.
ls_sc_refupdate-source_rel_ind = gc_clear_sourcing_flag.
lv_exp_update = abap_true.
ENDIF.
ENDIF.
IF lv_exp_update = abap_true.
APPEND ls_sc_refupdate TO et_sc_refupdate.
ENDIF.
ENDLOOP.
There are many access to table BBP_PDIGP, which causes the performance issue when BBP_GET_STATUS_2 is executed.
You can check KBA 1934917 for more details on how to solve this issue.
