Finding duplicates in internal table
With Release 7.40 SP08 you can use the GROUP BY statement in a LOOP to find duplicates. In this example we are looking for duplicates with the same MATNR.
LOOP AT lt_tab INTO ls_tab GROUP BY ( matnr = ls_tab-matnr size = GROUP SIZE ) ASCENDING REFERENCE INTO DATA(ls_ref).
IF ls_ref->*-size > 1.
"Duplicate found. Key is in ls_ref->*-matnr and the amount is in ls_ref->*-size
ENDIF.
ENDLOOP.