C_TranspOrdItemAnlytsDEX

Data Extraction for Transp Order Anlyts Root and Item | view: CTRANSPORDITMDEX | TRAN | Extraction: Full or Incremental | Component: Analytics
Tables used: /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORITE, /SCMTMS/D_TORSTP, MARA, BUT000, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, TMFG, TMFGT, MARA, MAKT, /SCMB/HRP5561, T77S0, TTGR, TTGRT, /SCMTMS/C_TORTY
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
📏 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
📏 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
📏 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
TranspOrdCreationDate Transportation Order Creation Date
Column Name Description
TranspOrdItemSrceLocationType Transportation Order Item Source Location Type Show values
TranspOrdItemDestLocationType Transportation Order Item Destination Location Type Show values
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
TransportationRequestCategory Category (Forwarding Order/Quotation or Trsp. Reqt) Show values
TransportationModeCategory Transportation Mode Category Show values
TranspOrdItemCategory Transportation Order Item 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
TranspOrdTypeIsBusWrhsRlvt Transportation Order Type is Business Warehouse Relevant 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
TranspOrdItemSrceLocation Transportation Order Item Source Location /SAPAPO/LOCNO
DestinationStopUUID Transportation Order Item Destination Stop UUID /BOBF/CONF_KEY
TranspOrdItemDestLocation Transportation Order Item Destination Location /SAPAPO/LOCNO
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
TranspOrdMeansOfTransport 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
TranspOrdItem Transportation Order Item /SCMTMS/ITEM_ID
TranspOrdItemDesc Transportation Order Item Description /SCMTMS/ITEM_DESCRIPTION
TranspOrdItemType Transportation Order Item Type /SCMTMS/TOR_ITEM_TYPE
TranspOrdItemShipper Transportation Order Item Shipper BU_PARTNER
TranspOrdItemConsignee Transportation Order Item Ship-to Party BU_PARTNER
TranspOrdItemTranspMode Transportation Order Item Transportation Mode
TranspOrdItemTranspModeCat Transportation Order Item Transportation Mode Category
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
TranspOrdItemMeansOfTransport Transportation Order Item Means of Transport /SCMTMS/TRANSMEANSTYPECODE
TranspOrdItemSorting Transportation Order Item Sorting /SCMTMS/VDM_TOR_ITEM_SORT_ID
TranspOrdItemShipperUUID Transportation Order Item Shipper UUID /SCMTMS/VDM_DB_KEY
TranspOrdItemConsigneeAddrID Transportation Order Item Consignee Address ID
TranspOrdItemConsigneeUUID Transportation Order Item Ship-to Party UUID /SCMTMS/VDM_DB_KEY
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
Base Document Type for Business Transaction
  • Client
  • Base Document Type for Business Transaction
  • Base Document Type for Business Transaction
Incoterm
  • Incoterm
  • Client
  • C_TRANSPORDITEMANLYTSDEX.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_TRANSPORDITEMANLYTSDEX.MANDT == TINC.MANDT
Base Document Type for Business Transaction
  • Client
  • Base Document Type for Business Transaction
  • Base Document Type for Business Transaction
Goods Value Currency
  • Goods Value Currency
  • Client
  • C_TRANSPORDITEMANLYTSDEX.TRANSPORDITEMGOODSVALUECRCY == TCURC.WAERS
  • C_TRANSPORDITEMANLYTSDEX.MANDT == TCURC.MANDT
Transportation Group
  • Transportation Group
  • Client
  • C_TRANSPORDITEMANLYTSDEX.TRANSPORTATIONGROUP == TTGR.TRAGR
  • C_TRANSPORDITEMANLYTSDEX.MANDT == TTGR.MANDT
Transportation Order Type
  • Transportation Order Type
  • Client