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”.