Spend Management Blogs by SAP
Stay current on SAP Ariba for direct and indirect spend, SAP Fieldglass for workforce management, and SAP Concur for travel and expense with blog posts by SAP.
cancel
Showing results for 
Search instead for 
Did you mean: 
ricardo_cavedini
Employee
Employee

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.

6 Comments