由于SAP系统的委外倒冲,有时候会多冲(1PCS),造成MRP运算后异常,如图:
分析原因:
由于委外申请或委外订单所对应的预留单(表RESB)中提货数量大于需求数量造成的。
处理方法:
(1)当委外申请对应的预留单中提货数量大于需求数量时。
把委外申请单的结算标识勾选并保存即可,如图:
通过程序批量处理(示意代码):
“找出所有有问题的采购申请
SELECT
eban~werks "工厂
eban~matnr "物料
eban~txz01 "物料描述
eban~banfn "采购申请
eban~bnfpo "行项目
eban~bsart "凭证类型
eban~bstyp "项目类别
eban~loekz "删除标识
eban~frgkz "审批状态
eban~ekgrp "采购组
eban~badat "采购申请创建日期
eban~lfdat "采购申请交货日期
eban~frgdt "采购申请批准日期
eban~menge "采购申请数量
eban~lgort "库位
INTO CORRESPONDING FIELDS OF TABLE gt_itab
FROM eban
INNER JOIN RESB on eban~BANFN = RESB~BANFN AND eban~BNFPO = RESB~BNFPO
WHERE eban~werks IN s_werks
AND eban~matnr IN s_matnr
AND eban~banfn IN s_banfn
AND eban~bnfpo IN s_bnfpo
AND RESB~matnr IN s_matnr1
AND Pstyp = '3' "项目类别
AND loekz NE 'X' "删除标识
AND ebakz NE 'X' "结算标识
AND RESB~ENMNG > RESB~BDMNG "提货数量大于需求单
”循环处理有问题的委外采购申请
DATA:lt_return TYPE STANDARD TABLE OF bapireturn,
ls_return TYPE bapireturn.
FIELD-SYMBOLS : <FS_PR> TYPE BAPIMEREQITEM .
DATA : I_RETURN TYPE TABLE OF BAPIRET2 ,
K_PRITEMX LIKE BAPIMEREQITEM ,
I_PRITEM_GET TYPE TABLE OF BAPIMEREQITEM ,
I_PRITEM_GET_LINE LIKE LINE OF I_PRITEM_GET ,