I_TransportationOrderItem

Transportation Order: Items | view: ITORITEM | TRAN | Extraction: Not supported | Component: Freight Order Management
Tables used: /SCMTMS/D_TORITEMARATMFGTMFGTMARAMAKTTTGRTTGRT
Column Name Description
TransportationOrderItemUUID UUID of Transportation Order Item with Conversion Exit
Column Name Description
💲 Goods Value Currency (TranspOrdItemGoodsValueCrcy):
TranspOrdItemGoodsValue null
Column Name Description
📏 Transportation Order Item Gross Weight Unit (TranspOrdItemGrossWeightUnit):
TranspOrdItemGrossWeight Transportation Order Item Gross Weight
📏 Transportation Order Item Gross Volume Unit (TranspOrdItemGrossVolumeUnit):
TranspOrdItemGrossVolume Transp Order Item Gross Volume
📏 Transportation Order Item Net Weight Unit (TranspOrdItemNetWeightUnit):
TranspOrdItemNetWeight Transportation Order Item Net Weight
📏 Transportation Order Item Quantity Unit (TranspOrdItemQuantityUnit):
TranspOrdItemQuantity Transportation Order Item Quantity
📏 Transportation Order Item Alternative Quantity Unit (TranspOrdItemAltvQtyUnit):
TranspOrdItemAltvQty Transportation Order Item Alternative Quantity
📏 Transp Orde Item Base Quantity UoM (TranspOrdItemBaseQtyUnit):
TranspOrdItemBaseQty Transportation Order Item Base Quantity
📏 Transportation Order Item Tare Weight Unit (TranspOrdItemTareWeightUnit):
TranspOrdItemTareWeight Transportation Order Item Tare Weight
📏 Transportation Order Item Number Of Containers Unit (TranspOrdItemNumberOfCtnsUnit):
TranspOrdItemNumberOfCtns Transportation Order Item Number Of Containers
📏 Unit of measure for length, width and height (TranspOrdItemLengthUnit):
TranspOrdItemLength Length
TranspOrdItemWidth Width
TranspOrdItemHeight Height
Column Name Description
Column Name Description
IsMultiItem Multi-Item Show values
TranspOrdItemCategory Item Category Show values
IsMainCargoItem Main Cargo Item Show values
TransportationModeCategory Transportation Mode Category Show values
TranspOrdItemIsDangerousGood Dangerous Goods Show values
TranspOrdItemDngrsGdsSts Dangerous Goods Status Show values
CargoIsHighValue High-Value Cargo Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID /SCMTMS/VDM_TOR_DB_KEY
TranspOrdItem Item /SCMTMS/ITEM_ID
TranspOrdItemType Transportation Order Item Type /SCMTMS/TOR_ITEM_TYPE
TranspOrdItemParentItemUUID Key of Transportation Order Item
SourceStopUUID Key of a Stop of a Transportation Order
DestinationStopUUID Key of a Stop of a Transportation Order
TranspOrdItemDesc Item Description /SCMTMS/ITEM_DESCRIPTION
PredecessorTransportationOrder NodeID /BOBF/CONF_KEY
Shipper Shipper BU_PARTNER
Consignee Ship-to Party BU_PARTNER
TransportationMode Transportation Mode VKTRA
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
TranspOrdActvVehRscePltNmbr Registration Number
MaterialFreightGroupName Description TEXT20
TransportationGroupName Description TEXT20
ProductID Product MATNR
ProductName Product Description TEXT40
TranspOrdDocReferenceID Base Business Transaction Document /SCMTMS/BTD_ID
TranspOrdDocReferenceItmID Base Document Item for Business Transaction /SCMTMS/BTD_ITEM_ID
TranspOrdDocReferenceItmType Base Document Item Type Code for Business Transaction /SCMTMS/BTD_ITEM_TYPECODE
TranspOrdItemSorting Sorting ID of Business Document Item /SCMTMS/TOR_ITEM_SORT_ID
ShipperUUID Shipper Universally Unique Identifier /SCMTMS/VDM_BUPAUUID
ConsigneeAddressID Unique Identifier for Address (APC_V_ADDRESS_ID)
ConsigneeUUID Ship-to Party UUID /SCMTMS/VDM_BUPAUUID
ProductUUID Product GUID
TranspOrdItemVoyage Voyage / Train Number /SCMTMS/VOYAGE_ID
TranspOrdItemFlight Airline Code and Flight Number /SCMTMS/FLIGHT_CODE
TranspOrdItemVessel Vessel /SCMTMS/VESSEL_ID
TranspOrdItemIMOShip IMO Ship Identification Number /SCMTMS/IMO_ID
Plant Plant WERKS
TranspOrdItmWhseNmbr Warehouse Number /SCMTMS/WAREHOUSE_NUMBER
Master Data Relations Join Conditions
Incoterm
  • Incoterm
  • Client
  • I_TRANSPORTATIONORDERITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_TRANSPORTATIONORDERITEM.MANDT == TINC.MANDT
Material freight group
  • Client
  • Material freight group
  • I_TRANSPORTATIONORDERITEM.MANDT == TMFG.MANDT
  • I_TRANSPORTATIONORDERITEM.MATERIALFREIGHTGROUP == TMFG.MFRGR
Base Document Type for Business Transaction
  • Client
  • Base Document Type for Business Transaction
Goods Value Currency
  • Goods Value Currency
  • Client
  • I_TRANSPORTATIONORDERITEM.TRANSPORDITEMGOODSVALUECRCY == TCURC.WAERS
  • I_TRANSPORTATIONORDERITEM.MANDT == TCURC.MANDT
Transportation Group
  • Client
  • Transportation Group
  • I_TRANSPORTATIONORDERITEM.MANDT == TTGR.MANDT
  • I_TRANSPORTATIONORDERITEM.TRANSPORTATIONGROUP == TTGR.TRAGR