PO接口表

 

---物料主数据接口
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='123';

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

---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='2021';

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


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



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='2021';
select * from PO_PLKO t where t.WERKS='2022';
select * from PO_PLKO t where t.WERKS='2023';


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