Skip to Content
0
Former Member
Jul 22, 2008 at 03:07 PM

Delete duplicates and want to catch those records which are deleted

36 Views

my requirement is i have some records in an internal table which has some duplicate records.

so i want to delete those duplicate records using

Delete adjacent duplicate key word on itab1

and i want to catch those records into another internal table itab2 which has got deleted.

for examplz:

itab1 has

f1 f2 f3 f4

-


a b c d --- rec1

w x y z --- rec2

a b c d --- rec3

w x y z --- rec4

p q r s --- rec5

a b c d --- rec6

after deleting itab1 will have rec1 , rec2 and rec5

now itab2 should contain rec3,rec4 and rec6

Edited by: Jalaaluddin Syed on Jul 22, 2008 8:40 PM