Mastering SAP ABAP

Inline declaration

The main changes compared to the old SQL is data declaration, where we needed to declare all the necessary fields that will be selected. By using inline declaration, this is no longer needed. During select from database, a structure or table will be created. This is really helpful, as when you need to select a new field or fields, just add them to the field list.

The following are three SELECT statements. The first of these is created in the old SQL, while the second and third are created with the inline declaration. All the SELECT statement results are identical.

The first SELECT statement is also presented with the declaration of the table:

TYPES:   BEGIN OF t_spfli,     mandt     TYPE s_mandt,     carrid    TYPE s_carr_id, connid TYPE ...