I_TranspOrdItemAnalytics

Transportation Order Item Analytics | view: ITRANSPORDITMANA | ATTR | Extraction: Full or Incremental | Component: Analytics
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 Transportation Order Item Goods Value
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
📏 Transportation Order Item Length Unit (TranspOrdItemLengthUnit):
TranspOrdItemLength Transportation Order Item Length
TranspOrdItemWidth Transportation Order Item Width
TranspOrdItemHeight Transportation Order Item Height
Column Name Description
Column Name Description
TranspOrdItemCategory Transportation Order Item Category Show values
TransportationModeCategory Transportation Mode Category Show values
TranspOrdItemIsDangerousGood Transportation Order Item is Dangerous Good Show values
MultiItem Multiple Item Show values
CargoIsHighValue High-Value Cargo Show values
IsMainCargoItem Main Cargo Item Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID /SCMTMS/VDM_TOR_DB_KEY
TranspOrdItemParentItemUUID Key of Transportation Order Item
SourceStopUUID Transportation Order Item Source Stop UUID /BOBF/CONF_KEY
DestinationStopUUID Transportation Order Item Destination Stop UUID /BOBF/CONF_KEY
TranspOrdItem Transportation Order Item /SCMTMS/ITEM_ID
TranspOrdItemDesc Transportation Order Item Description /SCMTMS/ITEM_DESCRIPTION
TranspOrdItemType Transportation Order Item Type /SCMTMS/TOR_ITEM_TYPE
Shipper Shipper BU_PARTNER
Consignee Ship-to Party BU_PARTNER
TransportationMode Transportation Mode VKTRA
PredecessorTransportationOrder NodeID /BOBF/CONF_KEY
TranspOrdDocReferenceItmType Base Document Item Type Code for Business Transaction /SCMTMS/BTD_ITEM_TYPECODE
TranspOrdDocReferenceID Base Business Transaction Document /SCMTMS/BTD_ID
TranspOrdDocReferenceItmID Base Document Item for Business Transaction /SCMTMS/BTD_ITEM_ID
ProductID Product MATNR
ProductName Product Description TEXT40
TransportationGroupName Transportation Group Name TEXT20
MeansOfTransport Transportation Order Means of Transport /SCMTMS/TRANSMEANSTYPECODE
TranspOrdItemSorting Transportation Order Item Sorting /SCMTMS/VDM_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 Transportation Order Item Voyage /SCMTMS/VOYAGE_ID
TranspOrdItemFlight Transportation Order Item Flight /SCMTMS/FLIGHT_CODE
TranspOrdItemVessel Transportation Order Item Vessel /SCMTMS/VESSEL_ID
TranspOrdItemIMOShip Transportation Order Item IMO Ship /SCMTMS/IMO_ID
Plant Plant WERKS
Master Data Relations Join Conditions
Incoterm
  • Incoterm
  • Client
  • I_TRANSPORDITEMANALYTICS.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_TRANSPORDITEMANALYTICS.MANDT == TINC.MANDT
Base Document Type for Business Transaction
  • Base Document Type for Business Transaction
  • Client
Goods Value Currency
  • Goods Value Currency
  • Client
  • I_TRANSPORDITEMANALYTICS.TRANSPORDITEMGOODSVALUECRCY == TCURC.WAERS
  • I_TRANSPORDITEMANALYTICS.MANDT == TCURC.MANDT
Transportation Group
  • Client
  • Transportation Group
  • I_TRANSPORDITEMANALYTICS.MANDT == TTGR.MANDT
  • I_TRANSPORDITEMANALYTICS.TRANSPORTATIONGROUP == TTGR.TRAGR