ABAP Keyword Documentation →  ABAP - Quick Reference 

INSERT dbtab - Quick 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]}|( SELECT subquery_clauses ) } }. 

Effect

ABAP SQL statement. 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 implicit client handling to the client specified in clnt.
• CLIENT SPECIFIED
  Switches implicit client handling to the client specified in the data source.
• CONNECTION con|(con_syntax)
  Makes the change on a secondary 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.
• SELECT subquery_clauses
  Specifies the inserted rows as a results set of a subquery SELECT subquery_clauses.