Differences

This shows you the differences between two versions of the page.

--- cli:franke:erp_sap_integration [2016/12/13 08:13]
127.0.0.1 external edit
+++ cli:franke:erp_sap_integration [2022/01/18 11:57] (current)
n.bergantino [Berbentina plant integration]
@@ Line 257: / Line 257: @@
 |I_HEADER_DATA|BOOLEAN|If true it indicates that it's required working-order header data|
 |I_OPERATIONS_DATA|BOOLEAN|If true it indicates that it's required working-order operation data|
+|I_SERIALNO_DATA|Not used|
 If I_HEADER_DATA is true then RFC answers with the following table:
 ^Component^Component type^Field Type^Size^Decimals^Description^
@@ Line 297: / Line 298: @@
 {{:cli:franke:flow-chart-sap-fox-nis-actual.png|}}
+====== T_HEADER_DATA: used fields =====
+  * MATNR
+  * MAKTX
+  * GSTRP
+  * GLTRP
+  * GMEIN
+  * GAMNG
+  * WEMNG
+  * IGMNG
+  * AUFNR
+  * FK_ANZMA
+  * FK_PERNNR
+  * MATGR
+In the following the code that is using the above fields.
+<code java>
+rv.setValue("codop", rueck);
+rv.setValue("codmod", rt.getString("MATNR"));
+rv.setValue("descrizio", rt.getString("MAKTX").replaceAll("[^a-zA-Z0-9 _-]+", "_"));
+rv.setValue("din", rt.getString("GSTRP"));
+rv.setValue("dfi", rt.getString("GLTRP"));
+rv.setValue("um", rt.getString("GMEIN"));
+rv.setValue("qtot", rt.getString("GAMNG"));
+rv.setValue("q1", rt.getString("WEMNG"));
+rv.setValue("qconf", rt.getString("IGMNG"));
+rv.setValue("codprog", rt.getString("AUFNR"));
+rv.setValue("ndip", rt.getString("FK_ANZMA"));
+rv.setValue("codsq", rt.getString("FK_PERNNR"));
+rv.setValue("matgr", rt.getString("MATGR"));
+</code>
+===== T_OPERATIONS_DATA: used fields =====
+  * VGW04
+  * ANZMA
+  * VGW03
+  * VGE03
+  * ARBPL
+  * LTXA1
+  * BMSCH
+  * VGW01
+In the following the code that is using the above fields.
+<code java>
+double tc = Double.parseDouble(ro.getString("VGW04"));
+if(tc == 0.0){
+  double ndi = Double.parseDouble(ro.getString("ANZMA"));
+  if(ndi != 0.0){
+    tc = Double.parseDouble(ro.getString("VGW03")) / ndi;
+  }
+}
+if(ro.getString("VGE03").equals("S")){
+  ///tc gia' in secondi non faccio nulla
+}else if(ro.getString("VGE03").equals("MIN")){
+  ///converto il tc da minuti a secondi
+  tc *= 60;
+}else if(ro.getString("VGE03").equals("H") || ro.getString("VGE03").equals("STD")){
+  ///converto il tc da ore a secondi
+  tc *= 3600;
+}
+//rv.setValue("codriso", ro.getString("VORNR"));
+rv.setValue("codriso", ro.getString("ARBPL"));
+rv.setValue("descrizio", ro.getString("LTXA1"));
+///unita di misura del tempo (1=minuti)
+rv.setValue("unptm", ro.getString("BMSCH"));
+///numero di persone dedicate alla linea
+rv.setValue("ndiptm", ro.getString("ANZMA"));
+///tempo previsto per il setup
+rv.setValue("tmsetup", ro.getString("VGW01"));
+///tempo ciclo di linea gia' elaborato ovvero e' la cadenza della linea in secondi
+rv.setValue("tm", tc);
+///tempo dell'intera operazione va diviso per il numero di persone e si ottiene il tm
+rv.setValue("tmoper", ro.getString("VGW03"));
+</code>