Skip to Content
0
Mar 25, 2009 at 12:20 PM

Problem with displaying duplicate entries in an internal table

31 Views

Hi,

I have requirment to display only the duplicate entries in an internal table.

I will give an example scenario to explain this.

I have an internal table with name say t_xyz

In this internal table I have few fields say a b c d e

Data in the internal table is shown below

a b c d e

1 1 2 3 4

1 1 3 4 5

1 2 3 4 6

1 3 4 4 6

2 3 4 5 6

2 3 4 7 8

If I select the fields a and b, I have to display the possible duplicate records for those two fields in the output as shown below

1 1 2 3 4

1 1 3 4 5

2 3 4 5 6

2 3 4 7 8

Similary if i select some other two fields, I have to display the possible duplicate records for those two fields.

Finally the main requirment is, I dont want to transfer the contents in to a new internal table.

I want to have the same internal table,but I wanted to delete the entries which are not duplicates leaving all the duplicate entries.

Can any one give me best possible solution to achieve this scenario.