Get Example source ABAP code based on a different SAP table
ABAP_ITAB - Duplicate Unique Keys When lines are inserted into internal tables with a unique primary key or unique secondary key, duplicates can occur with respect to one or more of these keys. Depending on whether the insertion is a single record operation or a mass operation, the ABAP runtime framework reacts as follows to an attempt to insert an entry with duplicate key values:
First, it checks whether duplicate key values would occur with respect to the primary key. The system behavior is as follows depending on the operation:
When single lines are inserted using the variant
INSERT wa INTO TABLE itab
duplicate entries with respect to the primary key are ignored and sy-subrc is set to 4. This is often used to filter out duplicates when the table is constructed.
In all other cases, such as
INSERT ... INTO itab • idx INSERT LINES OF (bulk operation) APPEND COLLECT =, IMPORT (bulk operations)
the runtime error ITAB_DUPLICATE_KEY occurs.
A check is then made to see whether duplicate key values would occur with respect to any existing unique secondary keys. If this is the case,
an exception of the class CX_SY_ITAB_DUPLICATE_KEY is raised for the statements INSERT and APPEND if the operation is a single record operation.
For all other insert and assignment operations, particularly for all mass operations, the runtime error ITAB_DUPLICATE_KEY occurs.
ABAP_EXAMPLE_VX5 The first INSERT statement does not insert a line and sets sy-subrc to the value 4. The second INSERT statement produces a runtime error. ABEXA 01059 ABAP_EXAMPLE_END
