工單入庫超過工單數量的處理

標籤：os   2014   re   c   ar   rom   

*物料憑證 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‘.