cli:franke:erp_flashing_back

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== ERP Flashing back ======

{{:cli:franke:franke-flashing-back.png|}}

<code sql>
CREATE TABLE trserp (
    codice integer NOT NULL,
    codop character varying(51),
    codubi character varying(51),
    codoper character varying(51),
    datatrs character varying(9),
    oratrs character varying(9),
    tmtrs integer,
    filename character varying(101)
);
COMMENT ON COLUMN trserp.datatrs IS 'Data di trasferimento';
COMMENT ON COLUMN trserp.oratrs IS 'Ora di trasferimento';
COMMENT ON COLUMN trserp.tmtrs IS 'Tm di trasferimento';
COMMENT ON COLUMN trserp.filename IS 'Nome del file generato';
ALTER TABLE ONLY trserp
    ADD CONSTRAINT trserp_pkey PRIMARY KEY (codice);
</code>


===== ProAlpha =====
<code xml>
<?xml version="1.0"?>
<dsOEE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Activity>
    <Company>000</Company>
    <WorkOrderNumber>1220433</WorkOrderNumber>
    <IDAct>1683438</IDAct>
    <ActPos>50</ActPos>
    <Qty>444</Qty>
    <QtyScrap>1</QtyScrap>
    <ScrapRemark>Ausschuss</ScrapRemark>
    <Resource>821102</Resource>
    <Finished>no</Finished>
    <TimeTE>43294</TimeTE>
    <TimeTR>3514</TimeTR>
    <TimeUnit>0</TimeUnit>
  </Activity>
</dsOEE>
</code>

Il dato relativo ad ActPos va ricavato dal file di Input vedi sotto: \\ \\
{{:cli:franke:selezione_712.png|}} \\ \\
Dal file di Input bisogna alimentare la relazione "activity" dichiarata sotto \\ \\
{{:cli:franke:franke-proalpha-activity.png|}} \\ \\

<code sql>
CREATE TABLE activity (
    codice integer NOT NULL,
    codop character varying(51),
    codubi character varying(51),
    idact character varying(51),
    actpos character varying(51)
);
COMMENT ON COLUMN activity.codop IS 'Codice ordine di produzione (ordprod.codop)';
COMMENT ON COLUMN activity.codubi IS 'Codice ubicazione (ubicaz.codice)';
ALTER TABLE ONLY activity
    ADD CONSTRAINT activity_codop_codubi_key UNIQUE (codop, codubi);
ALTER TABLE ONLY activity
    ADD CONSTRAINT activity_pkey PRIMARY KEY (codice);
ALTER TABLE ONLY activity 
    ADD CONSTRAINT activity_codop_fkey FOREIGN KEY (codop) REFERENCES ordprod(codop) ON DELETE CASCADE;
ALTER TABLE ONLY activity 
    ADD CONSTRAINT activity_codubi_fkey FOREIGN KEY (codubi) REFERENCES ubicaz(codice) ON DELETE CASCADE;
</code>

==== Query per visualizzare tali dati ====
Aktivität (Workorder Position/machine):
<code sql>
select identif from ubicaz where codice='821102A';
</code>
Menge Gut (number of good parts):
<code sql>
select sum(movimag.qta) as npp from movimag inner join (lottim inner join (prodord inner join produbi on prodord.codprod=produbi.codice) on prodord.codop=lottim.procord) on movimag.codlot=lottim.codice where produbi.codubi='821102A' and prodord.codop='1220433' and (produbi.tmfi>'1493902281'or produbi.tmfi is null) and movimag.codcau='PREL' and movimag.codubi='821102A';
</code>
Menge Ausschuss (number of scrap):
<code sql>
select sum(movimag.qta) as nps from movimag inner join (lottim inner join (prodord inner join produbi on prodord.codprod=produbi.codice) on prodord.codop=lottim.procord) on movimag.codlot=lottim.codice where produbi.codubi='821102A' and prodord.codop='1220433' and (produbi.tmfi>'1493902281'or produbi.tmfi is null) and movimag.codcau='SCAPR' and movimag.codubi='821102A';
</code>
Buchungshinweis (additional information about scrap):
<code sql>
select causanc.codice, movimag.qta from causanc inner join (movimag inner join (lottim inner join (prodord inner join produbi on prodord.codprod=produbi.codice) on prodord.codop=lottim.procord) on movimag.codlot=lottim.codice) on causanc.codice=movimag.caudef where produbi.codubi='821102A' and prodord.codop='1220433' and (produbi.tmfi>'1493902281'or produbi.tmfi is null) and movimag.codcau='SCAPR' and movimag.codubi='821102A';
</code>
Abgeschlossen (AkvP fertig) (status of work order partly oder finished):
<code sql>
select sum(movimag.qta) as status from movimag inner join lottim on movimag.codlot=lottim.codice where movimag.codcau='PREL' and lottim.procord='1220433';
</code>
Mitarbeiter Nr. (ident. nr. of worker):
<code sql>
select (CASE WHEN ndip IS NULL THEN '1' ELSE ndip END) AS nrworkers from ordprod where codop='1220433';
</code>
Zeit te (working time machine/100st) ???:
<code sql>
select sum(tmdiff) from movimag where codcau='INFM' and tm>'1493902281' and tm<'1493976666' and codubi='821102A';
</code>
Zeit tr (setup time) ???:
<code sql>
select sum(tmdiff) from movimag where codcau='FIFM' and caufm='setup' and tm>'1493902281' and tm<'1493976666' and codubi='821102A';
</code>

===== SAP flashing-back =====
The RFC function module name is /FOX/PP_ANDON_CONF
  * Parameters: 
    * budate = posting date
    * store = default 0
    * EXNAM = defautl space
    * iv_conftime is a structure - order number and yield quantity and unit of measure should be in, the times can be empty.

{{:cli:franke:selezione_769.png?1000|}} \\ \\

    * iv_rueck contains the confirmation numbers. 
The export parameter subrc = S - in case it worked or E it failed. 

Here the different views on the FM you can call. all is on QE1 our test system need to be called via logon groups as for the other one before.  \\ \\
{{:cli:franke:sap-fb-1.png?700|}} \\ \\
{{:cli:franke:sap-fb-2.png?900|}}

==== RFC /FOX/PP_ANDON_CONF: Data dictionary new version ====

^Field name^Description^
|BUDAT|Data|
|AUFNR|Work order|
|IV_RUECK|Order confirmation|
|GAMNG|Number of produced items|
|GMEIN|Unit of measure (ST)|
|IV_FINAL|confirmed CNF state|
|IV_SCRAP|number of scrap items|