topic Re: Delete Logic using COMIT in Application Development and Automation Discussions

Delete Logic using COMIT

Former Member — Fri, 14 Dec 2007 06:57:40 GMT

I will have 1000's of recs in an itab .

many sales orders data and many recs for each sales order.

and i have to delete the corresponding recs from database based on 2 conditions.

1. for each sales order, leave the latest rec and delete all other recs 4m DB

2. am asked 2 perform commit after every 500recs.

how can I use this commit logic.

thanks

kiran

Former Member — Fri, 14 Dec 2007 07:20:25 GMT

any clues plz

Former Member — Fri, 14 Dec 2007 07:28:15 GMT

Hi Kiran, do something like this :


data : w_count type i.

loop at itab.
if w_count = 500.
commit.
clear w_count
endif.

endloop.

Hope this helps,

Erwan

Former Member — Fri, 14 Dec 2007 07:35:23 GMT

loop at itab .

at end of itab-vbeln.

continue.

endat.

move itab to itab1.

append itab1.

if sy-tabix mod 500 EQ 0.

delete DBtab from itab1.

commit work and wait.

refresh itab1.

endif.

endloop.

delete DBtab from itab1.

commit work and wait.

**hope the logic helps. but this is not advisable to do on std tables, do only on Ztables