PO接口表

时间：2024-06-21 20:06:50
---物料主数据接口

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;

TRUNCATE TABLE PO_MARA;

TRUNCATE TABLE PO_MARC;

TRUNCATE TABLE PO_MVKE;

TRUNCATE TABLE PO_MARM;

TRUNCATE TABLE PO_EKGRP;

TRUNCATE TABLE PO_MATKL;

SELECT * FROM STG.PO_MARA;

SELECT * FROM STG.PO_MARC;

SELECT * FROM STG.PO_MARM;

SELECT * FROM STG.PO_MVKE;

select * from PO_MARA t where t.WGBEZ='';

update PO_MARA t set t.WGBEZ='' where t.WGBEZ='';

---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 * FROM STG.PO_STKO;

SELECT * FROM STG.PO_STPO;

SELECT * FROM STG.PO_MAST;

TRUNCATE TABLE STG.PO_STKO;

TRUNCATE TABLE STG.PO_STPO;

TRUNCATE TABLE 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;

select * from STG.PO_PLKO;

SELECT * FROM STG.PO_PLPO;

SELECT * FROM STG.PO_MAPL;

SELECT * FROM STG.PO_PLMZ;

--物料组 CgzmsService

---根据MARA表中的MATKL更新WGBEZ

SELECT * FROM PO_MATKL; 

--采购组 EtmatklService

 ---根据MARC表中的EKGRP更新EKNAM

SELECT * FROM PO_EKGRP;

---物料主数据接口

delete from STG.PO_MARA;

delete from STG.PO_MARC;

delete from STG.PO_MARM;

delete from STG.PO_MVKE;

---BOM接口

delete FROM STG.PO_STKO;

delete FROM STG.PO_STPO;

delete FROM STG.PO_MAST;

---工艺路线

delete FROM STG.PO_PLKO ;

delete FROM STG.PO_PLPO;

delete FROM STG.PO_MAPL ;

delete FROM STG.PO_PLMZ ;

select count(*) from stg.PO_WEBSERVICE_LOG

select * from stg.PO_WEBSERVICE_LOG t where to_char(create_date,'YYYY-MM-DD hh24:mi:ss')  between '2018-08-10 00:00:01' and '2018-08-10 23:59:59';

TRUNCATE TABLE stg.PO_WEBSERVICE_LOG;

select * from PO_STKO t where t.WERKS='';

select count(*) from PO_STKO t where t.WERKS='';

select count(*) from PO_STKO t where t.WERKS='';

select count(*) from PO_STKO t where t.WERKS='';

select count(*) from PO_PLKO t where t.WERKS='';

select count(*) from PO_PLKO t where t.WERKS='';

select count(*) from PO_PLKO t where t.WERKS='';

select* from PO_PLKO where to_char(adddate,'YYYY-MM-DD hh24:mi:ss')  between '2018-05-22 00:00:01' and '2018-05-22 23:59:59';

select* from PO_PLKO where to_char(adddate,'YYYY-MM-DD hh24:mi:ss')  between '2018-05-15 00:00:01' and '2018-05-15 23:59:59';

select  plnnr from po_plko_log where to_char(adddate,'YYYY-MM-DD hh24:mi:ss')  between '2018-05-16 00:00:00' and  '2018-05-16 23:59:59' group by plnnr;

select* from PO_PLKO t1 where t1.PLNNR in(50424061);

select count(*) from po_plko_log;

select * from po_plko_log where PLNNR in (50424061)

select * from PO_PLKO t where t.WERKS='';

select * from PO_PLKO t where t.WERKS='';

select * from PO_PLKO t where t.WERKS='';

select min(adddate) from po_plko_log;

truncate table po_plko_log;

select * FROM STG.PO_PLKO where PLNNR in (50420021,   50419947,  50419866)

select * from po_plko_log;

BOM：http://10.10.0.5:8080/BOM/services/pobom?wsdl
物料主数据：http://10.10.0.5:8080/ITEM/services/poitem?wsdl
工艺路线：http://10.10.0.5:8080/BOM/services/pogylx?wsdl
物料组：http://10.10.0.5:8080/BOM/services/pomatkl?wsdl
采购组：http://10.10.0.5:8080/BOM/services/poekgrp?wsdl

PLM_BOM：http://10.10.1.169:8001/PlmWebService/services/plmBom?wsdl
PLM_物料组：http://10.10.1.169:8001/PlmWebService/services/plmEtmatk?wsdl
PLM_物料主数据：http://10.10.1.169:8001/PlmWebService/services/plmItem?wsdl

相关文章