Performance issue while deleting Work center from CR02.

[Former Member]

While trying to delete a work center(ARBPL) from T-Code CR02, the time taken is around an hour or so. Was not able to find any related SAP notes for the same. Any help would be appreciated!!!

SAP ECC 6.0

[Private_Member_49934]

It's very unlikely that there are performance problem due to standard sap. One hour for deleting one entry might not be due SAP standard code.

Check if any exit or Badi is activated for the transaction. One I faced such a situation where inside an exit a select was done with FOR ALL ENTRIES and the  table used for for all entires was initial.

Such things might be causeing problem in your system.

[Former Member]

Use transactions SE30 or ST05 analyze in which statements you have problem in performance.

[yuri_ziryukin]

I'd say better use transaction ST12: http://wiki.sdn.sap.com/wiki/display/ABAP/Single+Transaction+Analysis

[HermannGahm]

Hi,

get the STAD record as a start for you analysis. Then take traces ...

Kind regards,

Hermann

[Former Member]

Thanks for your quick responses. I did run ST05 and SE30. It seems max time is taken on two select queries.

In include LCRA0F25

  SELECT SINGLE * FROM AFRU WHERE ARBID = OBJID_CRHD.

  IF SY-SUBRC = 0.

    FLG-ARBPL_USED = KREUZ.

    EXIT.

  ENDIF.

  SELECT SINGLE * FROM CATSDB WHERE ARBID = OBJID_CRHD.

  IF SY-SUBRC = 0.

    FLG-ARBPL_USED = KREUZ.

    EXIT.

  ENDIF.

Gaurav: There is no BADI or enhancement spot being used.

Will run STAD and ST12 today and post findings soon. Thanks for this info.

[HermannGahm]

Hi,

how much percentage of the total run time is spent on these selects? (look it up in SE30).

For AFRU:

Make sure index AFRU~3  on columns MANDT, ARBID is active (created) on your DB.

For CATSDB:

Make sure index CATSDB~6 on columns MANDT, ARBID is active (created) on your DB.

Use SE14 to activate the indexes (if they don't exist on your DB).

Kind regards,

Hermann

[Former Member]

Hi

Check the SAP note 539564

[yuri_ziryukin]

He can also do Explain in ST05 for both statements

And mention the numbers that one can see in ST05 statement summary.

[Former Member]

Hi..

Thanks guys  we have updated the index and now its working fine