C_FrtBkgExecutionQuery

Freight Booking Execution Event Query | view: CFRTBKGEXECQUERY | Extraction: Not supported | Component: Analytics
Tables used: SCAL_TT_DATE, /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORSTP, ADCP, ADRC, BUT000, T005, T005T, /SCMTMS/C_DSCTY, /SCMTMS/C_DSCTYT, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, /SAPAPO/LOCT, /SAPAPO/TRTYPE, /SAPAPO/TRTYPET, HRP1000, T77S0, T005S, T005U, /SCMTMS/C_EV_TY, /SCMTMS/C_EV_TYT, /SCMTMS/C_SHTYP, /SCMTMS/C_SHTYPT, /SCMB/HRP5561, /SCMTMS/C_TRAC, /SCMTMS/C_TRACT, TVTR, TVTRT, /SCMTMS/C_TORTY, /SCMTMS/C_TORT_T
Column Name Description
FreightBooking Freight Booking
TranspOrdExecution Transportation Order Execution ID
Column Name Description
Column Name Description
📏 Display Weight Unit of Measure (DisplayWeightUnit):
TranspOrdExecGrossWgtInDspUnit Transportation Order Execution Gross Weight in Display Unit
📏 Display Volume Unit of Measure (DisplayVolumeUnit):
TranspOrdExecGrossVolInDspUnit Transportation Order Execution Gross Volume in Display Unit
📏 Display Quantity Unit of Measure (DisplayQuantityUnit):
TranspOrdExecQuantityInDspUnit Transportation Order Execution Quantity In Display Unit
📏 Display Number of Container Unit of Measure (DisplayNmbrOfCtnsUnit):
TranspOrdExecNmbrCtnsInDspUnit Transp Order Execution Number of Containers in Display Unit
📏 Display Length Unit (DisplayLengthUnit):
TranspOrdExecLengthInDspUnit Transportation Order Execution Length in Display Unit
TranspOrdExecWidthInDspUnit Transportation Order Execution Width In Display Unit
TranspOrdExecHeightInDspUnit Transportation Order Execution Height in Display Unit
AverageTranspOrdEventDelay Average Transportation Order Event Delay
📏 Display Time Unit of Measure (DisplayTimeUnit):
TranspOrdEventDelayInDspUnit Transportation Order Event Delay in Display Unit
Column Name Description
TranspOrdEvtActualDate Transportation Order Event Actual Date
TranspOrdEvtExpdEndDate Transportation Order Event Expected End Date
Column Name Description
TranspOrdEventIsRecalled Event Has Been Recalled Show values
TranspOrdEventStatus Event Status Show values
LocationType Location Type Show values
TranspOrdIsDiscrepant Discrepancy Show values
TranspOrdIsDscrptWthoutBlk Discrepancy Type Leads to Block or Not Show values
TranspOrdHasQtyDiscrepancy Occurrence of Quantity Discrepancy Show values
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
TranspOrdPlanningStatus Planning Status Show values
TransportationOrderExecSts Execution Status Show values
TransportationModeCategory Transportation Mode Category Show values
SourceLocationType Source Location Type Show values
DestinationLocationType Destination Location Type Show values
TranspOrdEventIsOnTime Transportation Order Event Is On Time Show values
TranspOrdEventIsDelayed Transportation Order Event is Delayed Show values
TranspOrdEventIsTimeRelevant Transportation Order Event Is Time Relevant Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID (Char 32) /SCMTMS/VDM_TOR_DB_KEY_HEX
TransportationOrderEventUUID Transportation Order Event UUID /SCMTMS/VDM_TOREXE_DB_KEY
TranspOrdEventIsRecalledDesc Short Text for Fixed Values DDTEXT
TranspOrdEventCode Event Occuring for a Transportation Activity /SCMTMS/TOR_EVENT
TranspOrdEventCodeDesc Transportation Order Event Code Description /SCMTMS/DESCRIPTION_S
TranspOrdEventStatusDesc Transportation Order Event Status Description DDTEXT
TransportationActivityDesc Transportation Activity Description /SCMTMS/DESCRIPTION_S
TranspOrdEventReasonCode Event Reason Internal Code /SAPTRX/INTERNAL_CODE
TranspOrdEventReasonDesc Reason of Event Occuring for a Transportation Activity /SCMTMS/TEXT100
LocationUUID Location UUID (CHAR 22) /SAPAPO/LOCID
Location Location /SAPAPO/LOCNO
LocationName Location Description /SAPAPO/LOC_CHAR40K
LocationTypeDesc Short Text for Fixed Values DDTEXT
CountryName Country/Region Name TEXT50
RegionName Description TEXT20
CityName City TEXT40
PostalCode City postal code CHAR10
GeographicalLocationLatitude Geographical Location Latitude /SCMTMS/VDM_GEOLAT
GeographicalLocationLongitude Geographical Location Longitude /SCMTMS/VDM_GEOLON
GeographicalLocationAltitude Geographical Location Altitude /SCMTMS/VDM_GEOALT
TranspOrdEvtActualDateTime Transportation Order Event Actual Date Time TZNTSTMPS
TranspOrdEvtActualDateYear Transportation Order Event Actual Year NUM4
TranspOrdEvtActualDateYearMnth Transportation Order Event Actual Year Month NUM6
TranspOrdEvtActualDateYearQtr Transportation Order Event Actual Year Quarter NUM5
TranspOrdEvtActualDateYearWeek Transportation Order Event Actual Year Week NUM6
TranspOrdEvtExpdEndDateTime Transportation Order Event Expected End Date Time TZNTSTMPS
TranspOrdEvtActualDateTimeZone Transp Order Event Actual Time Zone TZNZONE
TranspOrdEvtEstimatedDateTime Transportation Order Event Estimated Date Time TZNTSTMPS
TranspOrdIsDiscrepantDesc Short Text for Fixed Values DDTEXT
DiscrepancyType Discrepancy Type /SCMTMS/DISCREPANCY_TYPE
DiscrepancyTypeDesc Discrepancy Type Description /SCMTMS/DESCRIPTION_S
TranspOrdIsDscrptWthoutBlkDesc Short Text for Fixed Values DDTEXT
TranspOrdIsDiscrepantWithinTol Quantity Discrepancy Is Within Tolerance
TranspOrdHasQtyDiscrepancyDesc Short Text for Fixed Values DDTEXT
ShippersLoadAndCountQuantity Shipper's Load and Count (SLAC)
TransportationOrderCatDesc Short Text for Fixed Values DDTEXT
TransportationOrderTypeDesc Transportation Order Type Description /SCMTMS/TOR_TYPE_DESC
CarrierOriginOfEntryDesc Short Text for Fixed Values DDTEXT
Carrier Carrier /SCMTMS/BU_PARTNER
CarrierName Carrier Name TEXT81
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
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
StandardSAPIconURI Std SAP Icon Uniform Resource Identifier AD_URI_BW
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
TranspOrdEventIsOnTimeDesc Short Text for Fixed Values DDTEXT
TranspOrdEventIsDelayedDesc Short Text for Fixed Values DDTEXT
TranspOrdEventIsTimeRlvtDesc Short Text for Fixed Values DDTEXT
NumberOfTranspOrdEvents Number of Transportation Order Events /SCMTMS/VDM_NUMBER_OF
NumberOfTimeRlvtTranspOrdEvts Number of Time Relevant Transportation Order Events /SCMTMS/VDM_NUMBER_OF
NumberOfOnTimeTranspOrdEvents Number of On Time Events /SCMTMS/VDM_NUMBER_OF
NumberOfDelayedTranspOrdEvents Number of Delayed Transportation Order Events /SCMTMS/VDM_NUMBER_OF
TranspOrdEventOnTimeRatio Transportation Order Event On Time Ratio (%) /SCMTMS/VDM_RATIO
NumberOfTransportationOrders Number of Freight Bookings /SCMTMS/VDM_NUMBER_OF
NumberOfTimeRlvtTranspOrds Number of Time Relevant Freight Bookings /SCMTMS/VDM_NUMBER_OF
NumberOfDelayedTranspOrds Number of Delayed Freight Bookings /SCMTMS/VDM_NUMBER_OF
NumberOfOnTimeTranspOrds Number of On Time Freight Bookings /SCMTMS/VDM_NUMBER_OF
TransportationOrderOnTimeRatio Freight Booking On Time Ratio /SCMTMS/VDM_RATIO
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONQUERY.MANDT == T005.MANDT
  • C_FRTBKGEXECUTIONQUERY.COUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONQUERY.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONQUERY.SOURCELOCATIONCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONQUERY.MANDT == T005.MANDT
  • C_FRTBKGEXECUTIONQUERY.COUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONQUERY.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONQUERY.SOURCELOCATIONCOUNTRY == T005.LAND1
Region code
  • Client
  • Region (State, Province, County)
  • Destination Location Region
  • Source Location Region
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONQUERY.MANDT == T005S.MANDT
  • C_FRTBKGEXECUTIONQUERY.REGION == T005S.BLAND
  • C_FRTBKGEXECUTIONQUERY.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONQUERY.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONQUERY.COUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONQUERY.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONQUERY.SOURCELOCATIONCOUNTRY == T005S.LAND1
Purchasing Group
  • Client
  • Purchasing Group
  • ?
  • ?
  • C_FRTBKGEXECUTIONQUERY.MANDT == PLOGI.MANDT
  • C_FRTBKGEXECUTIONQUERY.PURCHASINGGROUP == PLOGI.OBJID
  • C_FRTBKGEXECUTIONQUERY.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTBKGEXECUTIONQUERY.[column in domain "OTYPE"] == PLOGI.OTYPE
Purchasing Organization
  • Client
  • Purchasing Organization
  • ?
  • ?
  • C_FRTBKGEXECUTIONQUERY.MANDT == PLOGI.MANDT
  • C_FRTBKGEXECUTIONQUERY.PURCHASINGORGANIZATION == PLOGI.OBJID
  • C_FRTBKGEXECUTIONQUERY.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTBKGEXECUTIONQUERY.[column in domain "OTYPE"] == PLOGI.OTYPE
Region code
  • Client
  • Region (State, Province, County)
  • Destination Location Region
  • Source Location Region
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONQUERY.MANDT == T005S.MANDT
  • C_FRTBKGEXECUTIONQUERY.REGION == T005S.BLAND
  • C_FRTBKGEXECUTIONQUERY.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONQUERY.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONQUERY.COUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONQUERY.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONQUERY.SOURCELOCATIONCOUNTRY == T005S.LAND1
Country key
  • Client
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONQUERY.MANDT == T005.MANDT
  • C_FRTBKGEXECUTIONQUERY.COUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONQUERY.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONQUERY.SOURCELOCATIONCOUNTRY == T005.LAND1
Region code
  • Client
  • Region (State, Province, County)
  • Destination Location Region
  • Source Location Region
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONQUERY.MANDT == T005S.MANDT
  • C_FRTBKGEXECUTIONQUERY.REGION == T005S.BLAND
  • C_FRTBKGEXECUTIONQUERY.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONQUERY.SOURCELOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONQUERY.COUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONQUERY.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONQUERY.SOURCELOCATIONCOUNTRY == T005S.LAND1
Transportation Activity
  • Client
  • Transportation Activity
Business Document Type
  • Client
  • Business Document Type