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 do you validate the selection criteria of a report? And how do you display initial

594


What is a size category? : abap data dictionary

664


What is an update task? : abap modularization

595


what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?

1739


What are the problems in processing batch input sessions?

611






How to pass data from list to report?

572


when u prefer lsmw?

625


What is your approach for writing a bdc program? : abap bdc

590


could anyone tell me what r real time questions been asked in interviews?i am in urgent need..thanks in advance

1449


Explain get pernr concept when we use logical data base? : abap hr

757


What are the client dependant objects in abap / sap?

539


What are aggregated objects : abap data dictionary

605


What takes most time in SAP script programming?

686


Explain different types of attributes of function module?

550


In order to upload purchase order details, how you handle multiple values for a single field?

569