ABAP - Update Statement, Syntax & Example.

Update statement

To update database table UPDATE statement is used. This allows you to change either a single record or several records.

You can use UPDATE when you know which record you want to change. But if you do not know whether the primary key of the line you want to insert already exists or not, you can use the MODIFY statement. The MODIFY statement changes existing lines and inserts lines which do not exist.

Sflight-carrid = ‘MN’.
Sflight-connid = ‘454’.
UPDATE SFLIGHT where CARRID = ‘LH’.
Or
TABLES SFLIGHT.
UPDATE SFLIGHT SET PRICE = 1100
WHERE CARRID = ‘LH’.

Here price of sflight will get updated with new price 1100.