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

Data Cluster (ABAP memory)

A data cluster (ABAP Memory) is a group of data objects grouped together for the purpose of storage in a storage medium that can only be edited using ABAP statements.  The data objects are written to the storage medium by the statement EXPORT. The data objects are extracted again by the statement IMPORT. The statement DELETE can be used to delete any storage medium. The statement FREE can be used to delete the ABAP Memory. The statement IMPORT DIRECTORY generates a list of all data objects that have previously been exported to a database table. EXPORT Syntax  … {p1 = dobj1 p2 = dobj2 …}| {p1 FROM dobj1 p2 FROM ...