学习笔记（二十七）

DATA: wa_spfli TYPE spfli.
SELECT SINGLE * FROM spfli INTO wa_spfli
  WHERE cityto = 'NEW YORK'.
WRITE: wa_spfli-cityfrom, /.

DATA: wa_cityfrom TYPE spfli-cityfrom,
      wa_cityto TYPE spfli-cityto.
SELECT SINGLE cityfrom cityto FROM spfli
  INTO (wa_cityfrom, wa_cityto) WHERE cityto = 'NEW YORK'.
WRITE: wa_cityfrom, wa_cityto, /.

CLEAR wa_spfli.
SELECT SINGLE cityfrom cityto FROM spfli
  INTO CORRESPONDING FIELDS OF wa_spfli
  WHERE cityto = 'BERLIN'.
WRITE: wa_spfli-cityfrom, wa_spfli-cityto, /.

SELECT * FROM spfli INTO wa_spfli
  WHERE cityto = 'NEW YORK'.
  WRITE: sy-dbcnt, wa_spfli-cityfrom, wa_spfli-cityto, /.
ENDSELECT.

CLEAR wa_spfli.
DATA table_spfli TYPE TABLE OF spfli.
SELECT * FROM spfli INTO TABLE table_spfli WHERE cityto = 'NEW YORK'.
WRITE: 'Record count: ', sy-dbcnt, /.

SELECT * FROM spfli APPENDING TABLE table_spfli WHERE cityto = 'SINGAPORE'.
WRITE: 'Record count: ', sy-dbcnt, /.

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