VL10U

Documentação:

Descrição da tabela:

Tabela não implementada, falta as tabelas no databricks para o densenvolvimento: (ZITFSD122_MAPA_EXPEDICAO_U)

Tabelas utilizadas:

1. 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

Documentação de desenvolvimento - Basseto

1 -Data-types 2 - Regra de desenvolvimento

Open