ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP Database Accesses →  Open SQL 

Open SQL - Writes

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

Other versions: 7.31 | 7.40 | 7.54

Notes

• When making writes, always pay attention to data consistency. The LUW concept is designed for this purpose. In application programs of an AS ABAP, the implicit database LUWs are normally not sufficient for consistent data storage. Instead, explicit SAP LUWs need to be programmed, which normally contain multiple database LUWs.

• When making writes to a database table for which a database cursor is open in a SELECT loop or opened by using OPEN CURSOR, the results set is database-specific and undefined. Avoid this kind of parallel access if possible.

Continue

INSERT dbtab

UPDATE dbtab

MODIFY dbtab

DELETE dbtab

INSERT, UPDATE, MODIFY dbtab - LOB Handles

INSERT, UPDATE, MODIFY, DELETE dbtab - CONNECTION