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

Open SQL - Write Accesses

Write accesses include inserting, modifying, and deleting content in database tables. All write accesses 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 write accesses, always pay attention to data consistency.

• When making write accesses 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