ABAP Keyword Documentation →  ABAP − Short Reference 

UPDATE - Short Reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

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

       [CONNECTION con|(con_syntax)] 
       { { SET {col1 = f}|{col1 = col1 + f}|{col1 = col1 - f}{(expr_syntax1)}, 

               {col2 = f}|{col2 = col2 + f}|{col2 = col2 - f}{(expr_syntax2)}, 

                ... 

               [WHERE sql_cond]} 

       | {FROM wa|{TABLE itab}} }. 

Effect

Changes rows in a database table or in a classic view.

Additions

• 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.
• SET ... col = f ...
  Assigns the content of f to the column col.
• SET ... col = col + f ...
  Adds the content of f to the column col.
• SET ... col = col - f ...
  Subtracts the content of f from the column col.
• SET ... (expr_syntax) ...
  Changed specified dynamically in expr_syntax.
• WHERE sql_cond
  Specifies the rows to be changed using a condition sql_cond.
• {FROM wa}|{FROM TABLE itab}
  Overwrites rows with a work area wa or with the rows of an internal table itab.