Updating a Database Table from an Internal Table

In case you have an internal table, and wish to use it in order to update a database table, use the following statements:

UPDATE dbtab FROM TABLE itab

Or

INSERT dbtab FROM TABLE itab

Where dbtab is the name of the database table, itab is the name of the internal table
Note: A common mistake would be to omit the word TABLE from the above statement. Doing this will yield the following error:
“You cannot use an internal table as a work area”.