Open SQL – Writes Statements

Writes include inserting, modifying, and deleting content in database tables. All writes can be made as individual accesses or as mass access. If multiple rows of a database table are to be changed, mass access using internal tables generally gives better performance than individual accesses.  INSERT UPDATE MODIFY DELETE INSERT { {INTO target VALUES wa } | { target FROM wa|{TABLE itab} } }.  INSERT INTO scarr VALUES @scarr_wa. INSERT scarr FROM @wa.INSERT scars FROM TABLE @itab. System FieldsThe statement INSERT sets the values of the system fields sy-subrc and sy-dbcnt. The INSERT statement sets sy-dbcnt to the number of rows inserted. If an overflow occurs because the number or rows ...