ABAP Keyword Documentation →  ABAP − Short Reference 

INSERT dbtab - Short Reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

INSERT { {INTO dbtab|view|(target_syntax) 
          [USING CLIENT clnt] | [CLIENT SPECIFIED] 

          [CONNECTION con|(con_syntax)] 
          VALUES wa} 

       | { dbtab|view|(target_syntax) 
           [USING CLIENT clnt] | [CLIENT SPECIFIED] 

           [CONNECTION con|(con_syntax)] 
 
         FROM wa|{TABLE itab [ACCEPTING DUPLICATE KEYS]} } }. 

Effect

Inserts rows into a database table or into a classic view.

Additions

• INTO dbtab|view|(target_syntax)
  Specifies the database table and/or view statically or dynamically.
• USING CLIENT
  Switches automatic client handling to the client specified in clnt.
• CLIENT SPECIFIED
  Deactivates automatic client handling.
• CONNECTION con|(con_syntax)
  Executes the change on a secondary database connection.
• {VALUES wa}|{FROM wa}|{FROM TABLE itab}
  Specifies the rows to be inserted as a wa work area or as rows of an itab internal table.
• ACCEPTING DUPLICATE KEYS
  Prevents an exception if rows that already exist are to be inserted.