INSERT dbtab

Syntax

INSERT { {INTO target VALUES source }
| { target FROM source } }.

Effect

The INSERT statement inserts one or more rows specified in source in the database table specified in target. The two variants with INTO and VALUES or without INTO with FROM behave identically, with the exception that you cannot specify any internal tables in source after VALUES.

System Fields

The INSERT statement sets the values of the system fields sy-subrc and sy-dbcnt.

sy-subrc	Meaning
0	At least one row was inserted.
4	At least one row could not be inserted, because the database table already contains a row with the same primary key or a unique secondary index.

The INSERT statement sets sy-dbcnt to the number of rows inserted.

Note

The inserted rows are finally included in the table in the next database commit. Up until this point, they can still be removed by a database rollback.
The statement INSERT sets a database lock until the next database commit or rollback. If used incorrectly, this can lead to a deadlock.
The number of rows that can be inserted in the tables of a database within a database LUW is limited, since a database system can only manage a limited amount of locks and data in the rollback area.