I_TransportationOrder

Transportation Orders | view: ITRANSPORDER | TRAN | Extraction: Not supported | Component: Freight Order Management
Column Name Description
TransportationOrderUUID Transportation Order UUID
Column Name Description
Column Name Description
📏 Gross Weight Unit of Measure (TranspOrdGrossWeightUnit):
TranspOrdGrossWeight Gross Weight
📏 Gross Volume Unit of Measure (TranspOrdGrossVolumeUnit):
TranspOrdGrossVolume Gross Volume
📏 Net Weight Unit of Measure (TranspOrdNetWeightUnit):
TranspOrdNetWeight Net Weight
📏 Quantity Unit of Measure (TranspOrdQuantityUnit):
TranspOrdQuantity Quantity
📏 Alternative Quantity 2 Unit of Measure (TranspOrdAlternativeQtyUnit):
TranspOrdAlternativeQty Alternative Quantity
📏 Base Unit of Measure (TranspOrdBaseQuantityUnit):
TranspOrdBaseQuantity Base Quantity
📏 Tare Weight Unit of Measure (TranspOrdTareWeightUnit):
TranspOrdTareWeight Tare Weight
📏 Number of TEU Unit of Measure (TranspOrdNumberOfCtnsUnit):
TranspOrdNumberOfCtns Number of Twenty-Foot Equivalent Units
📏 Unit of Measure for ADR 1.1.3.6 DG Exemption Points (TranspOrdDngrsGdsExmpPtsUnit):
TranspOrdDngrsGdsExmpPts ADR 1.1.3.6 DG Exemption Points
Column Name Description
Column Name Description
TransportationOrderCategory Business Document Category Show values
DangerousGoodsAreContained Dangerous Goods Show values
TranspOrdPlanningBlock Planning Block Show values
TranspOrdExecutionIsBlocked Execution Block Show values
InvoicingIsBlocked Freight Settlement Document Block Show values
CarrierOriginOfEntry Origin of Entry Show values
TranspOrdTrafficDirection Traffic Direction Show values
TranspOrdLifeCycleStatus Life Cycle Status Show values
TranspOrdPlanningStatus Planning Status Show values
TransportationOrderExecSts Execution Status Show values
TranspOrderDngrsGdsSts Dangerous Goods Status Show values
TransportationOrderConfSts Confirmation Status Show values
TranspOrderSubcontrgSts Subcontracting Status Show values
TransportationModeCategory Transportation Mode Category Show values
TransportationRequestCategory Category (Forwarding Order/Quotation or Trsp. Reqt) Show values
FrtDsputCaseStatus Dispute Case Status Show values
Column Name Description Domain name
TransportationOrder Document /SCMTMS/TOR_ID
TransportationServiceLevel Transportation Service Level - Carrier /SCMTMS/TRANSP_SLC_CARRIER
TranspOrdResponsiblePerson Person Responsible UNAME
TranspOrdPartnerReference Partner Reference Number CHAR35
MasterBillOfLading Carrier's Master Bill of Lading Number CHAR35
CarrierUUID Business Partner GUID SYSUUID
Carrier Carrier /SCMTMS/BU_PARTNER
StandardCarrierAlphaCode Standard Carrier Alpha Code /SCMTMS/SCACD
TranspOrdAirlineIATACode IATA Airline Code /SCMTMS/AIRLC
TranspOrdAirWayBill Air Waybill Prefix CHAR3
CarrierAddressID Unique Identifier for Address (APC_V_ADDRESS_ID)
ShipperUUID Business Partner GUID SYSUUID
Shipper Shipper BU_PARTNER
ShipperAddressID Unique Identifier for Address (APC_V_ADDRESS_ID)
ConsigneeUUID Business Partner GUID SYSUUID
Consignee Ship-to Party BU_PARTNER
ConsigneeAddressID Unique Identifier for Address (APC_V_ADDRESS_ID)
TranspOrdShippingType Shipping Type /SCMTMS/SHIPPING_TYPE
MovementType Movement Type /SCMTMS/MOVEMENT_TYPE
PlngAndExecOrganization Planning and Execution Organization HROBJID
PlngAndExecGroup Planning and Execution Group HROBJID
PurchasingOrgExternalID Organizational Unit: External ID /SCMB/ORG_EXT_ID
PurchasingGroupExternalID Organizational Unit: External ID /SCMB/ORG_EXT_ID
PurgOrgCompanyCode Company Code Procuring the Transportation Service BUKRS
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
TransportationMode Transportation Mode VKTRA
TranspOrdMaxUtilznRatio Maximum Utilization
TranspOrdMaxUtilznMassRatio Transportation Order Max 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
TranspOrdDistance Total Distance in km
TranspOrdNetDuration Transportation Time of a Transportation Lane (in hhmmss) TSTRDURAH
CreatedByUser Created By XUBNAME
CreationDateTime Created on Timestamp TZNTSTMPS
LastChangedByUser Changed By XUBNAME
ChangedDateTime Created on Timestamp TZNTSTMPS
TranspOrdLfcycStsChgDteTime Created on Timestamp TZNTSTMPS
TranspOrdOrderDateTime Created on Timestamp TZNTSTMPS
BusinessTransactionDocument Base Business Transaction Document /SCMTMS/BTD_ID
Master Data Relations Join Conditions
Base Document Type for Business Transaction
  • Client
  • Base Document Type for Business Transaction
Purchasing Group
  • ?
  • ?
  • Client
  • Purchasing Group
  • I_TRANSPORTATIONORDER.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TRANSPORTATIONORDER.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_TRANSPORTATIONORDER.MANDT == PLOGI.MANDT
  • I_TRANSPORTATIONORDER.PURCHASINGGROUP == PLOGI.OBJID
Purchasing Organization
  • ?
  • ?
  • Client
  • Purchasing Organization
  • I_TRANSPORTATIONORDER.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TRANSPORTATIONORDER.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_TRANSPORTATIONORDER.MANDT == PLOGI.MANDT
  • I_TRANSPORTATIONORDER.PURCHASINGORGANIZATION == PLOGI.OBJID
Business Document Type
  • Business Document Type
  • Client