delete dupulicate

[Former Member]

Hi there

I'd like to delete with below condition.

*condition :

delete if aa field's data is duplicate.

but remain first data.

ex)

itab

-

---

aa bb cc

-

---

1 df fg (remain)

2 rw dsdf (remain)

2 wr sfg (delete)

2 2d dff (delete)

3 dd dh (remain)

1 d2 ref (delete)

4 dfsa sfs (remain)

plz tell me how.

[Former Member]

Hi,

Sort itab by aa.

Delete Adjucent duplicates from itab comparing aa.

Regards,

Satish

[Former Member]

hi,

you can do it with:

DELETE ADJACENT DUPLICATES FROM itable.

regards,

mae

[Former Member]

thank you