Mastering SAP ABAP

Updating datasets

To change existing database entries, you can use the UPDATE statement. Three different options are available for the UPDATE statement.

To change specific columns, you can use the following syntax:

UPDATE dbtab      SET [col1 = f1 col2 = f2 ...]          [col1 = col1 + f2 col2 = col2 + f2 ...]          [col1 = col1 – f1 col2 = col2 – f2 ...]      WHERE ...

With this statement, you change the columns named at the SET clause for all rows within the dbtab table for which the conditions of the WHERE clause take effect. Without the WHERE clause, all rows of the table are changed.

You can either override the existing value or add to or subtract from those values.

To change the entire row, you can use the following statement:

UPDATE dbtab FROM wa

To change ...