Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Diagrama do ETL Tabelas Large

<diagrama>

Tabelas de Revestimento Cerâmico (SAP S4 HANA)

Tabela

Filtro

endpoint

SAP_S4.VBFA

ERDAT

erdat

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/vbfa?erdat=2022-03-16T00:00:00

SAP_S4.ACDOCA

rbukrs, vorgn, gjahr, poper, budat

http://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/acdoca?rbukrs=BRCE&vorgn=SD00&gjahr=2022&poper=003&budat=2022-03-20

SAP_S4.KNA1

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/kna1

SAP_S4.LFA1

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/lfa1

SAP_S4.KNVV

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/knvv

SAP_S4.KNVP

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/knvp

SAP_S4.PRCD_VBAK

dataDelta, kschl

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/prcd_vbak?dataDelta=2021-01-18T00:00:00&kschl=kschl eq 'ZD01' or kschl eq 'ZD02' or kschl eq 'ZD03' or kschl eq 'ICMI'

SAP_S4.PRCD_VBRK

dataDelta, kschl

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/prcd_vbrk?dataDelta=2021-08-04T00:00:00&kschl=kschl eq 'ZD01' or kschl eq 'ZD02' or kschl eq 'ZD03' or kschl eq 'ICMI'

SAP_S4.VBAK

dataDelta

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/vbak?dataDelta=2021-08-18T00:00:00

SAP_S4.VBAP

dataDelta

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/vbap?dataDelta=2021-01-18T00:00:00

SAP_S4.VBEP

dataDelta

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/vbep?dataDelta=2021-01-18T00:00:00

SAP_S4.VBKD

dataDelta

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/vbkd?dataDelta=2021-01-18T00:00:00

SAP_S4.VBRP

dataDelta

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/vbrp?dataDelta=2021-01-01T00:00:00

SAP_S4.VBPA

dataDelta

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/vbpa?dataDelta=2021-01-18T00:00:00

SAP_S4.VBRK

SAP_S4.VBFA

dataDelta

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/vbrk?dataDelta=2021-08-02T00:00:00

SAP_S4.CDHDR

SAP_S4.CDHDR

udate, tabname, changind

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/CDHDR?udate=2021-11-22T00:00:00&tabname=VBAK&changind=D

SAP_S4.

ACDOCASAP_S4.PORTALTM

PORTALTM

aggr_assgn_start_l

https://dtxhep.it-cpi013-rt.cfapps.us21.hana.ondemand.com/http/TM_FU?aggr_assgn_start_l=2022-01-18T00:00:00

SAP_S4.PORTALTM_D_SAP_ZCDSTMPORTALFU

essa tabela é o delta da sap_s4.portaltm, deveria estar no schema sap

Chamadas de API CDSView S4 HANA

Arquivos do SAP ECC

Nome dos arquivo CSV

Fluxo Tabelas Tabelas Large

...

Roadmap das atividades