ABAP新语法查询表按照某个字段分组

需求为查询表里某个Key值最大的数据

 

按照客户分组获取有效期最大的那条数据 Where条件里的1代表最大一条 以此类推

  SELECT
    ZIHREZ,
    ZYXQC,
    ZXL,
    ZDL
    FROM ZTSD_ZSDR0017 AS A
   WHERE 1 GE (
      SELECT COUNT(*)
        FROM ZTSD_ZSDR0017 AS B
       WHERE B~ZIHREZ EQ A~ZIHREZ
         AND B~ZYXQC GE A~ZYXQC

    ) AND  A~ZIHREZ IN @S_ZIHREZ
    ORDER BY A~ZIHREZ ,A~ZYXQC DESCENDING
    INTO CORRESPONDING FIELDS OF TABLE @GT_OUT
    .