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.

Can we use more than two field in SELECT-OPTION? For example Normally we get two field which is from and to fields, but i want to get more values.....

4 Answers   Altrion Technologies,

---

In select-options, how to get the default values as current month first date and last date by default?

0 Answers  

---

Is a logical database a requirement/must to write an abap/4 query?

0 Answers  

---

what is table maintenace generator? How to create it?

4 Answers  

---

What is a currency factoring technique?

0 Answers  

---

---

wat is the default file name of BAPI trace?

0 Answers  

---

In Dialog program Syntax of Synchronous and Asynchronous?

2 Answers   HCL,

---

What two statements are required in an abap program to output an icon using a write statement?

0 Answers  

---

what is version in reports?

1 Answers  

---

what is meant by maintenance allowed(if it can provide authorization, what is authorization)

2 Answers   Satyam, Wipro,

---

What are the FM you used in Session method?

2 Answers   FutureSoft,

---

Hi, If anyone is interested in SAP ABAP from basics to Expert. Email me your contact details to sap.abap9@gmail.com

1 Answers  

---