工单入库超过工单数量的处理

*物料凭证 5004181692
*特殊用途分类帐 1027276368
*统驭凭证 1013290872
*物料帐分类帐 1001303070

 

CKMC

*物料 140009879
*物料评估号 100907514

*物料凭证 5004181692
UPDATE MSEG SET MENGE = '0' ERFMG = '0' BSTMG = '0' WHERE MBLNR = '5004181692'.
UPDATE MLAUF SET MENGE = 0 BSTMG = 0 WHERE GJAHR = '2014' AND BELNR = '5004181692'.
UPDATE aufm SET MENGE = '0' ERFMG = '0' WHERE MBLNR = '5004181692' and mjahr = '2014'.
*工单号 '000010286028' .
UPDATE AFPO SET WEMNG = '0' WHERE AUFNR = '000010286028' . "收货数量
UPDATE COSL SET LST007 = 0 WHERE OBJNR = 'OR000010286028' AND WRTTP = '04' AND GJAHR = '2014'.
*统驭凭证 1013290872
UPDATE COEPL SET LSTBTR = 0 LSBBTR = 0 WHERE BELNR = '1013290872' AND GJAHR = '2014' .

* 物料帐分类帐评估号 从CKMLHD中查出
DELETE FROM MLCD WHERE KALNR = '000100907514' AND BDATJ = '2014' AND POPER = '007'.
DELETE FROM CKMLPP WHERE KALNR = '000100907514' AND BDATJ = '2014' AND POPER = '007'.
DELETE FROM CKMLCR WHERE KALNR = '000100907514' AND BDATJ = '2014' AND POPER = '007'.

*物料帐分类帐
UPDATE MLPP SET LBKUM = 0 WHERE BELNR = '1001303070' AND BDATJ = '2014' AND POPER = '007'.
UPDATE MLPPF SET MENGE = 0 WHERE BELNR = '1001303070' AND BDATJ = '2014' AND POPER = '007'.

* "特殊用途分类帐
UPDATE GLFUNCA SET MSL = 0 WHERE DOCNR = '1027276368' and ryear = '2014' AND POPER = '007'.