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.

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.

Answer / g.jayaprakash

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

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.

What happens Update command is used without where clause ?

0 Answers  

---

How can i insert a field in script without using executable program

1 Answers  

---

Scenario 1: I am uploading 1000 records using session method. I have an error in 950th record. What will happen and howmany records will upload? Scenario 2: I am uploading 1000 records using Call Transaction method. I have an error in 950th record. What will happen and howmany records will upload?

3 Answers  

---

What is the system field that stores the level of the list?

3 Answers   Accenture,

---

How to debug a smart form?

5 Answers   IBM, Mind Tree, TCS,

---

In Interactive Report ,can I have more than 20 interactive Lists? Is it Possible ,If Yes How can i do it?

4 Answers   Accenture,

---

What is the Tcode for System Dump?

4 Answers   TCS,

---

how many type of index are there

3 Answers   EDS,

---

What are conversion routines? : abap data dictionary

0 Answers  

---

what is the role of CUID in Business Objects Import Wizard

1 Answers   DELL, Hexaware,

---

I am trying to automate a manual processing of iDOCs in BD87. I used the following code to pass idoc-id to global variable 'DCN' and then skip the first screen of BD87 to go to processing directly. After running this code SET PARAMETER ID 'DCN' FIELD itabhdr-idoc_id. CALL TRANSACTION 'BD87' AND SKIP FIRST SCREEN. it takes me to the first screen because it cannot recognize my idoc-id. How I can pass idoc-id to global? I have used the above code to goto VA02 with VBELN and it worked perfectly.

0 Answers   Cybernetix,

---

How to create logical system in sap in order to access bw and bi?

1 Answers  

---