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.
学习笔记(二十七)
最新推荐文章于 2024-08-01 19:45:58 发布