C_FrtBkgExecutionStsQ

Freight Booking Execution Status Query | view: CFRTBKGEXECSTSQ | Extraction: Not supported | Component: Analytics
Tables used: SCAL_TT_DATE, /SCMTMS/D_TOREXE, /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORBLK, /SCMTMS/D_TORSTP, ADCP, ADRC, /SCMTMS/C_BLRC, /SCMTMS/C_BLRC_T, 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, T77S0, TVTR, TVTRT, /SCMTMS/C_TORTY, /SCMTMS/C_TORT_T
Column Name Description
FreightBooking Freight Booking
Column Name Description
Column Name Description
📏 Display Time Unit of Measure (DisplayTimeUnit):
TranspOrdDelayInDspUnit Transportation Order Delay 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 Number of Container Unit of Measure (DisplayNmbrOfCtnsUnit):
TranspOrdNumberOfCtnsInDspUnit Transportation Order Number of Containers In Display Unit
Column Name Description
TranspOrdLfcycStsChgDte Transportation Order Lifecycle Status Change Date
Column Name Description
TransportationOrderCategory Business Document Category Show values
DangerousGoodsAreContained Dangerous Goods Show values
TranspOrdPlanningBlock Planning Block Show values
TranspOrdPlanningBlockCat Transportation Order Planning Block Category Show values
TranspOrdExecutionIsBlocked Execution Block Show values
TranspOrdExecBlockCategory Transportation Order Execution Block Category Show values
InvoicingIsBlocked Freight Settlement Document Block Show values
CarrierOriginOfEntry Carrier Origin of Entry Show values
TranspOrdTrafficDirection Traffic Direction Show values
TranspOrdLifeCycleStatus Life Cycle Status Show values
TranspOrdPlanningStatus Planning Status Show values
TransportationOrderExecSts Execution Status Show values
SourceLocationType Source Location Type Show values
DestinationLocationType Destination Location Type Show values
TransportationModeCategory Transportation Mode Category Show values
TranspOrdIsInTransit Freight Booking In Transit Show values
TranspOrdIsDlydInTransit Delayed Freight Booking In Transit Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID (Char 32) /SCMTMS/VDM_TOR_DB_KEY_HEX
TransportationOrderCatDesc Short Text for Fixed Values DDTEXT
TransportationOrderTypeDesc Transportation Order Type Description /SCMTMS/TOR_TYPE_DESC
TranspOrdPlanningBlockDesc Transportation Order Planning Block Description DDTEXT
TranspOrdPlanningBlockRsn Reason for Planning Block /SCMTMS/BLOCK_REASON_CODE
TranspOrdPlanningBlockRsnDesc Block Reason Description /SCMTMS/DESCRIPTION_S
TranspOrdPlanningBlockCatDesc Transportation Order Block Category Description DDTEXT
TranspOrdExecutionBlockDesc Transportation Order Execution Block Description DDTEXT
TranspOrdExecBlockReason Reason for Execution Block /SCMTMS/BLOCK_REASON_CODE
TranspOrdExecBlockReasonDesc Block Reason Description /SCMTMS/DESCRIPTION_S
TranspOrdExecBlockCategoryDesc Transportation Order Block Category Description DDTEXT
InvoicingIsBlockedDesc Short Text for Fixed Values DDTEXT
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
TranspOrdPlanningStatusDesc Short Text for Fixed Values DDTEXT
TransportationOrderExecStsDesc Short Text for Fixed Values DDTEXT
TranspOrdLfcycStsChgDteTime Created on Timestamp TZNTSTMPS
TranspOrdLfcycStsChgDteYrWeek Transp Order Life Cycle Status Change Date Year Week NUMC6
TranspOrdLfcycStsChgDteYrMnth Transportation Order Lifecycle Status Change Date Year Month NUMC6
TranspOrdLfcycStsChgDteYearQtr Transportation Order Lifecycle Status Change Dte Year Qtr NUMC5
TranspOrdLfcycStsChgDteYear Transportation Order Lifecycle Status Change Date Year NUMC4
SourceLocationUUID Source Location Universally Unique Identifier (CHAR 22) /SAPAPO/LOCID
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
DestinationLocationName Location Description /SAPAPO/LOC_CHAR40K
DestinationLocationTypeDesc Short Text for Fixed Values DDTEXT
DestinationLocationCountryName Country/Region Name TEXT50
DestinationLocationRegionName Description TEXT20
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
TranspOrdIsInTransitDesc Short Text for Fixed Values DDTEXT
TranspOrdIsDlydInTransitDesc Short Text for Fixed Values DDTEXT
StandardSAPIconURI Std SAP Icon Uniform Resource Identifier AD_URI_BW
NumberOfTranspOrdsInTransit Number of Freight Bookings In Transit /SCMTMS/VDM_NUMBER_OF
NmbrOfDelayedTranspOrdsInTrnst Number of Delayed Freight Bookings In Transit /SCMTMS/VDM_NUMBER_OF
NumberOfTransportationOrders Number of Freight Bookings /SCMTMS/VDM_NUMBER_OF
NumberOfPlngBlkdTranspOrds Number of Planning Blocked Freight Bookings /SCMTMS/VDM_NUMBER_OF
NumberOfExecBlkdTranspOrds Number of Execution Blocked Freight Bookings /SCMTMS/VDM_NUMBER_OF
Master Data Relations Join Conditions
Country key
  • Client
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONSTSQ.MANDT == T005.MANDT
  • C_FRTBKGEXECUTIONSTSQ.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONSTSQ.SOURCELOCATIONCOUNTRY == T005.LAND1
Region code
  • Destination Location Region
  • Source Location Region
  • Client
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONSTSQ.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONSTSQ.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONSTSQ.MANDT == T005S.MANDT
  • C_FRTBKGEXECUTIONSTSQ.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONSTSQ.SOURCELOCATIONCOUNTRY == T005S.LAND1
Purchasing Group
  • ?
  • ?
  • Purchasing Group
  • Client
  • C_FRTBKGEXECUTIONSTSQ.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTBKGEXECUTIONSTSQ.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FRTBKGEXECUTIONSTSQ.PURCHASINGGROUP == PLOGI.OBJID
  • C_FRTBKGEXECUTIONSTSQ.MANDT == PLOGI.MANDT
Purchasing Organization
  • ?
  • ?
  • Purchasing Organization
  • Client
  • C_FRTBKGEXECUTIONSTSQ.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTBKGEXECUTIONSTSQ.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FRTBKGEXECUTIONSTSQ.PURCHASINGORGANIZATION == PLOGI.OBJID
  • C_FRTBKGEXECUTIONSTSQ.MANDT == PLOGI.MANDT
Country key
  • Client
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONSTSQ.MANDT == T005.MANDT
  • C_FRTBKGEXECUTIONSTSQ.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONSTSQ.SOURCELOCATIONCOUNTRY == T005.LAND1
Region code
  • Destination Location Region
  • Source Location Region
  • Client
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONSTSQ.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONSTSQ.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONSTSQ.MANDT == T005S.MANDT
  • C_FRTBKGEXECUTIONSTSQ.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONSTSQ.SOURCELOCATIONCOUNTRY == T005S.LAND1
Business Document Type
  • Business Document Type
  • Client