- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_FrtOrdExecutionStsQ
Freight Order Execution Status Query
| view: CFRTORDEXECSTSQ
| Extraction:
Not supported
| Component: Analytics
Tables used:
SCAL_TT_DATE, /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, TVTR, TVTRT, /SCMTMS/C_TORTY, /SCMTMS/C_TORT_T
| 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
| |
Region code
| |
Purchasing Group
| |
Purchasing Organization
| |
Country key
| |
Region code
| |
Business Document Type
|
|