C_FrtOrdQuantityQuery

Freight Order Quantity Query | view: CFRTORDQUANTITYQ | Extraction: Not supported | Component: Analytics
Tables used: SCAL_TT_DATE, /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORSTS, /SCMTMS/D_TORSTP, ADCP, ADRC, BUT000, T005, T005T, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, /SAPAPO/LOCT, /SAPAPO/TRTYPE, /SAPAPO/TRTYPET, HRP1000, T77S0, T005S, T005U, /SCMTMS/C_SHTYP, /SCMTMS/C_SHTYPT, /SCMB/HRP5561, TVTR, TVTRT, /SCMTMS/C_TORTY, /SCMTMS/C_TORT_T
Column Name Description
FreightOrder Freight Order
TransportationOrderStage Successor
Column Name Description
Column Name Description
📏 Display Number of Container Unit of Measure (DisplayNmbrOfCtnsUnit):
TranspOrdNumberOfCtnsInDspUnit Transportation Order Number of Containers In Display Unit
📏 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 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
TranspOrdTrafficDirection Traffic Direction Show values
TranspOrdLifeCycleStatus Life Cycle Status Show values
TransportationModeCategory Transportation Mode Category Show values
SourceLocationType Source Location Type Show values
DestinationLocationType Destination Location Type 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
NumberOfTransportationOrders Number of Freight Orders /SCMTMS/VDM_NUMBER_OF
TransportationOrderCatDesc Short Text for Fixed Values DDTEXT
TransportationOrderTypeDesc Transportation Order Type Description /SCMTMS/TOR_TYPE_DESC
Carrier Carrier /SCMTMS/BU_PARTNER
CarrierName Carrier Name TEXT81
CarrierOriginOfEntryDesc Short Text for Fixed Values DDTEXT
Shipper Shipper BU_PARTNER
ShipperName Shipper Name TEXT81
Consignee Ship-to Party BU_PARTNER
ConsigneeName Ship-To Party Name TEXT81
TranspOrdShippingType Shipping Type /SCMTMS/SHIPPING_TYPE
TranspOrdShippingTypeDesc Description /SCMTMS/DESCRIPTION_S
TranspOrdTrafficDirectionDesc Short Text for Fixed Values DDTEXT
PlngAndExecOrganization Planning and Execution Organization HROBJID
PlngAndExecOrganizationName Object Name TEXT40
PlngAndExecGroup Planning and Execution Group HROBJID
PlngAndExecGroupName Object Name TEXT40
PurchasingOrganizationName Object Name TEXT40
PurchasingGroupName Object Name TEXT40
TranspOrdLifeCycleStatusDesc Short Text for Fixed Values DDTEXT
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
MeansOfTransportDesc Means of Transport Description /SAPAPO/TR_TRATYDESCR
TransportationMode Transportation Mode VKTRA
TransportationModeDesc Transportation Mode Description
TransportationModeCategoryDesc Transportation Mode Category Description DDTEXT
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
ChangedDateTime Created on Timestamp TZNTSTMPS
SourceLocationUUID Source Location Universally Unique Identifier (CHAR 22) /SAPAPO/LOCID
SourceLocation Transportation Order Source Location /SAPAPO/LOCNO
SourceLocationName Location Description /SAPAPO/LOC_CHAR40K
SourceLocationTypeDesc Short Text for Fixed Values DDTEXT
SourceLocationCountryName Country/Region Name TEXT50
SourceLocationRegionName Description TEXT20
DestinationLocationUUID Destination Location UUID (CHAR 22) /SAPAPO/LOCID
DestinationLocation Transportation Order Destination Location /SAPAPO/LOCNO
DestinationLocationName Location Description /SAPAPO/LOC_CHAR40K
DestinationLocationTypeDesc Short Text for Fixed Values DDTEXT
DestinationLocationCountryName Country/Region Name TEXT50
DestinationLocationRegionName Description TEXT20
SumTranspOrdMaxUtilznRatio Sum of Transportation Order Maximum Utilization Ratio /SCMTMS/VDM_UTILIZATION
SumTranspOrdMaxUtilznRatioMass Sum of Transportation Order Maximum Mass Utilization Ratios /SCMTMS/VDM_UTILIZATION
SumTranspOrdMaxUtilznRatioVol Sum of Transp Order Maximum Utilization Ratios Volume /SCMTMS/VDM_UTILIZATION
TranspOrdMaxUtilznRatio Maximum Utilization
TranspOrdMaxUtilznMassRatio Transportation Order Max Utilization Mass Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdMaxUtilznVolumeRatio Transportation Order Max Utilization Volume Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdStageSrceLocation Transportation Order Stage Source Location /SAPAPO/LOCNO
TranspOrdStageSrceLocationName Location Description /SAPAPO/LOC_CHAR40K
TranspOrdStageSrceLocTypeDesc Short Text for Fixed Values DDTEXT
TranspOrdStageSrceLocCntryName Country/Region Name TEXT50
TranspOrdStageSrceLocRgnName Description TEXT20
TranspOrdStageDestLocation Transportation Order Stage Destination Location /SAPAPO/LOCNO
TranspOrdStageDestLocationName Location Description /SAPAPO/LOC_CHAR40K
TranspOrdStageDestLocTypeDesc Short Text for Fixed Values DDTEXT
TranspOrdStageDestLocCntryName Country/Region Name TEXT50
TranspOrdStageDestLocRgnName Description TEXT20
NumberOfTranspOrdStages Number of Transportation Order Stages /SCMTMS/VDM_NUMBER_OF
TranspOrdStageMaxUtilznRatio Transportation Order Stage Maximum Utilization Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdStageUtilznVolRatio Transportation Order Stage Utilization Volume Ratio /SCMTMS/VDM_UTILIZATION
TranspOrdStageUtilznMassRatio Transportation Order Stage Utilization Mass Ratio /SCMTMS/VDM_UTILIZATION
Master Data Relations Join Conditions
Country key
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • Client
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.MANDT == T005.MANDT
Region code
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • Transportation Order Stage Destination Region
  • Destination Location Region
  • Source Location Region
  • Transportation Order Stage Source Location Region
  • Client
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.MANDT == T005S.MANDT
Purchasing Group
  • ?
  • ?
  • Client
  • Purchasing Group
  • C_FRTORDQUANTITYQUERY.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTORDQUANTITYQUERY.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FRTORDQUANTITYQUERY.MANDT == PLOGI.MANDT
  • C_FRTORDQUANTITYQUERY.PURCHASINGGROUP == PLOGI.OBJID
Purchasing Organization
  • ?
  • ?
  • Client
  • Purchasing Organization
  • C_FRTORDQUANTITYQUERY.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTORDQUANTITYQUERY.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FRTORDQUANTITYQUERY.MANDT == PLOGI.MANDT
  • C_FRTORDQUANTITYQUERY.PURCHASINGORGANIZATION == PLOGI.OBJID
Country key
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • Client
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.MANDT == T005.MANDT
Region code
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • Transportation Order Stage Destination Region
  • Destination Location Region
  • Source Location Region
  • Transportation Order Stage Source Location Region
  • Client
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.MANDT == T005S.MANDT
Country key
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • Client
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.MANDT == T005.MANDT
Region code
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • Transportation Order Stage Destination Region
  • Destination Location Region
  • Source Location Region
  • Transportation Order Stage Source Location Region
  • Client
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.MANDT == T005S.MANDT
Country key
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • Client
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCCNTRY == T005.LAND1
  • C_FRTORDQUANTITYQUERY.MANDT == T005.MANDT
Region code
  • Transportation Order Stage Destination Location Ctry/Reg.
  • Destination Location Country/Region
  • Source Location Country/Region
  • Transportation Order Stage Source Country/Region
  • Transportation Order Stage Destination Region
  • Destination Location Region
  • Source Location Region
  • Transportation Order Stage Source Location Region
  • Client
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCCNTRY == T005S.LAND1
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGEDESTLOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.TRANSPORDSTAGESRCELOCRGN == T005S.BLAND
  • C_FRTORDQUANTITYQUERY.MANDT == T005S.MANDT
Business Document Type
  • Client
  • Business Document Type