一些代码参考

取采购订单物料最近的供应商以及最后一次采购日期

WITH +i AS ( SELECT matnr,werks,lifnr,bedat,ekpo~loekz,
                      ROW_NUMBER( ) OVER( PARTITION BY matnr "根据物料分组
                                           ORDER BY bedat DESCENDING ) AS rnum   "根据日期降序
                  FROM ekko
                  JOIN ekpo
                    ON ekpo~ebeln = ekko~ebeln
                   AND ekpo~werks = @p_werks
                   AND ekpo~loekz = ''
                   AND ekko~bsart = 'NB'
                   AND ekpo~knttp NE 'Q'
                   AND ekpo~lgort IN ( '1000','1003' )
                   AND ekko~ekgrp IN ( 'W03','W04','W05','W06','W07','W08','W09','W10','W11' ) )
   SELECT +i~*
     FROM +i
     JOIN @lt_marc AS a
       ON +i~matnr = a~matnr
    WHERE rnum = 1
      AND loekz = ''
      AND werks = @p_werks
     INTO TABLE @DATA(lt_ekpo).

SAP查询最近一天审核通过的价格为当日金属价

WITH +i AS ( SELECT ztmm0044~*,
                        ROW_NUMBER( ) OVER( PARTITION BY z_raw_material_code   "按物料分组
                                            ORDER BY datum DESCENDING  "按日期降序
                                           ) AS rnum
                    FROM ztmm0044 )
  SELECT +i~*
    FROM +i
   WHERE rnum = 1
    AND z_oastatus = '1'
    INTO TABLE @DATA(lt_ztmm0044_old).

当需要控制 FUNTION ALV 的工具栏按钮隐藏/显示