品种取最近日期的价格作为当月的价格

SELECT T2.WERKS,
       T2.KALNR,
       ${PERIOD} PERIOD,
       T2.CURTP,
       T2.MATNR,
       T2.PEINH,
       T2.VPRSV,
       T2.STPRS,
       T2.PVPRS,
       T2.STDPRICE,
       T2.CYCPRICE
FROM (SELECT T1.WERKS,
             T1.KALNR,
             T1.PERIOD,
             T1.CURTP,
             T1.MATNR,
             T1.PEINH,
             T1.VPRSV,
             T1.STPRS,
             T1.PVPRS,
             T1.STDPRICE,
             T1.CYCPRICE,
             ROW_NUMBER() OVER ( PARTITION BY T1.KALNR ORDER BY T1.KALNR,T1.PERIOD DESC ) ROWNM --按照日期降序，分组取第一条
      FROM ODS_SAP_MATERIAL_PRICE T1
      WHERE T1.PVPRS <> 0
        AND T1.PERIOD <= ${PERIOD}) T2
WHERE T2.ROWNM = 1