文章目录
1.Introduction
Subquery is used in abap. I will destrate it by following example.
2.code
DATA WA_SFLIGHT TYPE SFLIGHT.
SELECT * FROM SFLIGHT
INTO WA_SFLIGHT
WHERE SEATSOCC = ( SELECT MAX( SEATSOCC ) FROM SFLIGHT ).
WRITE: / WA_SFLIGHT-CARRID, WA_SFLIGHT-CONNID, WA_SFLIGHT-FLDATE,WA_SFLIGHT-seatsocc.
ENDSELECT.