on which layer OPEN SQL query got's executed

[Balu483]

hi,

i have following doubt in my mind since long back .

can any one give a brief explanation on where will be the OPEN SQL got executed/ processed. either in Application Layer or Database layer ?

if an ABAP program executed and it contains a select query , then what will happen unless the data comes in internal table/ work area i.e. process flow chart of an OPEN SQL. can any one provide with clear picture or processing of OPEN SQL Query Statement?

[Sandra_Rossi · Accepted solution]

Clear picture (and description) here : SAP Library - Database Accesses of the NetWeaver AS ABAP

[matt · Accepted solution]

I.e processing done in both app and db servers.

[Sandra_Rossi · Accepted solution]

(1) ABAP SQL statement ---exec---> (2) Kernel DataBase Interface (BC-DBI) ---exec---> (3) Kernel DataBase Shared Library (DBSL) ---exec---> (4) SQL statement at database level

(1) (2) (3) are at the SAP application server level; they build the SQL statement so that its syntax is valid/recognized by the type of database at (4) (i.e. HANA, Oracle, etc.); there is one DBI common to all database types; there is one DBSL per database type.