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

HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)

3291


what are the important fields while preparing sales order,inquiry?

1905


What is the process to enhance the Infotype

2883


Difference between domain and data element? What are aggregate object?

607


On abap: did you set up a workflow? Are you familiar with all the steps for setting up a workflow?

578






What are the abap/4 commands that link to a layout set?

862


What is the difference between refresh and free statements?

627


Rp_provide_from_last contains how many parameters ? : abap hr

880


From Excel to ABAP - Is batch mode possible ?

582


Explain the different types of mode (run code) in call transaction method?

565


What work you have done in HR module

904


How to Modify Layout set for RVORDER01 for printing sales order confirmation. plz mention the detail coding Tahnks, Rahul

3416


Hi,have Good Command in SAP ABAP, ABAP WEBDYNPRO now i want to learn sap IS utilities.. can u plz suggest me is it useful r not? If not can i learn BI? Is ABAP with BI have gud future?

1545


What are user exits? What is involved in writing them? What precations are needed?

598


how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran

2044