topic Re: Distinct values from Itab in Application Development and Automation Discussions

Distinct values from Itab

Former Member — Sat, 30 Sep 2006 05:11:08 GMT

How to obtain distinct values in internal tables like the

"SELECT DISTINCT" in Database tables?

dani_mn — Sat, 30 Sep 2006 05:14:47 GMT

HI,

you can use DELETE ADJACENT to delete duplicates and the remaining will be distinct values.

SORT itab by field.

DELETE ADJACENT-DUPLICATES FROM ITAB.

Regards,

Former Member — Sat, 30 Sep 2006 05:22:44 GMT

HI,

1>sort itab by <field>.

2>delete adjacent duplicates from itab comparing <field>.

Former Member — Sat, 30 Sep 2006 05:47:12 GMT

Hi Pooja,

Two ways to do this :

1. You can sort the internal table by the fields you want and then delete the adjacent duplicates comparing those fields by which you sorted.

sort <internal table> by field1> <field2>.

Delete adjacent duplicate values from itab comparing <field1> <field2>.

2. If you need to consider all fields of the internal table,

sort itab

Delete adjacent duplicate values from itab comparing all fields.

BR,

Preema

*Reward points for helpful answers

Former Member — Sat, 30 Sep 2006 06:21:17 GMT

Hi all,

Thanks for all your answers. I am getting an error while rewarding points. I will try again later.

Regards,

Pooja