Mastering SAP ABAP

Basics

In the first section, I'd like to present the most basic aspects of how to extract data from a database. In this subsection, we will explore how to create a basic select from table, as well as look at what components the SELECT statement is creating.

The SELECT statement is built from at least three mandatory parts. The first part in the SELECT statement is the resulting set. The resulting set is a list of fields that state what we want to get from the selected table. For the resulting set, we can use a list of fields directly entered in the statement, or we can use * to get all fields in the table. However, using * is not recommended due to performance issues, as we often do not need all fields in a table – only a few of them. The ...