Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Processing Internal Data →  Internal Tables →  Processing Statements for Internal Tables 


Short Reference

Other versions: 7.31 | 7.40 | 7.54


INSERT line_spec INTO itab_position


This statement adds one or more rows line_spec to a position itab_position in an internal table. The position can be specified using the primary table key or a table index. Use result when appending a single row to set a reference to the appended row in the form of a field symbol or a data reference.

When the row is in inserted, all existing unique table keys are checked. These can be a primary table key and multiple unique secondary table keys. The system handles any duplicates of the various key according to the following hierarchy:

  • If attempting to insert a single row using a primary key would result in duplicates with respect to the unique primary key, no row is inserted and sy-subrc is set to 4.

  • If attempting to insert a single row using the key or the index would result in duplicates with respect to a unique secondary key, a handleable exception of the class CX_SY_ITAB_DUPLICATE_KEY is raised.

  • If the attempt to insert a single row (using an index) or multiple rows (as a block) would result in duplicates (in terms of a unique primary or secondary key), a runtime error occurs.
  • System Fields

    sy-subrc Meaning
    0 One or more rows werer inserted.
    4 No row was inserted because either a row of the same unique key already existed when inserting singlerows using the primary key or the specified index was greater than the current number of rows plus one when inserting the rows using the table index.

    The system field sy-tabix is not set.


    The administration of an unique secondary table key is updated immediately (direct update) and the administration of a non-unique secondary table key is updated at the next explicit use of the secondary table key (lazy update). The runtime costs for the creation or updating of a non-unique secondary table key are therefore first incurred when it is first used. (See Internal Tables, Deleting Rows Using Keys).


    Inserts single rows in a standard table int_tab using the table index and inserts references to these rows in a hashed table ref_tab using the table key. The output in the LOOP loops results in the numbers 10 to 1 for int_tab and the numbers 1 to 10 for ref_tab.

    DATA: int  TYPE i, 
          dref TYPE REF TO i. 
    DATA: int_tab LIKE STANDARD TABLE OF int, 
          ref_tab LIKE HASHED TABLE OF dref 
                  WITH UNIQUE KEY table_line. 
    DO 10 TIMES. 
      INSERT sy-index 
             INTO int_tab INDEX 1 
             REFERENCE INTO dref. 
      INSERT dref 
             INTO TABLE ref_tab. 
    LOOP AT int_tab INTO int. 
      WRITE / int. 
    LOOP AT ref_tab INTO dref. 
      WRITE / dref->*. 


    Catchable Exceptions


    • Cause: Duplicate key values in unique secondary key
      Runtime Error: ITAB_DUPLICATE_KEY

    Non-Catchable Exceptions

    • Cause: When inserting a set of rows, entries with an identical key were produced (the target table is defined by UNIQUE).
      Runtime Error: ITAB_DUPLICATE_KEY
    • Cause: Sort order violated when using an INSERT with index in a sorted table.
      Runtime Error: ITAB_ILLEGAL_SORT_ORDER
    • Cause: Invalid index value (<= 0) when FROM, TO, or INDEX specified
      Runtime Error: TABLE_INVALID_INDEX


    INSERT - line_spec

    INSERT - itab_position

    INSERT - result

    Internal Tables - Inserting Rows