TRANSPORTE 1

Documentação:

Descrição da tabela:

Tabela fato com informações de transportes

Tabelas utilizadas:

1. SAP._SCMTMS_D_TORROT

2. SAP._SCMTMS_D_TORITE

Montagem:

1. Select da tabela _SCMTMS_D_TORROT trazendo os campos:
   DB_KEY,TOR_ID,TOR_CAT,TOR_TYPE,CREATION_TYPE,LABELTXT,BL_NODE_KEY,DOC_CHECK_STATUS
   ,AUTO_PLAN,TRANSSRVLVL_CODE,FIX_ASSGN_REQ_TOR,LOCSEQ_SYNC,TSP,TSPID,TSP_SET_BY_SRVC
   ,SHIPPER_KEY,SHIPPERID,CONSIGNEE_KEY,CONSIGNEEID,PLN_SCT_REL,CONS_ALLOWED,STOP_SEQ_TYPE
   ,TRACK_EXEC_REL,FINAL_EXEC_EVENT,DFLT_WEI_UOM,DFLT_VOL_UOM,PURCH_ORG_ID,LIFECYCLE
   ,SHPM_TRANSM,PLAN_STATUS_ROOT,EXECUTION,COMPLIANCE,DELIVERY,BASE_BTD_TCO,BASE_BTD_ID
   ,BASE_BTD_VERSION,BASE_BTD_KEY,FUBR_KEY,TRQ_CAT,TRQ_UNIQUE,EST_MA_DATE,DLV_PRIO
   ,MTR,TRMODCOD,TRMODCAT,GRO_WEI_VAL,GRO_WEI_UNI,SUBCONTRACTING,DATETIME_CHSCS
   ,USER_ID_CHSCS,DATETIME_CHSCC,USER_ID_CHSCC,CREATED_BY,CREATED_ON,CHANGED_BY
   ,CHANGED_ON,DATETIME_CHLC,USER_ID_CHLC,ORDER_DATE,LOAD_PLAN_STATUS,DLV_PLANNING
   ,DLV_GOODS_MVMNT,DLV_DISTRIBUTION,DLV_LOADING_DATE,DLV_PLAN_GOODS_MVMNT_DATE,DLV_DELIVERY_DATE

2. Join com a tabela: _SCMTMS_D_TORITE trazendo os campos:

PARENT_KEY,ITEM_ID,ITEM_PARENT_KEY,NODE_HAS_ERROR,SRC_STOP_KEY,DES_STOP_KEY,ITEM_SORT_ID
,ITEM_DESCR,ITEM_CAT,MAIN_CARGO_ITEM,SP_ADDRESS_ID,SHIPPER_ID,CP_ADDRESS_ID,CONSIGNEE_ID,b.GRO_VOL_VAL,GRO_VOL_UNI,NET_WEI_VAL,NET_WEI_UNI,QUA_PCS_VAL,QUA_PCS_UNI,QUA_PCS2_VAL,QUA_PCS2_UNI,BASE_UOM_VAL,BASE_UOM_UNI,LENGTH,WIDTH,HEIGHT,MEASUOM,AMT_GDSV_VAL,AMT_GDSV_CUR,AMT_INSV_VAL,AMT_INSV_CUR,AMT_GDSVC_VAL,AMT_GDSVC_CUR,PRODUCT_ID,PRD_KEY,PRD_TRANSP_GRP,ERP_PLANT_ID,ERP_COMP_ORG_ID,ERP_COMP_CODE,LGORT,COST_DIST_RELEVANCE,PIC_EAR_ACCTRQ,DES_LOC_IDTRQ,DES_LOC_KEYTRQ,DEL_EAR_REQTRQ,HANDLING_EXEC,UNLOAD_PLAN_STATUS,LOAD_PLAN_ITEM_STATUS,UNLOAD_PLAN_ITEM_STATUS,INC_CLASS_CODE,INC_TRANSF_LOC_N,REF_ITEM_KEY,REF_ROOT_KEY,REF_BO,LOCAL_ITEM,ORIG_REF_ITEM,ORIG_REF_ROOT,ORIG_REF_BO,ORIG_REF_PARENT_ITEM,FU_ROOT_KEY,TRQ_ITEM_ID,REF_TRQ_ITEM_KEY,REF_TRQ_ROOT_KEY,SALES_QTY_VAL,SALES_QTY_UNI,BASE_BTD_LOGSYS,BASE_BTDITEM_KEY,BASE_BTDITEM_TCO,BASE_BTDITEM_ID,BUYORIG_BTD_ID,ORIG_BTD_TCO,ORIG_BTD_ID,ORIG_BTDITEM_TCO,ORIG_BTDITEM_ID,WM_LOGSYS,WM_WH_NUMBER

Databricks:

 camada_semantica.transporte_1

Documentação de desenvolvimento - Basseto

1 -Data-types 2 - Regra de desenvolvimento

Open