In ABAP/4 programming language, there are two types of SQL being used.
Open SQL allows you to access the database tables declared in the ABAP dictionary regardless of the database platform that the R/3 system is using.
Native SQL allows you to use database-specific SQL statements in an ABAP/4 program. This means that you can use database tables that are not administered by ABAP dictionary, and therefore integrate data that is not part of the R/3 system.