Delete duplicates excluding columns

576 Views Asked by At

I am trying to delete duplicates from an internal table, comparing all columns excluding some of them. Obviously I can list all the columns that I want to compare using COMPARING, but this would not look good in code.

So let's say there are 100 columns and I want to exclude from the comparing 2.

How can I achieve that with a smart way?

1

There are 1 best solutions below

0
Wahalez On

You could use the DELETE ADJUSTMENT DUPLICATES operator, there you can define which columns you compare. You'll just have to sort the itab before this operation.