I_TransportationOrderAnalytics

Transportation Order Analytics | view: ITRANSPORDANA | ATTR | Extraction: Full or Incremental | Component: Analytics
Column Name Description
TransportationOrderUUID Transportation Order UUID
Column Name Description
Column Name Description
📏 Gross Weight Unit of Measure (TranspOrdGrossWeightUnit):
TranspOrdGrossWeight Transportation Order Gross Weight
📏 Gross Volume Unit of Measure (TranspOrdGrossVolumeUnit):
TranspOrdGrossVolume Transportation Order Gross Volume
📏 Net Weight Unit of Measure (TranspOrdNetWeightUnit):
TranspOrdNetWeight Transportation Order Net Weight
📏 Tare Weight Unit of Measure (TranspOrdTareWeightUnit):
TranspOrdTareWeight Transportation Order Tare Weight
📏 Quantity Unit of Measure (TranspOrdQuantityUnit):
TranspOrdQuantity Transportation Order Quantity
📏 Number of TEU Unit of Measure (TranspOrdNumberOfCtnsUnit):
TranspOrdNumberOfCtns Transportation Order Number Of Containers
📏 Unit of Measure for ADR 1.1.3.6 DG Exemption Points (TranspOrdDngrsGdsExmpPtsUnit):
TranspOrdDngrsGdsExmpPts Transportation Order Dangerous Goods Exemption Points
📏 Transportation Order Distance Unit (TranspOrdDistanceUnit):
TranspOrdDistance Transportation Order Distance
Column Name Description
TranspOrdCreationDate Transportation Order Creation Date
Column Name Description
TransportationOrderCategory Transportation Order Category Show values
DangerousGoodsAreContained Transportation Order Dangerous Goods Show values
TranspOrdPlanningBlock Transportation Order Planning Block Show values
TranspOrdExecutionIsBlocked Transportation Order Execution Block Show values
InvoicingIsBlocked Transportation Order Invoicing is Blocked Show values
CarrierOriginOfEntry Carrier Origin of Entry Show values
TranspOrdTrafficDirection Traffic Direction Show values
TranspOrdLifeCycleStatus Transportation Order Life Cycle Status Show values
TranspOrdPlanningStatus Transportation Order Planning Status Show values
TransportationOrderExecSts Transportation Order Execution Status Show values
TranspOrderDngrsGdsSts Transportation Order Dangerous Goods Status Show values
TransportationRequestCategory Category (Forwarding Order/Quotation or Trsp. Reqt) Show values
TransportationModeCategory Transportation Mode Category Show values
FrtDsputCaseStatus Freight Dispute Case Status Show values
Column Name Description Domain name
TransportationOrder Transportation Order /SCMTMS/TOR_ID
NumberOfTransportationOrders Number of Transportation Orders /SCMTMS/VDM_NUMBER_OF
CreatedByUser Created By XUBNAME
TranspOrdCreationDateTime Transportation Order Creation Date Time TZNTSTMPS
LastChangedByUser Changed By XUBNAME
ChangedDateTime Changed On TZNTSTMPS
TranspOrdLfcycStsChgDteTime Transportation Order Life Cycle Status Change Date Time TZNTSTMPS
TranspOrdPartnerReference Partner Reference Number CHAR35
TranspOrdResponsiblePerson Transportation Order Responsible Person UNAME
TransportationServiceLevel Transportation Service Level - Carrier /SCMTMS/TRANSP_SLC_CARRIER
Carrier Carrier /SCMTMS/BU_PARTNER
CarrierUUID Carrier UUID /SCMTMS/VDM_DB_KEY
CarrierAddressID Carrier Address ID
StandardCarrierAlphaCode Standard Carrier Alpha Code /SCMTMS/SCACD
TranspOrdAirlineIATACode IATA Airline Code /SCMTMS/AIRLC
TranspOrdAirWayBill Air Waybill Prefix CHAR3
Shipper Shipper BU_PARTNER
ShipperUUID Shipper Universally Unique Identifier /SCMTMS/VDM_DB_KEY
ShipperAddressID Shipper Address ID
Consignee Ship-to Party BU_PARTNER
ConsigneeUUID Ship-to Party UUID /SCMTMS/VDM_BUPAUUID
ConsigneeAddressID Ship-to Party Address ID
TranspOrdShippingType Shipping Type /SCMTMS/SHIPPING_TYPE
MovementType Movement Type /SCMTMS/MOVEMENT_TYPE
PlngAndExecOrgExternalID Transportation Execution Organization /SCMB/ORG_EXT_ID
PlngAndExecGroupExternalID Transportation Execution Group /SCMB/ORG_EXT_ID
PurchasingOrgExternalID Transportation Purchasing Organization /SCMB/ORG_EXT_ID
PurchasingGroupExternalID Transportation Purchasing Group /SCMB/ORG_EXT_ID
BusinessTransactionDocument Base Business Transaction Document /SCMTMS/BTD_ID
MeansOfTransport Transportation Order Means of Transport /SCMTMS/TRANSMEANSTYPECODE
TransportationMode Transportation Mode VKTRA
TranspOrdMaxUtilznRatio Maximum Utilization
TranspOrdMaxUtilznMassRatio Transportation Order Maximum Utilization Mass Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdMaxUtilznVolumeRatio Transportation Order Max Utilization Volume Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdMaxUtilznLengthRatio Transportation Order Maximum Utilization Length Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdNetDuration Transportaton Order Net Duration TSTRDURAH
Master Data Relations Join Conditions
Base Document Type for Business Transaction
  • Base Document Type for Business Transaction
  • Client
  • I_TRANSPORTATIONORDERANALYTICS.BUSINESSTRANSACTIONDOCTYPE == /SCMTMS/C_BTDTY.BTD_TCO129
  • I_TRANSPORTATIONORDERANALYTICS.MANDT == /SCMTMS/C_BTDTY.CLIENT
Transportation Order Type
  • Transportation Order Type
  • Client