PO ITEM_BOM_工艺路线SQL

---物料主数据接口

SELECT count(*)PO_MARA FROM STG.PO_MARA;

SELECT count(*)PO_MARC FROM STG.PO_MARC;

SELECT count(*)PO_MARM FROM STG.PO_MARM;

SELECT count(*)PO_MVKE FROM STG.PO_MVKE;

--物料组

SELECT * FROM PO_MATKL; ---根据MARA表中的MATKL更新WGBEZ

--采购组

SELECT * FROM PO_EKGRP; ---根据MARC表中的EKGRP更新EKNAM

---BOM接口

SELECT count(*)PO_STKO FROM STG.PO_STKO;

SELECT count(*)PO_STPO FROM STG.PO_STPO;

SELECT count(*)PO_MAST FROM STG.PO_MAST;

---工艺路线

SELECT count(*)PO_PLKO FROM STG.PO_PLKO;

SELECT count(*)PO_PLPO FROM STG.PO_PLPO;

SELECT count(*)PO_MAPL FROM STG.PO_MAPL;

SELECT count(*)PO_PLMZ FROM STG.PO_PLMZ;