Report z_select_into_itab.
types: begin of tab_type ,
carrid type spfli-carrid,
connid type spfli-connid,
end of tab_type.
data: spfli_tab1 type table of spfli,
spfli_tab2 type table of tab_type.
select *
from spfli
into table spfli_tab1
where cityfrom = 'singapore' and cityto = 'beijing'.
select cityfrom cityto
from spfli
into corresponding fields of table spfli_tab2 " 內表和數據 庫表結構不完全相同。
where cityfrom = 'singapore' and cityto ='beijing'.