select 语句
select * into table gt_itab from sflight up to 5 rows.
Syntax
… [USING KEY keyname]
[FROM idx1] [TO idx2]
[WHERE log_exp|(cond_syntax)] …
Extras:
-
… USING KEY keyname
-
… [FROM idx1] [TO idx2]
-
… WHERE log_exp
-
… WHERE (cond_syntax)
*&---------------------------------------------------------------------*
*& Report ZBAP02
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*
REPORT zbap02.
data: begin of gs_line,
carrid type sflight-carrid,
connid type sflight-connid,
carrname type scarr-carrname,
end of gs_line.
data gt_itab like table of gs_line.
field-symbols <fs> like gs_line.
select carrid connid into corresponding fields of table gt_itab from sflight.
loop at gt_itab from 1 to 2 into gs_line.
write :/ gs_line-carrid, gs_line-connid, gs_line-carrname.
endloop.
loop at gt_itab from 1 to 2 assigning <fs>.
select single carrname into <fs>-carrname from scarr where carrid = <fs>-carrid.
endloop.
loop at gt_itab from 1 to 2 into gs_line.
write :/ gs_line-carrid, gs_line-connid, gs_line-carrname.
endloop.
参考
https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-us/abaploop_at_itab_cond.htm