Documentação:
Descrição da tabela:
tabela fato de transporte
Tabelas Utilizadas:
SAP.TROLZ
SAP.TVRO
SAP.LFA1
SAP.TVROT
Montagem:
Query
SELECT
REM.ALAND AS PAIS
,REM.AZONE AS ZONA_PARTIDA
,REM.GRULG AS GRUPO_PESO
,REM.LLAND AS PAIS_DESTINO
,REM.LZONE AS ZONA_TRANSPORTE
,REM.ROUTE AS ITINERARIO_REAL
,REM.VSBED AS COND_EXPEDICAO
,ITI.DISTZ AS DISTANCIA
,ITI.MEDST AS UM_DISTANCIA
,ITI.TDIIX AS RELEVA_TRANSPOR
,ITI.TDLNR AS TRANSPORTADOR
,cast (ITI.TRAZTD/240000 as DECIMAL(11,0)) AS DURA_TRANSITO_DIAS
,cast (ITI.TRAZTD/10000 as DECIMAL(11,0)) AS DURA_TRANSITO_HORAS
,FORN.LIFNR AS FORNECEDOR
,FORN.NAME1 AS NOME_FORNECEDOR
,TX.BEZEI AS ITINERARIOS
FROM SAP.TROLZ AS REM
INNER JOIN SAP.TVRO AS ITI
ON REM.ROUTE = ITI.ROUTE
LEFT JOIN SAP.LFA1 AS FORN
ON ITI.TDLNR = FORN.LIFNR
INNER JOIN SAP.TVROT AS TX
ON ITI.ROUTE = TX.ROUTE
Databricks:
camada_semantica.ZITRTR022