SAP UPDATE - Reference ABAP Statements

Get Example source ABAP code based on a different SAP table
  ABAP Statement

Standard SAP Help for UPDATE

UPDATE

ABAP Reference
ABAP Code Snippet


ABAP 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} } }.
ABAP Code Snippet

What does it do? Changes rows in a database table.

ABAP Addition dbtab|(dbtab_syntax)
Specifies the database table statically or dynamically.
CLIENT SPECIFIED
Deactivates 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 and so on.
SET col1 = col1 + f1 col2 = col2 + f2 ... - Adds the contents of f1, f2, ... to columns col1, col2 and so on.
SET col1 = col1 - f1 col2 = col2 - f2 ... - Subtracts the contents of f1, f2, ... from columns col1, col2 and so on.
SET (expr_syntax) - Dynamic specification of a change 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.

Return to menu