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

Open SQL

Open SQL is a set of ABAP statements, based on SQL, that asre transformed to platform-specific SQL by the Open SQL interface of the database interface and then passed to the database. When the statements are transformed, ABAP-specific parts, such as conditions for automatic client handling or CDS access control, are inserted into the statements. By default, the standard connection is used to access the ABAP database schema of the standard AS ABAP database.

The statements COMMIT WORK and ROLLBACK WORK are also part of Open SQL but are handled in the context of LUWs.

Programming Guideline

Using Open SQL


The statements described here are accompanied by obsolete short forms of Open SQL statements, based on the implicit use of table work areas.

Open SQL - Overview
Open SQL - Operands and Expressions
Open SQL - Reads
Open SQL - Write Accesses
Open SQL - Work Areas in Statements
Open SQL - Streaming and Locators
Open SQL - Exceptions
Open SQL - Database Hints
Open SQL - System Classes
Open SQL - Performance Notes