ABAP Keyword Documentation →  ABAP - Short Reference 

INSERT dbtab - Short Reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

INSERT { {INTO {dbtab|(dbtab_syntax)} [CLIENT SPECIFIED] 
    
                 
               [CONNECTION {con|(con_syntax)}] 

          VALUES wa} 
       | { {dbtab|(dbtab_syntax)} [CLIENT SPECIFIED] 

                 
                [CONNECTION {con|(con_syntax)}] 

           FROM wa|{TABLE itab [ACCEPTING DUPLICATE KEYS]} } }. 

Effect

Inserts lines into a database table.

Additions

• INTO {dbtab|(dbtab_syntax)}
  Specifies the database table statically or dynamically.
• CLIENT SPECIFIED
  Deactivates the automatic client handling.
• CONNECTION {con|(con_syntax)}
  Executes the change on a secondary database connection.
• {VALUES wa}|{FROM wa}|{FROM TABLE itab}
  Specifies the lines to be inserted as a work area wa or as lines of an internal table itab.
• ACCEPTING DUPLICATE KEYS
  Prevents an exception if already existing lines are to be inserted.