*&---------------------------------------------------------------------*
*& Report Z99_118
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT Z99_118.
DATA LT_SFLIGHT TYPE TABLE OF SFLIGHT.

SELECT *
  FROM SPFLI
  INTO TABLE @DATA(LT_SPFLI).

SELECT CARRID
       CONNID
       CURRENCY
       SUM( PRICE )
  FROM SFLIGHT
  INTO CORRESPONDING FIELDS OF TABLE LT_SFLIGHT
  FOR ALL ENTRIES IN LT_SPFLI
  WHERE CARRID EQ LT_SPFLI-CARRID
  GROUP BY CARRID CONNID CURRENCY.