1. Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
  2. Suggest New Category

What is the difference between open sql & native sql ?

Question Posted / sugandha verma

Answer Posted / 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.

Is This Answer Correct ?    4 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How are the function code handles in flow logic?

608

Explain the disadvantages of different types of bdc's?

511

Explain the function module in bdc?

573

What are the parameters in bdc_insert? : abap bdc

806

How will you find manager of an employee

850




What is screen flow logic? What are the sections in it?

598

How can you distinguish between different kinds of parameters?

549

– Programming using BAPI : Create Debit Memo Request (DMR) with reference to Sales Order and update the delivery number and PO number in the newly created DMR. Send the spool of the report by E-mail if the E-mail option is enabled. Selection Screen Required:  Sales Org  Delivery type  Sales document type Optional:  Planned Goods movement date  Option to choose E-Mail  E-mail Address  Output device Output Output should display both successful and unsuccessful creation of DMR with the following fields,  Success/Error (S/E)  Sales Document number  Delivery number  New Debit memo request number  Error message Tables TVAK, TVCPA, VBAK, LIKP, LIPS

5522

Explain how do you move on to the next screen in interactive reporting?

568

When is the top-of-page event triggered? : abap data dictionary

797

What are the advantages/ dis-advantages of logical databases?

540

What is partner selection?

610

how can you display data say "your name"in sap script without print program or driver program??

1721

What are system variable in abap?

608

What are your ways to performance optimization?

911