REPORT  z10_11.

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.

SELECT carrid connid

INTO CORRESPONDING FIELDS OF TABLE gt_itab

FROM sflight.

LOOP AT gt_itab INTO gs_line.

  SELECT SINGLE carrname INTO gs_line-carrname

  FROM scarr WHERE carrid = gs_line-carrid.

  MODIFY gt_itab FROM gs_line.