学习笔记（二十八）

DATA: condition(72) TYPE c,
      conditions LIKE TABLE OF condition,
      wa_spfli TYPE spfli,
      table_spfli TYPE TABLE OF spfli.

condition = 'CITYTO = ''ROME'''.
APPEND condition TO conditions.
condition = 'OR CITYTO = ''NEW YORK'''.
APPEND condition TO conditions.
SELECT * FROM spfli INTO TABLE table_spfli WHERE (conditions).
LOOP AT table_spfli INTO wa_spfli.
  WRITE: sy-tabix, wa_spfli-cityfrom, wa_spfli-cityto, /.
ENDLOOP.

DATA: wa_carrid TYPE spfli-carrid,
      wa_cityfrom TYPE spfli-cityfrom,
      wa_cityto TYPE spfli-cityto,
      wa_carrname TYPE scarr-carrname.
SELECT carrid cityfrom cityto FROM spfli
  INTO (wa_carrid, wa_cityfrom, wa_cityto)
  WHERE cityfrom = 'NEW YORK'.
  SELECT carrname FROM scarr INTO wa_carrname
    WHERE carrid = wa_carrid.
  ENDSELECT.
  WRITE: wa_carrname, wa_cityfrom, wa_cityto, /.
ENDSELECT.

DATA: BEGIN OF wa___spfli,
  connid TYPE spfli-connid,
  carrid TYPE spfli-carrid,
END OF wa___spfli,
BEGIN OF wa_scarr,
  carrid TYPE scarr-carrid,
  carrname TYPE scarr-carrname,
END OF wa_scarr,
tab_spfli LIKE TABLE OF wa___spfli.
SELECT connid carrid FROM spfli INTO TABLE tab_spfli WHERE cityto = 'NEW YORK'.

SELECT carrid carrname FROM scarr INTO wa_scarr FOR ALL ENTRIES IN tab_spfli
  WHERE carrid = tab_spfli-carrid.
  WRITE: sy-dbcnt, wa_scarr-carrname, /.
ENDSELECT.