cli:franke:erp_integration_next_rest

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
cli:franke:erp_integration_next_rest [2023/01/16 10:07]
m.zingaretti [gestione ConfirmationGroup]
cli:franke:erp_integration_next_rest [2024/04/23 15:17] (current)
m.zingaretti [gestione ConfirmationGroup]
Line 77: Line 77:
 COMMENT ON TABLE public.sapinfoubi IS 'Tabella informazioni codop-codubi arrivate da SAP'; COMMENT ON TABLE public.sapinfoubi IS 'Tabella informazioni codop-codubi arrivate da SAP';
 COMMENT ON COLUMN public.sapinfoubi.codop IS 'Rueck Ricevuto da sap'; COMMENT ON COLUMN public.sapinfoubi.codop IS 'Rueck Ricevuto da sap';
-COMMENT ON COLUMN public.sapinfoubi.codubi IS 'codice postaizone';+COMMENT ON COLUMN public.sapinfoubi.codubi IS 'codice postazione';
 COMMENT ON COLUMN public.sapinfoubi.confgrp IS 'ConfirmationGroup da inviare con il flashingback'; COMMENT ON COLUMN public.sapinfoubi.confgrp IS 'ConfirmationGroup da inviare con il flashingback';
 COMMENT ON COLUMN public.sapinfoubi.ordope IS 'OrderOperation da inviare con il flashingback'; COMMENT ON COLUMN public.sapinfoubi.ordope IS 'OrderOperation da inviare con il flashingback';
Line 85: Line 85:
 ALTER TABLE ONLY public.sapinfoubi ADD CONSTRAINT ix_sapinfoubi_codubi FOREIGN KEY (codubi) REFERENCES public.ubicaz(codice) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE ONLY public.sapinfoubi ADD CONSTRAINT ix_sapinfoubi_codubi FOREIGN KEY (codubi) REFERENCES public.ubicaz(codice) ON UPDATE CASCADE ON DELETE CASCADE;
 </code> </code>
 +====== Crezione API ======
 +Generazione API, Avere Get a SAP Universal ID se manca crearlo dalla schermata di accesso \\
 +{{:cli:franke:pasted:20230329-085345.png?600}} \\
 +{{:cli:franke:pasted:20230329-085352.png?600}}
 +
 +Una volta entrato da questo link: \\  \\
 +https://frankeisprod.apibhubenterprise.cfapps.eu10.hana.ondemand.com/product/PRD_NEXTOEE \\ \\
 +Creare una nuova app: \\ \\
 +{{:cli:franke:pasted:20230329-085651.png?600}} \\ 
 +{{:cli:franke:pasted:20230329-085925.png?600}} \\
 +Usare queste nell'agente Rest (AgentRestSAP)
 +
 +
  • cli/franke/erp_integration_next_rest.1673860039.txt.gz
  • Last modified: 2023/01/16 10:07
  • by m.zingaretti