Mastering SAP ABAP

ORDER BY

ORDER BY clauses are used to sort data directly through the SELECT statement. Sorting can be carried out using a primary key:

SELECT carrid connid   FROM sflight   INTO CORRESPONDING FIELDS OF TABLE gt_sflight    ORDER BY PRIMARY KEY.

It can also sort other columns in ascending or descending order, or even in a dynamic order, which is created on the same principle as dynamic, with different values compared with a dynamic variable:

SELECT carrid connid planetype   FROM sflight   INTO CORRESPONDING FIELDS OF TABLE gt_sflight   ORDER BY planetype ASCENDING.