ABAP Keyword Documentation → ABAP − Short Reference
UPDATE - Short 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 inclnt
. -
CLIENT SPECIFIED
Deactivates automatic client handling. -
CONNECTION con|(con_syntax)
Executes the change on a secondary database connection. -
SET ... col = f ...
Assigns the content off
to the columncol
. -
SET ... col = col + f ...
Adds the content off
to the columncol
. -
SET ... col = col - f ...
Subtracts the content off
from the columncol
. -
SET ... (expr_syntax) ...
Changed specified dynamically inexpr_syntax
. -
WHERE sql_cond
Specifies the rows to be changed using a conditionsql_cond
. -
{FROM wa}|{FROM TABLE itab}
Overwrites rows with a work areawa
or with the rows of an internal tableitab
.