IF GT_ZTMMPER[] IS NOT INITIAL.
*采购单价自建表中未维护的供应商代码和物料不推送
SELECT EKPO~BUKRS "公司代码
EKKO~LIFNR "供应商代码
EKPO~EBELN "采购凭证号
* EKPO~WERKS "工厂
EKPO~MATNR "物料编码
* EKPO~LGORT "库存地点
EKPO~MENGE "采购订单数量
EKPO~NETPR "采购订单净价
EKPO~MWSKZ "税率
EKPO~ELIKZ "交货是否完成标识
EKPO~RETPO "是否为退货标识
EKKO~AEDAT "创单日期
EKKO~ERNAM "创单人
EKKO~ZTERM "付款条件
EKKO~WAERS "货币码
INTO TABLE GT_KOPO
FROM EKPO
INNER JOIN EKKO
ON EKPO~EBELN = EKKO~EBELN
FOR ALL ENTRIES IN GT_ZTMMPER
WHERE EKPO~MATNR = GT_ZTMMPER-MATNR
AND EKKO~LIFNR = GT_ZTMMPER-LIFNR .
*对GT_KOPO里边的数据进行汇总
SORT GT_KOPO BY BUKRS LIFNR EBELN MATNR ASCENDING.
LOOP AT GT_KOPO INTO WA_KOPO1.
WA_KOPO2 = WA_KOPO1.
TEMENGE = TEMENGE + WA_KOPO1-MENGE.
* WA_KOPO2-MENGE = WA_KOPO2-MENGE + WA_KOPO1-MENGE.
AT END OF MATNR.
WA_KOPO2-MENGE = TEMENGE.
APPEND WA_KOPO2 TO GT_KOPO1.
TEMENGE = 0.
CLEAR WA_KOPO2.
ENDAT.
CLEAR WA_KOPO1.
ENDLOOP.
ENDIF.
汇总操作
最新推荐文章于 2022-05-03 20:10:23 发布