Comment by kuriho

SAP ABAP's OpenSQL allowes you to write both:

     SELECT FROM scarr
       FIELDS carrid, carrname
       ORDER BY carrid
       INTO TABLE @DATA(result1).

and

     SELECT carrid, carrname
       FROM scarr
       ORDER BY carrid
       INTO TABLE @DATA(result2).

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/a...