1)关于计算交货单的可能的输入到发票校验(MIRO)可以参见RM08RL82
计算的说明:
1)读取适合条件的EKKO
SELECT * FROM "EKKO"
WHERE
"MANDT" = '800' AND "BSTYP" IN ('L' , 'F') AND "EBELN" = ''4500000005' AND "BUKRS" = '1002'
AND "LIFRE" = '0011000843' AND "FRGRL" = '' AND "LOEKZ" = ' ' AND ( "MEMORY" =' ' OR "MEMORY" IS NULL )
2)根据读取出的EKKO读取EKPO和EKBE
SELECT * FROM EKPO WHERE "MANDT" = '800' AND "EBELN" = '4500000005' AND "REPOS" = 'X' AND "LOEKZ" = ' '
SELECT * FROM EKBE WHERE "MANDT" = '800' AND "EBELN" = '4500000005' AND ( "VGABE" = '1' OR "VGABE" = '2' )
3)循环读取EKKO的内表,来计算EKBE的交货和发货的的数量和金额,来
MM--关于MIRO的分析基于订单的发票校验的跟踪
最新推荐文章于 2024-03-06 10:35:26 发布