Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
You can use the command INSERT <dbtab> FROM TABLE <itab> to create several rows in a database table.
The internal table <itab> that you should specify here must have the same line structure as the corresponding database table and the new data records. The client field that might exist in the internal table <itab> will only be taken into consideration if the CLIENT SPECIFIED addition is specified. If there is no CLIENT SPECIFIED addition, the current execution client applies. If it is possible to create all the lines, sy-subrc is automatically set to zero.If, however, even one data record cannot be created, a runtime error occurs. This means that the entire insertion operation is discarded (database rollback). If, in such a case, you want to have records that can be inserted actually inserted, use the command addition ACCEPTING DUPLICATE KEYS. If there is an error, this addition suppresses the runtime error (and thus also the database rollback), sets the return code (sy-subrc) to 4, and inserts all the records without errors.The sy-dbcnt system field contains the number of rows that were successfully inserted in the database.
Bluesky
