Skip to Content
0
Nov 17 at 05:02 AM

Need help in optimizing the code

182 Views

LOOP AT gi_wtkt_sl_delete_msp INTO lwa_wtkt_sl_del.
DELETE FROM ztsd_wtkt_sl
WHERE zzvbeln EQ lwa_wtkt_sl_del-zzvbeln AND
zzposnr EQ lwa_wtkt_sl_del-zzposnr.
IF sy-subrc EQ 0.
g_no_deleted = g_no_deleted + sy-dbcnt.

DELETE gi_wtkt_sl_delete_fp
WHERE zzvbeln EQ lwa_wtkt_sl_del-zzvbeln AND
zzposnr EQ lwa_wtkt_sl_del-zzposnr. ENDIF.

ENDLOOP.

can you suggest how performance can be optimized for the above code.