SAP NATIVESQL

Get Example source ABAP code based on a different SAP table
  


ARTICLE

Static Embedding of Native SQL
The following ABAP statements are used to embed Native SQL statically in ABAP programs: EXEC SQL
...
ENDEXEC
Native SQL statements embedded between EXEC SQL and ENDEXEC do not fall within the scope of ABAP and do not follow ABAP syntax. Mainly, database-specific SQL statements can be embedded that are passed unchanged from the Native SQL interface to a database system, and executed there. The full SQL language scope of the relevant database can be used and the addressed database tables do not have to be declared in ABAP Dictionary. In addition, a small set of SAP-specific Native SQL statement are available that can only be specified between EXEC SQL and ENDEXEC and that are subject to special handling by the Native SQL interface.

ABAP_PGL Using Open SQL

Note
If Native SQL is used instead of Open SQL, the use of ADBC is recommended.