C_FrtOrdQuantityCube

Freight Order Quantity Cube | view: CFRTORDQUANTITYC | TRAN | Extraction: Not supported | Component: Analytics
Column Name Description
FreightOrder Freight Order
TransportationOrderStage Successor
Column Name Description
Column Name Description
📏 Display Weight Unit of Measure (DisplayWeightUnit):
TranspOrdGrossWeightInDspUnit Transportation Order Gross Weight In Display Unit
📏 Display Volume Unit of Measure (DisplayVolumeUnit):
TranspOrdGrossVolumeInDspUnit Transportation Order Gross Volume in Display Unit
📏 Display Quantity Unit of Measure (DisplayQuantityUnit):
TranspOrdQuantityInDisplayUnit Transportation Order Quantity In Display Unit
📏 Display Number of Container Unit of Measure (DisplayNmbrOfCtnsUnit):
TranspOrdNumberOfCtnsInDspUnit Transportation Order Number of Containers In Display Unit
📏 Display Length Unit (DisplayLengthUnit):
TranspOrdStageDstncInDspUnit Transportation Order Stage Distance In Display Unit
📏 Display Time Unit of Measure (DisplayTimeUnit):
TranspOrdStageNetDurnInDspUnit Transportation Order Net Duration in Display Unit
Column Name Description
TranspOrdCompletionDate Transportation Order Completion Date
Column Name Description
TransportationOrderCategory Business Document Category Show values
DangerousGoodsAreContained Dangerous Goods Show values
CarrierOriginOfEntry Carrier Origin of Entry Show values
CarrierBusPurposeIsCompleted Carrier Business Purpose is Completed Show values
ShipperBusPurposeIsCompleted Shipper Business Purpose Is Completed Show values
ConsigneeBusPurposeIsCompleted Ship-To Party Business Purpose is Completed Show values
TranspOrdTrafficDirection Traffic Direction Show values
TranspOrdLifeCycleStatus Life Cycle Status Show values
SourceLocationType Source Location Type Show values
DestinationLocationType Destination Location Type Show values
TransportationModeCategory Transportation Mode Category Show values
TranspOrdStageSrceLocationType Transportation Order Stage Source Location Type Show values
TranspOrdStageDestLocationType Transportation Order Stage Destination Location Type Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID (Char 32) /SCMTMS/VDM_TOR_DB_KEY_HEX
TranspOrdResponsiblePerson Person Responsible UNAME
Carrier Carrier /SCMTMS/BU_PARTNER
Shipper Shipper BU_PARTNER
Consignee Ship-to Party BU_PARTNER
TranspOrdShippingType Shipping Type /SCMTMS/SHIPPING_TYPE
PlngAndExecOrganization Planning and Execution Organization HROBJID
PlngAndExecGroup Planning and Execution Group HROBJID
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
TranspOrdCompletionDateTime Transportation Order Completion Date Time TZNTSTMPS
TranspOrdCompletionYearWeek Transportation Order Completion Year Week NUM6
TranspOrdCompletionYearMonth Transportation Order Completion Year Month NUM6
TranspOrdCompletionYearQuarter Transportation Order Completion Year Quarter NUM5
TranspOrdCompletionYear Transportation Order Completion Year NUM4
SourceLocationUUID Source Location Universally Unique Identifier (CHAR 22) /SAPAPO/LOCID
SourceLocation Transportation Order Source Location /SAPAPO/LOCNO
DestinationLocationUUID Destination Location UUID (CHAR 22) /SAPAPO/LOCID
DestinationLocation Transportation Order Destination Location /SAPAPO/LOCNO
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
ChangedDateTime Created on Timestamp TZNTSTMPS
NumberOfTranspOrdStages Number of Transportation Order Stages /SCMTMS/VDM_NUMBER_OF
TranspOrdStageSrceLocationUUID Transportation Order Stage Source Location UUID (CHAR 22) /SAPAPO/LOCID
TranspOrdStageSrceLocation Transportation Order Stage Source Location /SAPAPO/LOCNO
TranspOrdStageDestLocationUUID Transp Order Stage Dest Location UUID (CHAR 22) /SAPAPO/LOCID
TranspOrdStageDestLocation Transportation Order Stage Destination Location /SAPAPO/LOCNO
TranspOrdStageMaxUtilznRatio Transportation Order Stage Maximum Utilization Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdStageUtilznVolRatio Transportation Order Stage Utilization Volume Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdStageUtilznQtyRatio Transp Order Stage Utilization Quantity Ratio (No Dim) /SCMTMS/VDM_UTILIZATION
TranspOrdStageUtilznLenRatio Transportation Order Stage Utilization Length Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdStageUtilznMassRatio Transportation Order Stage Utilization Mass Ratio /SCMTMS/VDM_UTILIZATION
Master Data Relations Join Conditions
Country key
  • Client
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • C_FRTORDQUANTITYCUBE.MANDT == T005.MANDT
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCCNTRY == T005.LAND1
Region code
  • Destination Location Region
  • Source Location Region
  • Transportation Order Stage Destination Region
  • Transportation Order Stage Source Location Region
  • Client
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.MANDT == T005S.MANDT
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCCNTRY == T005S.LAND1
Purchasing Group
  • Purchasing Group
  • ?
  • ?
  • Client
  • C_FRTORDQUANTITYCUBE.PURCHASINGGROUP == PLOGI.OBJID
  • C_FRTORDQUANTITYCUBE.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTORDQUANTITYCUBE.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FRTORDQUANTITYCUBE.MANDT == PLOGI.MANDT
Purchasing Organization
  • Purchasing Organization
  • ?
  • ?
  • Client
  • C_FRTORDQUANTITYCUBE.PURCHASINGORGANIZATION == PLOGI.OBJID
  • C_FRTORDQUANTITYCUBE.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTORDQUANTITYCUBE.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FRTORDQUANTITYCUBE.MANDT == PLOGI.MANDT
Country key
  • Client
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • C_FRTORDQUANTITYCUBE.MANDT == T005.MANDT
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCCNTRY == T005.LAND1
Region code
  • Destination Location Region
  • Source Location Region
  • Transportation Order Stage Destination Region
  • Transportation Order Stage Source Location Region
  • Client
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.MANDT == T005S.MANDT
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCCNTRY == T005S.LAND1
Country key
  • Client
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • C_FRTORDQUANTITYCUBE.MANDT == T005.MANDT
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCCNTRY == T005.LAND1
Region code
  • Destination Location Region
  • Source Location Region
  • Transportation Order Stage Destination Region
  • Transportation Order Stage Source Location Region
  • Client
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.MANDT == T005S.MANDT
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCCNTRY == T005S.LAND1
Country key
  • Client
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • C_FRTORDQUANTITYCUBE.MANDT == T005.MANDT
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCCNTRY == T005.LAND1
Region code
  • Destination Location Region
  • Source Location Region
  • Transportation Order Stage Destination Region
  • Transportation Order Stage Source Location Region
  • Client
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYCUBE.MANDT == T005S.MANDT
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGEDESTLOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYCUBE.TRANSPORDSTAGESRCELOCCNTRY == T005S.LAND1
Business Document Type
  • Business Document Type
  • Client