What is open sql vs native sql ?

Answer Posted / rajkumar gupta

Open SQL allows you to access database tables declared in the ABAP Dictionary regardless of the database platform that your R/3 System is using.
Native SQL allows you to use database-specific SQL statements in an ABAP program. This means that you can use database tables that are not administered by the ABAP Dictionary, and therefore integrate data that is not part of the R/3 System.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the differences between structure and table in the data dictionary in abap?

839


What statement will be found in an sap application program that implements a function module exit?

752


What is the max no of match code id's that can be defined for one match code object? : abap data dictionary

857


If I want to execute a program only in background not in foreground is there any option for this? : abap bdc

742


Explain how to create any functions? How to go about it?

734


What is repository info. Systems? : abap data dictionary

758


Does the table can have multiple foreign keys?

763


What is lock object ? : abap data dictionary

799


Define structure in abap data dictionary?

786


What is the tcode to create indexes?

783


What is the master data necessary before you can start posting in MM?

1011


Have you set up a back ground job? How to create a background job without a variant ? : abap bdc

764


What is generic area buffering in abap?

738


What are the differences between a database index and a match code? : abap data dictionary

899


How did you test the form you developed? How did you taken print?

802