Database Access in ABAP

Reading and operating on databases is one of the most frequently used skills for an Advanced Business Application Programming (ABAP) developer. A good understanding of the principles of ABAP OpenSQL is an essential skill that is required for operating in databases. To access the database in SAP, we can use two types of SQLs—ABAP OpenSQL and Native SQL. The main difference between these is that OpenSQL can be used in all database platforms to gain access to database tables declared in the ABAP Dictionary, while through Native SQL, you can use a database-specific SQL statement, which allows you to use a table that is not managed by the ABAP Dictionary. One of the biggest issues with Native SQL is the fact that a query written in Native SQL cannot be used in all databases and is specific to each type of database. In this chapter, we will be...