cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Open Sql and Native Sql

Former Member
0 Likes
415

Hi all,

Can anyone explain me the diference between open sql and native sql ? The select statements we use belongs to which category ?

Regards,

Varun.

View Entire Topic
Former Member
0 Likes

Hi Varun,

Open SQL allows you to access all database tables known to the SAP system, regardless of the database manufacturer. Sometimes, however, we may want to use database-specific SQL statements called Native SQL in your ABAP/4 program. To avoid incompatibilities between different database tables and also to make ABAP/4 programs independent of the database system in use, SAP has created a set of separate SQL statements called Open SQL. Open SQL contains a subset of standard SQL statements as well as some enhancements which are specific to SAP. A database interface translates SAP's Open SQL statements into SQL commands specific to the database in use. Native SQL statements access the database directly.

Hope this will help.

Regards,

Ferry Lianto