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

The optimization of reading big datasets


The performance of a program is often determined by the efficiency of a database and how its operations are used on it.

The efficiency of using a database and downloading only necessary data to the application server can be critical to the general speed of a program, so operations on a database should be as low as possible.

We need to follow a rule that helps us to maintain an operation on a database in good performance.

In order to ensure correct performance, we must ensure that we follow these steps:

  • Get only the required rows from a table: For example, if we need to get a flight from America Airlines from the sflight table, we must use the proper conditions in WHERE. When it comes to the effective use of all data, what we can get to specify the condition is really important.
  • Get only the required columns from a table: In every SELECT statement, the result set should only contain a column that you really need. If we need to get data with regard to the...