SAP NATIVESQL



Get Example source ABAP code based on a different SAP table
  


ID EXEC

Embedded Native SQL ( ABAP_EXEC_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 are not part of the ABAP language scope and do not follow ABAP syntax. Basically, database-specific SQL statements can be embedded that are passed unchanged from the Native SQL interface to a database system and executed there. Almost the entire SQL language scope of the relevant database can be used, and the addressed database tables do not have to be declared in the ABAP Dictionary. In addition, a small set of SAP-specific Native SQL statements and additions 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
Use ABAP SQL for general database accesses where possible.
ABAP_PGL_END



Latest notes:

If Native SQL is used instead of AB_SQL , the use of ADBC is recommended.
ABAP_HINT_END