Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Perfomenec with update Set stamnt

Hi ,

I am using the below in LOOP . But it is taking long time to update the data base. Can I use Modify instead of below code.

UPDATE MARC CLIENT SPECIFIED

SET ZC_LT = W_ZC_LT_F

ZT_LT = W_ZT_LT_F

WHERE mandt = sy-mandt

and MATNR = IT_STB-MATNR

AND WERKS = IT_STB-WERKS.

Here I am updating the MARC Table. I Used Locks also to over the issue. When ever Cursor come to the Update stamt it is going to be time out . Please advice me in this.

regards,

Ajay

Edited by: Ajay on Oct 8, 2008 4:40 PM

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question