Distinct values from Itab

[Former Member]

How to obtain distinct values in internal tables like the

"SELECT DISTINCT" in Database tables?

[Former Member]

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

[dani_mn]

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]

HI,

1>sort itab by <field>.

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

[Former Member]

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]

Hi all,

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

Regards,

Pooja