SAP (Systems, Applications, and Products) Question:

Download Job Interview Questions and Answers PDF

Explain open SQL vs native SQL?

SAP (Systems, Applications, Products) Interview Question
SAP (Systems, Applications, Products) Interview Question

Answer:

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.

Download SAP (Systems, Applications, Products) Interview Questions And Answers PDF

Previous QuestionNext Question
What should be the approach for writing a BDC program?What are datasets?