What is the difference between open sql & native sql ?




Answers were Sorted based on User's Feedback



Answer / manikandan

native sql : are not checked and converted they are sent
directly to the database system.allows to use database
specific sqql statements in an abap program.

Open sql: it will work on any r/3 system regardless of the
database system in use.

Is This Answer Correct ?    24 Yes 4 No

Answer / nasreen

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.

Is This Answer Correct ?    14 Yes 1 No

Answer / g.jayaprakash

open sql is not confined to any particular type of database
while a native sql is confined to a particular one.

Is This Answer Correct ?    15 Yes 4 No




Answer / sugandha verma

ABAP Native SQL allows you to include database-specific SQL
statements in an ABAP program. Most ABAP programs containing
database-specific SQL statements do not run with different
databases. If different databases are involved, use Open
SQL. To execute ABAP Native SQL in an ABAP program, use the
statement EXEC. Open SQL (Subset of standard SQL
statements), allows you to access all database tables
available in the R/3 System, regardless of the manufacturer.
To avoid conflicts between database tables and to keep ABAP
programs independent from the database system used, SAP has
generated its own set of SQL statements known as Open SQL.

Is This Answer Correct ?    4 Yes 8 No

Post New Answer



More SAP ABAP Interview Questions

Is der any any alternative Statement instead of HIDE which u can use in reports?

4 Answers   Genpact, Cooperp,


what is the status code when IDOC is created?

2 Answers   Accenture,


which table stores the online messages?

1 Answers   Cap Gemini,


write the program for prime numbers between 1 to 1000

2 Answers   IBM,


– Programming using BAPI : Create Debit Memo Request (DMR) with reference to Sales Order and update the delivery number and PO number in the newly created DMR. Send the spool of the report by E-mail if the E-mail option is enabled. Selection Screen Required:  Sales Org  Delivery type  Sales document type Optional:  Planned Goods movement date  Option to choose E-Mail  E-mail Address  Output device Output Output should display both successful and unsuccessful creation of DMR with the following fields,  Success/Error (S/E)  Sales Document number  Delivery number  New Debit memo request number  Error message Tables TVAK, TVCPA, VBAK, LIKP, LIPS

0 Answers   Cisco,


what is search help exit ? can any body explain briefly

5 Answers   L&T,


How to deactivate the sort button from the alv output

3 Answers   IBM,


why are we using events in reports than control break statements?

1 Answers  


what is need of function group for function modules whereas there is no need of f.group for subroutines?

2 Answers   NTT Data, HCL, Cap Gemini, IBM, DFS,


what is the difference between select single * and slect upto 1 rows...

3 Answers  


How to create standard text and how do u transfer it ?

1 Answers   IBM,


differences between the sorted ,standard, hashed tables.

2 Answers   CSC, Icon,




Categories