I_TranspOrdDetAnlytsForMntr

TOR Root Detail Analytics for Cloud | view: ITORROOTDANAMNTR | ATTR | Extraction: Not supported | Component: Analytics
Column Name Description
TransportationOrderItemUUID Transportation Order Item UUID
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 Quantity Unit (TranspOrdItemQuantityUnit):
TranspOrdItemQuantity Transportation Order Item Quantity
Column Name Description
TranspOrdCreationDate Transportation Order Creation Date
Column Name Description
TransportationOrderCategory Transportation Order Category Show values
TranspOrdLifeCycleStatus Transportation Order Life Cycle Status Show values
TranspOrdPlanningStatus Transportation Order Planning Status Show values
TransportationOrderExecSts Transportation Order Execution Status Show values
TransportationModeCategory Transportation Mode Category Show values
IsMainCargoItem Main Cargo Item Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID /SCMTMS/VDM_TOR_DB_KEY
TransportationOrder Transportation Order /SCMTMS/TOR_ID
NumberOfTransportationOrders Number of Transportation Orders /SCMTMS/VDM_NUMBER_OF
TranspOrdCreationDateTime Transportation Order Creation Date Time TZNTSTMPS
TranspOrdCreationYearWeek Transportation Order Creation Year Week NUM6
TranspOrdCreationYearMonth Transportation Order Creation Year Month NUM6
TranspOrdCreationYearQuarter Transportation Order Creation Year Quarter NUM5
TranspOrdCreationYear Transportation Order Creation Year NUM4
Carrier Carrier /SCMTMS/BU_PARTNER
CarrierUUID Carrier UUID /SCMTMS/VDM_DB_KEY
Shipper Shipper BU_PARTNER
ShipperUUID Shipper Universally Unique Identifier /SCMTMS/VDM_DB_KEY
Consignee Ship-to Party BU_PARTNER
ConsigneeUUID Ship-to Party UUID /SCMTMS/VDM_BUPAUUID
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
TranspOrdResponsiblePerson Transportation Order Responsible Person UNAME
TransportationMode Transportation Mode VKTRA
TranspOrdItem Freight Order Item /SCMTMS/ITEM_ID
TranspOrdItemType Transportation Order Item Type /SCMTMS/TOR_ITEM_TYPE
TranspOrdItemSrceLocation Transportation Order Item Source Location /SAPAPO/LOCNO
TranspOrdItemDestLocation Transportation Order Item Destination Location /SAPAPO/LOCNO
ProductID Product MATNR
ProductName Product Description TEXT40
Master Data Relations Join Conditions
Goods Value Currency
  • Goods Value Currency
  • Client
  • I_TRANSPORDDETANLYTSFORMNTR.TRANSPORDITEMGOODSVALUECRCY == TCURC.WAERS
  • I_TRANSPORDDETANLYTSFORMNTR.MANDT == TCURC.MANDT
Transportation Order Type
  • Client
  • Transportation Order Type