SAP-abap学习记录（17）

*&---------------------------------------------------------------------*
*& Report  ZTEST_ABAP_17
*&
*&---------------------------------------------------------------------*
*&sql测试程序：select...endselect
*&
*&心得：注意空格问题
*&---------------------------------------------------------------------*
REPORT ztest_abap_17.

TABLES: sbook,spfli.

DATA: count TYPE i,
      sum   TYPE p DECIMALS 2,
      avg   TYPE f.

DATA: connid LIKE sbook-connid.

SELECT connid COUNT(*) SUM( luggweight ) AVG( luggweight )  "注意空格

       INTO (connid,count,sum,avg)

       FROM sbook

       WHERE

        carrid = 'LH' AND

        fldate = '19950228'

       GROUP BY connid.

  WRITE: / connid,count,sum,avg.

  CHECK sum > 10.

  WRITE: / 'the sum weight >10'.

ENDSEL