Book Image

Mastering SAP ABAP

By : Paweł Grześkowiak, Wojciech Ciesielski, Wojciech Ćwik
Book Image

Mastering SAP ABAP

By: Paweł Grześkowiak, Wojciech Ciesielski, Wojciech Ćwik

Overview of this book

Advanced Business Application Programming (ABAP) is an established and complex programming language in the IT industry. This book is designed to help you use the latest ABAP techniques and apply legacy constructions using practical examples. You'll start with a quick refresher on language and database concepts, followed by agile techniques for adding custom code to a modern ABAP system. After this, you will get up to speed with the complete ABAP toolset for importing data to and from different environments. Next, you'll learn how to print forms and work with the different ABAP tools for Extensible Markup Language (XML) manipulation. While covering further chapters, you'll gain insights into building stunning UI5 interfaces, in addition to learning how to develop simple apps using the Business Object Processing Framework (BOPF). You will also pick up the technique of handling exceptions and performing testing in ABAP. In the concluding chapters, you can look forward to grasping various techniques for optimizing the performance of programs using a variety of performance analysis tools. By the end of this book, you will have the expertise you need to confidently build maintainable programs in Systems, Applications, and Products (SAP).
Table of Contents (25 chapters)
Title Page
Copyright and Credits
Dedication
About Packt
Contributors
Preface
Index

Chapter 3. 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 looking at OpenSQL only.

In this chapter, we will cover the following topics:

  • Extracting data from the database in an efficient...