There are two types of SQL being used in SAP ABAP programming language. They are

• Native SQL
• Open SQL

Open SQL allows to ACCESS the database tables declared in the ABAP dictionary REGARDLESS of the database platform that the SAP R/3 system is using.

Native SQL allows to use database-specific SQL statements in a SAP ABAP program. This means that one can use database tables that are not administered by ABAP dictionary, and therefore integrate data that is not PART of the SAP R/3 system.

Open SQL is not confined to any particular type of database while a Native SQL is confined to a particular type. 

ABAP PROGRAMS that uses only Open SQL statements will work in any R/3 system, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP dictionary.

There are two types of SQL being used in SAP ABAP programming language. They are

Open SQL allows to access the database tables declared in the ABAP dictionary regardless of the database platform that the SAP R/3 system is using.

Native SQL allows to use database-specific SQL statements in a SAP ABAP program. This means that one can use database tables that are not administered by ABAP dictionary, and therefore integrate data that is not part of the SAP R/3 system.

Open SQL is not confined to any particular type of database while a Native SQL is confined to a particular type. 

ABAP programs that uses only Open SQL statements will work in any R/3 system, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP dictionary.