Documentação:
Descrição da tabela:
Tabela não implementada, falta as tabelas no databricks para o densenvolvimento: (ZITFSD122_MAPA_EXPEDICAO_U)
Tabelas utilizadas:
SAP.ZREP_MAPA_VL10U
Montagem:
1 - é feito um select na tabela base ZREP_MAPA_VL10U trazendo os seguintes campos:
WERKS as Centro
,SPDNR as AgenteFrt
,TKNUM as Transporte
,LDDAT as Dt_carreg
,INCO2 as Incotm2
,KUNWE as Receb_merc
,NAME1 as Nome_1
,ADRNR_WE as CidRecOrd
,VBELV as Doc_venda
,POSNV as Item
,VBELN as Fornmto
,MATNR as Material
,ARKTX as Denominac
,LFIMG as Qtd_forn
,BRGEW as Bruto
,VOLUM as Volume
,ERDAT as Em
,substring(ERZET,11,9) as Hora
,ERNAM as Criado_a
,AUART as Tipo_rem
,VKBUR as EscrVendas
,WBSTA as StatMvMerc
,MBDAT as DtPrepMat
,DATASAT as Data_
,TDDAT as OrgTransp
,KODAT as Data_pick
,cast(concat(left(ETDAT,4),'-',
substring(ETDAT,6,2),'-',
right(ETDAT,2)) as date) as Dt_remessa
,WADAT as SaidaMerc
,LFDAT as DataRem
,VKGRP as Eq_vendas
,INCO1 as Incoterms
,WADAT_IST as Dt_real_SM
camada_semantica.vl10u_mapa_expedicao