学习笔记（二十九）

DATA: BEGIN OF wa_spfli,
    cityfrom TYPE spfli-cityfrom,
    cityto TYPE spfli-cityto,
  END OF wa_spfli,
  table_spfli LIKE TABLE OF wa_spfli.
SELECT cityfrom cityto FROM spfli
  INTO TABLE table_spfli WHERE carrid IN (
    SELECT carrid FROM scarr WHERE carrname = 'United Airlines'
  ).

LOOP AT table_spfli INTO wa_spfli.
  WRITE: wa_spfli-cityfrom, wa_spfli-cityto, /.
ENDLOOP.

DATA: carrid TYPE sflight-carrid,
      minimum TYPE p DECIMALS 2,
      maximum TYPE p DECIMALS 2.

SELECT carrid MIN( price ) MAX( price )
  FROM sflight
  INTO (carrid, minimum, maximum)
  GROUP BY carrid.
  WRITE: carrid, minimum, maximum, /.
ENDSELECT.