C_FrtBkgExecutionCube

Freight Booking Execution Event Cube | view: CFRTBKGEXECCUBE | TRAN | Extraction: Not supported | Component: Analytics
Tables used: SCAL_TT_DATE, /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORSTP, ADCP, ADRC, BUT000, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, /SCMB/HRP5561, T77S0
Column Name Description
FreightBooking Freight Booking
TransportationOrderEventUUID Transportation Order Event UUID
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
📏 Transp Order Execution Dangerous Goods Exemptionpoints Unit (TranspOrdExecDngrsGdsExmppUnit):
TranspOrdExecDngrsGdsExmpp Transp Order Execution Dangerous Goods Exemptionpoints
📏 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
📏 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
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
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
TranspOrdExecution Transportation Order Execution ID /SCMTMS/ITEM_ID
TransportationOrderUUID Transportation Order UUID (Char 32) /SCMTMS/VDM_TOR_DB_KEY_HEX
TranspOrdEventCode Event Occuring for a Transportation Activity /SCMTMS/TOR_EVENT
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
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
DiscrepancyType Discrepancy Type /SCMTMS/DISCREPANCY_TYPE
TranspOrdIsDiscrepantWithinTol Quantity Discrepancy Is Within Tolerance
ShippersLoadAndCountQuantity Shipper's Load and Count (SLAC)
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
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
TransportationMode Transportation Mode VKTRA
StandardSAPIconURI Std SAP Icon Uniform Resource Identifier AD_URI_BW
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
NumberOfOnTimeTranspOrdEvents Number of On Time Events /SCMTMS/VDM_NUMBER_OF
NumberOfDelayedTranspOrdEvents Number of Delayed Transportation Order Events /SCMTMS/VDM_NUMBER_OF
NumberOfTimeRlvtTranspOrdEvts Number of Time Relevant Transportation Order Events /SCMTMS/VDM_NUMBER_OF
MaximumNumberOfEvents Maximum Number of Events /SCMTMS/VDM_NUMBER_OF
HundredInPercent Hundred In Percent DEC3
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONCUBE.MANDT == T005.MANDT
  • C_FRTBKGEXECUTIONCUBE.COUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONCUBE.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONCUBE.SOURCELOCATIONCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONCUBE.MANDT == T005.MANDT
  • C_FRTBKGEXECUTIONCUBE.COUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONCUBE.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONCUBE.SOURCELOCATIONCOUNTRY == T005.LAND1
Region code
  • Client
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • Destination Location Region
  • Region (State, Province, County)
  • Source Location Region
  • C_FRTBKGEXECUTIONCUBE.MANDT == T005S.MANDT
  • C_FRTBKGEXECUTIONCUBE.COUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONCUBE.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONCUBE.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONCUBE.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONCUBE.REGION == T005S.BLAND
  • C_FRTBKGEXECUTIONCUBE.SOURCELOCATIONREGION == T005S.BLAND
Purchasing Group
  • ?
  • ?
  • Client
  • Purchasing Group
  • C_FRTBKGEXECUTIONCUBE.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTBKGEXECUTIONCUBE.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FRTBKGEXECUTIONCUBE.MANDT == PLOGI.MANDT
  • C_FRTBKGEXECUTIONCUBE.PURCHASINGGROUP == PLOGI.OBJID
Purchasing Organization
  • ?
  • ?
  • Client
  • Purchasing Organization
  • C_FRTBKGEXECUTIONCUBE.[column in domain "PLVAR"] == PLOGI.PLVAR
  • C_FRTBKGEXECUTIONCUBE.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_FRTBKGEXECUTIONCUBE.MANDT == PLOGI.MANDT
  • C_FRTBKGEXECUTIONCUBE.PURCHASINGORGANIZATION == PLOGI.OBJID
Region code
  • Client
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • Destination Location Region
  • Region (State, Province, County)
  • Source Location Region
  • C_FRTBKGEXECUTIONCUBE.MANDT == T005S.MANDT
  • C_FRTBKGEXECUTIONCUBE.COUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONCUBE.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONCUBE.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONCUBE.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONCUBE.REGION == T005S.BLAND
  • C_FRTBKGEXECUTIONCUBE.SOURCELOCATIONREGION == T005S.BLAND
Country key
  • Client
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • C_FRTBKGEXECUTIONCUBE.MANDT == T005.MANDT
  • C_FRTBKGEXECUTIONCUBE.COUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONCUBE.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_FRTBKGEXECUTIONCUBE.SOURCELOCATIONCOUNTRY == T005.LAND1
Region code
  • Client
  • Country/Region Key
  • Destination Location Country/Region
  • Source Location Country/Region
  • Destination Location Region
  • Region (State, Province, County)
  • Source Location Region
  • C_FRTBKGEXECUTIONCUBE.MANDT == T005S.MANDT
  • C_FRTBKGEXECUTIONCUBE.COUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONCUBE.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONCUBE.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • C_FRTBKGEXECUTIONCUBE.DESTINATIONLOCATIONREGION == T005S.BLAND
  • C_FRTBKGEXECUTIONCUBE.REGION == T005S.BLAND
  • C_FRTBKGEXECUTIONCUBE.SOURCELOCATIONREGION == T005S.BLAND
Transportation Activity
  • Client
  • Transportation Activity
Business Document Type
  • Client
  • Business Document Type