Mastering SAP ABAP

Creating datasets

Datasets are created by using the INSERT statement. You can either create a single row or multiple rows with this statement.

To add a single row, you can use one of the following variants, which acts in an equal manner on the database: 

INSERT INTO dbtab VALUES wa

Alternatively, you can use one of the following:

INSERT dbtab FROM wa.

The structure of wa should be identical to the structure of dbtab. This operation will only be executed if there is no entry with the same primary key. If there is an entry with the same key, SY-SUBRC will be set to 4 instead of 0.

To add multiple datasets, you can use the following statement: 

INSERT dbtab FROM TABLE itab [ACCEPTING DUPLICATE KEYS]

All entries from itab are inserted into the ...