*&---------------------------------------------------------------------*
*& Report  ZGL15C6
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*
REPORT  ZGL15C6.

TABLES scarr.

PARAMETERS p_carrid TYPE scarr-carrid.
SELECT-OPTIONS s_carrid FOR scarr-carrid.

DATA: gs_scarr TYPE scarr,
      gs_spfli type spfli,
      gs_sflight type sflight.

SELECT   carrid carrname url
INTO CORRESPONDING FIELDS OF gs_scarr
FROM scarr
UP TO 5 ROWS
WHERE carrid IN s_carrid .
WRITE: / gs_scarr-carrid, gs_scarr-carrname, gs_scarr-url(60).
ENDSELECT.
*
*SELECT single  carrid carrname url
*INTO CORRESPONDING FIELDS OF gs_scarr
*FROM scarr
*WHERE carrid IN s_carrid .
*WRITE: / gs_scarr-carrid, gs_scarr-carrname, gs_scarr-url(60).

*
*SELECT carrid carrname url
*INTO CORRESPONDING FIELDS OF gs_scarr
*FROM scarr
*WHERE carrid IN s_carrid .
*
*WRITE: / gs_scarr-carrid, gs_scarr-carrname, gs_scarr-url(60).
*
*SELECT connid cityfrom cityto
*INTO CORRESPONDING FIELDS OF gs_spfli
*FROM spfli
*WHERE carrid = gs_scarr-carrid.
*WRITE: / gs_spfli-connid, gs_spfli-cityfrom, gs_spfli-cityto.
*
*
*select price planetype
*  into CORRESPONDING FIELDS OF gs_sflight
*  from sflight
*  where carrid = gs_scarr-carrid
*  and connid = gs_spfli-connid.
*  write:/ gs_sflight-price, gs_sflight-planetype.
*endselect.
*
*
*ENDSELECT.
*ENDSELECT.