I_TranspOrdStageAnalytics
Transportation Order Stage Analytics
I_TranspOrdStageAnalytics (Composite)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.
TransportationOrderStage · Supply Chain
I_TranspOrdStageAnalytics is a Composite CDS View (Dimension) that provides data about "Transportation Order Stage Analytics" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrderStage) and exposes 45 fields with key field TransportationOrderStageUUID. It has 4 associations to related views.
SAP Help Documentation
| Category | Business Performance Analytics |
|---|---|
| Data Category | Dimension |
| Status | Released |
Purpose
This CDS view is a composite view to retrieve stage information for analytical purposes for transportation orders, for example, for freight orders. You can use this CDS view to build your own consumption view on top. This CDS view contains key performance indicators (KPIs) to enable you to analyze and monitor your business on stage level. It contains references to source and destination stops and different stage attributes. The CDS view serves as an extractor for BW and can be used as a data source for further analytical objects like cubes and queries. This CDS view provides the data to answer the following business questions: Which stages are involved in my transports? Which stops are involved in my stages? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations Authorization is based on standard Transportation Management authorization objects. You will need either the Transp. Management Administrative Settings authorization object ( T_ADMIN ), or both the Transp. Management Order Management & Planning (Purchase) authorization object ( T_TOR_PUR ) and the Transp. Management Order Management & Planning (Execution) authorization object ( T_TOR_EXE ). The following table lists the authorization objects with required fields and values: Authorization Object Field Value Description T_ADMIN Transp. Management: Administrative Settings authorization object ACTVT H1 (Deactivate) Activity T_TOR_PUR Transp. Management: Order Management & Planning (Purchase) authorization object TM_OC TransportationOrderCategory TM_OT TransportationOrderType TM_XPORG PurchasingOrgExternalID TM_XPGRP PurchasingGroupExternalID TM_RP TranspOrdResponsiblePerson TM_MOT TransportationMode ACTVT 03 (Display) Activity T_TOR_EXE Transp. Management: Order Management & Planning (Execution) authorization object TM_OC TransportationOrderCategory TM_OT TransportationOrderType TM_XEORG PlngAndExecOrgExternalID TM_XEGRP PlngAndExecGroupExternalID TM_RP TranspOrdResponsiblePerson TM_MOT TransportationMode ACTVT 03 (Display) Activity
Structure
Important fields in this view include the following: Key TransportationOrderStageUUID UUIDs for references to Transportation Order Analytics and Transportation Order Stop Analytics CDS views TransportationOrderUUID TranspOrdStageSrceStopUUID TranspOrdStageDestStopUUID Transportation Order Stage detail information TransportationOrderStage TransportationMode TransportationModeCategory TranspOrdStagePlnStatus Transportation Order Stage measures TranspOrdStageDistance Depending on your configuration, some of the fields included in this CDS view may not expose any data.
Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Delta (change data capture)
Constraints
This analytical composite view shall be interpreted and executed by the analytical infrastructure only. It is not intended to be used outside of this context. For example, it shall not be used in ABAP code for selecting data from it.
This CDS view is a composite view to retrieve stage information for analytical purposes for transportation orders, for example, for freight orders. You can use this CDS view to build your own consumption view on top. This CDS view contains key performance indicators (KPIs) to enable you to analyze and monitor your business on stage level. It contains references to source and destination stops and different stage attributes. The CDS view serves as an extractor for BW and can be used as a data source for further analytical objects like cubes and queries. This CDS view provides the data to answer the following business questions: Which stages are involved in my transports? Which stops are involved in my stages? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations Authorization is based on standard Transportation Management authorization objects. You will need either the Transp. Management Administrative Settings authorization object ( T_ADMIN ), or both the Transp. Management Order Management & Planning (Purchase) authorization object ( T_TOR_PUR ) and the Transp. Management Order Management & Planning (Execution) authorization object ( T_TOR_EXE ). The following table lists the authorization objects with required fields and values: Authorization Object Field Value Description T_ADMIN Transp. Management: Administrative Settings authorization object ACTVT H1 (Deactivate) Activity T_TOR_PUR Transp. Management: Order Management & Planning (Purchase) authorization object TM_OC TransportationOrderCategory TM_OT TransportationOrderType TM_XPORG PurchasingOrgExternalID TM_XPGRP PurchasingGroupExternalID TM_RP TranspOrdResponsiblePerson TM_MOT TransportationMode ACTVT 03 (Display) Activity T_TOR_EXE Transp. Management: Order Management & Planning (Execution) authorization object TM_OC TransportationOrderCategory TM_OT TransportationOrderType TM_XEORG PlngAndExecOrgExternalID TM_XEGRP PlngAndExecGroupExternalID TM_RP TranspOrdResponsiblePerson TM_MOT TransportationMode ACTVT 03 (Display) Activity
Structure
Important fields in this view include the following: Key TransportationOrderStageUUID UUIDs for references to Transportation Order Analytics and Transportation Order Stop Analytics CDS views TransportationOrderUUID TranspOrdStageSrceStopUUID TranspOrdStageDestStopUUID Transportation Order Stage detail information TransportationOrderStage TransportationMode TransportationModeCategory TranspOrdStagePlnStatus Transportation Order Stage measures TranspOrdStageDistance Depending on your configuration, some of the fields included in this CDS view may not expose any data.
Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Delta (change data capture)
Constraints
This analytical composite view shall be interpreted and executed by the analytical infrastructure only. It is not intended to be used outside of this context. For example, it shall not be used in ABAP code for selecting data from it.
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Supply Chain |
| Application Component | TM-CF-ANA |
| Capabilities | Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction |
| Package | Supply Chain for SAP S/4HANA Cloud Private Edition |
| Description | <p>This CDS view is a composite view to retrieve stage information for analytical purposes for transportation orders, for example, for freight orders.</p> <p>You can use this CDS view to build your own consumption view on top.</p> <p>This CDS view contains key performance indicators (KPIs) to enable you to analyze and monitor your business on stage level. It contains references to source and destination stops and different stage attributes. </p> <p>The CDS view serves as an extractor for BW and can be used as a data source for further analytical objects like cubes and queries.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Which stages are involved in my transports?</p></li> <li><p>Which stops are involved in my stages?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_TransportationOrderStage | I_TransportationOrderStage | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_TransportationOrderAnalytics | _TransportationOrderAnalytics | $projection.TransportationOrderUUID = _TransportationOrderAnalytics.TransportationOrderUUID |
| [1..1] | I_TranspOrdStopAnalytics | _TranspOrdStageSrceStopAnlyts | $projection.TranspOrdStageSrceStopUUID = _TranspOrdStageSrceStopAnlyts.TransportationOrderStopUUID |
| [1..1] | I_TranspOrdStopAnalytics | _TranspOrdStageDestStopAnlyts | $projection.TranspOrdStageDestStopUUID = _TranspOrdStageDestStopAnlyts.TransportationOrderStopUUID |
| [1..1] | I_UnitOfMeasure | _TranspOrdStageDistanceUnit | $projection.TranspOrdStageDistanceUnit = _TranspOrdStageDistanceUnit.UnitOfMeasure |
Annotations (19)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Transportation Order Stage Analytics | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AbapCatalog.sqlViewName | ITRANSPORDSTGANA | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.representativeKey | TransportationOrderStageUUID | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.modelingPattern | #NONE | view | |
| ObjectModel.sapObjectNodeType.name | TransportationOrderStage | view | |
| VDM.viewType | #COMPOSITE | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.dataExtraction.enabled | true | view | |
| Analytics.internalName | #LOCAL | view |
Fields (45)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | TransportationOrderStageUUID | Transportation Order Stage UUID | ||
| TransportationOrderUUID | TransportationOrderUUID | Transportation Order UUID | ||
| TranspOrdStageSrceStopUUID | Transportation Order Stage Source Stop UUID | |||
| TranspOrdStageDestStopUUID | Transportation Order Stage Destination Stop UUID | |||
| CarrierUUID | Carrier UUID | |||
| TransportationOrderStage | Transportation Order Stage | |||
| TranspOrdStageDestStopCategory | Transportation Order Stage Destination Stop Category | |||
| TranspOrdStageType | Transportation Order Stage Type | |||
| TranspOrdStageCategory | Transportation Order Stage Category | |||
| TranspOrdStagePlnStatus | Transportation Order Stage Plan Status | |||
| MeansOfTransport | Transportation Order Means of Transport | |||
| TransportationMode | TransportationMode | Transportation Mode | ||
| TransportationModeCategory | TransportationModeCategory | Transportation Mode Category | ||
| TranspOrdStageAirlineIATACode | TranspOrdStageAirlineIATACode | IATA Airline Code | ||
| TranspOrdStageAirWayBill | TranspOrdStageAirWayBill | Air Waybill Prefix | ||
| TranspOrdStageVoyage | TranspOrdStageVoyage | Voyage / Train Number | ||
| TranspOrdStageFlight | TranspOrdStageFlight | Airline Code and Flight Number | ||
| TranspOrdStageVessel | TranspOrdStageVessel | Vessel Name | ||
| TranspOrdStageIMOShip | TranspOrdStageIMOShip | IMO Ship Identification Number | ||
| RequestingCompanyCode | RequestingCompanyCode | Company Code Paying for the Transportation Service | ||
| Carrier | Carrier | Service Agent | ||
| TranspOrdStageSCACCode | TranspOrdStageSCACCode | Standard Carrier Alpha Code | ||
| TranspOrdStageMaxUtilznRatio | TranspOrdStageMaxUtilznRatio | Transportation Order Stage Maximum Utilization Ratio | ||
| TranspOrdStageUtilznMassRatio | TranspOrdStageUtilznMassRatio | Transportation Order Stage Utilization Mass Ratio | ||
| TranspOrdStageUtilznVolRatio | TranspOrdStageUtilznVolRatio | Transportation Order Stage Utilization Volume Ratio | ||
| TranspOrdStageUtilznLenRatio | TranspOrdStageUtilznLenRatio | Transportation Order Stage Utilization Length Ratio | ||
| TranspOrdStageUtilznQtyRatio | TranspOrdStageUtilznQtyRatio | Transp. Order Stage Utilization Quantity Ratio (No Dim) | ||
| TranspOrdUtilznUnit | Transportation Order Utilization Unit | |||
| TranspOrdStageDistance | TranspOrdStageDistance | Transportation Order Stage Distance | ||
| TranspOrdStageDistanceUnit | Transportation Order Stage Distance Unit | |||
| TranspOrdStageNetDuration | Transportation Order Stage Net Duration in hhmmss | |||
| _TransportationOrderAnalytics | _TransportationOrderAnalytics | |||
| _TranspOrdStageSrceStopAnlyts | _TranspOrdStageSrceStopAnlyts | |||
| _TranspOrdStageDestStopAnlyts | _TranspOrdStageDestStopAnlyts | |||
| _TranspOrdStageDistanceUnit | _TranspOrdStageDistanceUnit | |||
| _TranspOrdStageType | _TranspOrdStageType | |||
| _TranspOrdStageCategory | _TranspOrdStageCategory | |||
| _TranspOrdStagePlnStatus | _TranspOrdStagePlnStatus | |||
| _MeansOfTransport | _MeansOfTransport | |||
| _TransportationMode | _TransportationMode | |||
| _TransportationModeCategory | _TransportationModeCategory | |||
| _Carrier | _Carrier | |||
| _TranspSCACCode | _TranspSCACCode | |||
| _TranspAirlineIATACode | _TranspAirlineIATACode | |||
| _RequestingCompanyCode | _RequestingCompanyCode |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view I_TranspOrdStageAnalytics.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW I_TranspOrdStageAnalytics AS
SELECT
cast(TransportationOrderStageUUID as /scmtms/vdm_tor_stage_db_key preserving type ) AS TransportationOrderStageUUID,
TransportationOrderUUID,
cast(TranspOrdStageSrceStopUUID as /scmtms/vdm_tor_stg_s_stop_key preserving type) AS TranspOrdStageSrceStopUUID,
cast(TranspOrdStageDestStopUUID as /scmtms/vdm_tor_stg_d_stop_key preserving type) AS TranspOrdStageDestStopUUID,
cast(CarrierUUID as /scmtms/vdm_carrier_party_key preserving type ) AS CarrierUUID,
cast(TransportationOrderStage as /scmtms/vdm_stage preserving type) AS TransportationOrderStage,
cast(TranspOrdStageDestStopCategory as /scmtms/vdm_tor_stg_d_stop_cat preserving type) AS TranspOrdStageDestStopCategory,
cast(TranspOrdStageType as /scmtms/vdm_stage_type preserving type ) AS TranspOrdStageType,
cast(TranspOrdStageCategory as /scmtms/vdm_stage_category preserving type ) AS TranspOrdStageCategory,
cast(TranspOrdStagePlnStatus as /scmtms/vdm_tor_stg_pln_status preserving type) AS TranspOrdStagePlnStatus,
cast(MeansOfTransport as /scmtms/vdm_tor_mot preserving type) AS MeansOfTransport,
TransportationMode,
TransportationModeCategory,
TranspOrdStageAirlineIATACode,
TranspOrdStageAirWayBill,
TranspOrdStageVoyage,
TranspOrdStageFlight,
TranspOrdStageVessel,
TranspOrdStageIMOShip,
RequestingCompanyCode,
Carrier,
TranspOrdStageSCACCode,
TranspOrdStageMaxUtilznRatio,
TranspOrdStageUtilznMassRatio,
TranspOrdStageUtilznVolRatio,
TranspOrdStageUtilznLenRatio,
TranspOrdStageUtilznQtyRatio,
cast(cast('%' as abap.unit(3)) as /scmtms/vdm_util_percent_unit preserving type) AS TranspOrdUtilznUnit,
TranspOrdStageDistance,
cast('KM' as /scmtms/vdm_stage_dstnc_unit) AS TranspOrdStageDistanceUnit,
cast(TranspOrdStageNetDuration as /scmtms/vdm_stg_net_duration preserving type) AS TranspOrdStageNetDuration
FROM I_TransportationOrderStage
LEFT OUTER JOIN I_TransportationOrderAnalytics AS _TransportationOrderAnalytics ON TransportationOrderUUID = _TransportationOrderAnalytics.TransportationOrderUUID -- association [1..1]
LEFT OUTER JOIN I_TranspOrdStopAnalytics AS _TranspOrdStageSrceStopAnlyts ON TranspOrdStageSrceStopUUID = _TranspOrdStageSrceStopAnlyts.TransportationOrderStopUUID -- association [1..1]
LEFT OUTER JOIN I_TranspOrdStopAnalytics AS _TranspOrdStageDestStopAnlyts ON TranspOrdStageDestStopUUID = _TranspOrdStageDestStopAnlyts.TransportationOrderStopUUID -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TranspOrdStageDistanceUnit ON TranspOrdStageDistanceUnit = _TranspOrdStageDistanceUnit.UnitOfMeasure -- association [1..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA