2013-02-21 - 5750 - Break Fix - NEP Production Issue - Table A552 #EMEA #ABAP #ABAPSUPPORT #SDSupport

5750 - NEP Locking Issue - Table A552

Summary Description

---

NEP performance has been impacted due to the dead update lock issue that happened in dialog server NECNEPA1.

Admin Info

---

Purpose	Unbuffer Table A552
Requested by	Thi Tran
Issue Date	02/11/2013
Resolved by	Surya Basa / Venkat Kondapally
Resolved Date	02/21/2013
Document Status	Complete

Detailed Description

(Include Screen Shots if required )

---

Table A552 is causing performance issues in NEP as it is being called by a FM (ZSD_INVENTORY_EXTRACT) used in program (ZSD_INVENTORY_EXTRACT_PRG). There's a piece of code pointing to one of the key fields in the table which is commented and is causing the performance issue.

Analysis and Recommendations

(Include Screen Shots if required)

---

The preliminary analysis was done by SAP and has recommended the following steps to fix the performance issue in NEP-
1. Unbuffer table A552
2. Uncomment the field WAERK in the code.
3. Create a new index on table A552 with the fields MANDT and MATNR if the field can't be uncommented.

Resolution

---

The following steps have been executed (confirmed by business)-
1. Unbuffer table A552.
2. The piece of code which is used in the FM has been commented (Development changes done in ReCAP 5591).

Release Information

---

Provide link here to Release Notes
2013-02-21 - 5750 - Rel Notes - NEP Locking Issue - Table A552