ABAP Keyword Documentation →  ABAP - Quick Reference 

UPDATE - Quick 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

ABAP SQL statement. 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 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.
• 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.