Delete Logic using COMIT

[Former Member]

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]

any clues plz

[Former Member]

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]

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.

• for remaining records in itab1 after looping

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