ABAP Keyword Documentation →  ABAP - Short Reference 

UPDATE - Short Reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

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

       { { SET [col1 = f1 col2 = f2 ... ] 
    
          [col1 = col1 + f1 col2 = col2 + f2 ...] 
 
             [col1 = col1 - f1 col2 = col2 - f2 ...] 

               [(expr_syntax1) (expr_syntax2) ...] 

               [WHERE sql_cond] } 

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

Effect

Changes rows in a database table.

Additions

• {dbtab|(dbtab_syntax)}
  Specifies the database table statically or dynamically.
• CLIENT SPECIFIED
  Switches off automatic client handling.
• CONNECTION {con|(con_syntax)}
  Executes the change on a secondary database connection.
• SET col1 = f1 col2 = f2 ... - Assigns to columns col1, col2, ... the contents of f1, f2 ...
• SET col1 = col1 + f1 col2 = col2 + f2 ... - Adds the contents of f1, f2, ... to columns col1, col2, ...
• SET col1 = col1 - f1 col2 = col2 - f2 ... - Subtracts the contents of f1, f2, ... from columns col1, col2, ...
• SET (expr_syntax) - Dynamic specification of a change in expr_syntax.
• WHERE sql_cond
  Specifies the lines to be changed using a condition sql_cond.
• {FROM wa}|{FROM TABLE itab}
  Overwrites lines with a work area wa or with the rows of an internal table itab.