C_FrtOrdExecutionStsQ

Freight Order Execution Status Query | view: CFRTORDEXECSTSQ | Extraction: Not supported | Component: Analytics

🔑 Keys (1)
💰 Amounts
∑ Quantities (5)
📅 Dates (1)
☰ Categorical (16)
Other (56)
🔗 Relations (7)

Column Name	Description
FreightOrder	Freight Order

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
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 Order In Transit	Show values
TranspOrdIsDlydInTransit	Delayed Freight Order 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	null
Shipper	Shipper	BU_PARTNER
Consignee	Ship-to Party	BU_PARTNER
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 Orders In Transit	/SCMTMS/VDM_NUMBER_OF
NmbrOfDelayedTranspOrdsInTrnst	Number of Delayed Freight Orders In Transit	/SCMTMS/VDM_NUMBER_OF
NumberOfTransportationOrders	Number of Freight Orders	/SCMTMS/VDM_NUMBER_OF
NumberOfPlngBlkdTranspOrds	Number of Planning Blocked Freight Orders	/SCMTMS/VDM_NUMBER_OF
NumberOfExecBlkdTranspOrds	Number of Execution Blocked Freight Orders	/SCMTMS/VDM_NUMBER_OF

Master Data Relations	Join Conditions
Country key Destination Location Country/Region Source Location Country/Region Client	`C_FRTORDEXECUTIONSTSQ.DESTINATIONLOCATIONCOUNTRY == T005.LAND1` `C_FRTORDEXECUTIONSTSQ.SOURCELOCATIONCOUNTRY == T005.LAND1` `C_FRTORDEXECUTIONSTSQ.MANDT == T005.MANDT`
Region code Destination Location Country/Region Source Location Country/Region Client Destination Location Region Source Location Region	`C_FRTORDEXECUTIONSTSQ.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1` `C_FRTORDEXECUTIONSTSQ.SOURCELOCATIONCOUNTRY == T005S.LAND1` `C_FRTORDEXECUTIONSTSQ.MANDT == T005S.MANDT` `C_FRTORDEXECUTIONSTSQ.DESTINATIONLOCATIONREGION == T005S.BLAND` `C_FRTORDEXECUTIONSTSQ.SOURCELOCATIONREGION == T005S.BLAND`
Purchasing Group ? ? Client Purchasing Group	`C_FRTORDEXECUTIONSTSQ.[column in domain "PLVAR"] == PLOGI.PLVAR` `C_FRTORDEXECUTIONSTSQ.[column in domain "OTYPE"] == PLOGI.OTYPE` `C_FRTORDEXECUTIONSTSQ.MANDT == PLOGI.MANDT` `C_FRTORDEXECUTIONSTSQ.PURCHASINGGROUP == PLOGI.OBJID`
Purchasing Organization Purchasing Organization ? ? Client	`C_FRTORDEXECUTIONSTSQ.PURCHASINGORGANIZATION == PLOGI.OBJID` `C_FRTORDEXECUTIONSTSQ.[column in domain "PLVAR"] == PLOGI.PLVAR` `C_FRTORDEXECUTIONSTSQ.[column in domain "OTYPE"] == PLOGI.OTYPE` `C_FRTORDEXECUTIONSTSQ.MANDT == PLOGI.MANDT`
Country key Destination Location Country/Region Source Location Country/Region Client	`C_FRTORDEXECUTIONSTSQ.DESTINATIONLOCATIONCOUNTRY == T005.LAND1` `C_FRTORDEXECUTIONSTSQ.SOURCELOCATIONCOUNTRY == T005.LAND1` `C_FRTORDEXECUTIONSTSQ.MANDT == T005.MANDT`
Region code Destination Location Country/Region Source Location Country/Region Client Destination Location Region Source Location Region	`C_FRTORDEXECUTIONSTSQ.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1` `C_FRTORDEXECUTIONSTSQ.SOURCELOCATIONCOUNTRY == T005S.LAND1` `C_FRTORDEXECUTIONSTSQ.MANDT == T005S.MANDT` `C_FRTORDEXECUTIONSTSQ.DESTINATIONLOCATIONREGION == T005S.BLAND` `C_FRTORDEXECUTIONSTSQ.SOURCELOCATIONREGION == T005S.BLAND`
Business Document Type Business Document Type Client	`C_FRTORDEXECUTIONSTSQ.TRANSPORTATIONORDERTYPE == /SCMTMS/C_TORTY.TYPE` `C_FRTORDEXECUTIONSTSQ.MANDT == /SCMTMS/C_TORTY.MANDT`