I_TranspOrdExecutionAnalytics

Purpose
This CDS view helps you to analyze execution information for transportation orders. This information can contain events that have been imported from an external source, like Event Management, into Transportation Management (TM), or transportation activities that are entered directly or set automatically through an action or status change in TM transportation orders. The events have references to the transportation order root/header, item and/or stop. For these references the CDS view contains associations. Some analysis possibilities or business questions that can be answered by using this view are: What are the actual dates/times for events? With the dates/times information and the available associations, especially with transportation order stops, several durations can be calculated. Delay of an expected event Delivery efficiency How many events with a specific event code have been posted? At a certain location Within a certain timeframe 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. 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 the standard Transportation Management authorization objects. You’ll 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 TransportationOrderEventUUID UUIDs for references to Transportation Analytics, Transportation Item Analytics and Transportation Stop Analytics CDS views TransportationOrderUUID TransportationOrderStopUUID TransportationOrderItemUUID Execution information with detail information on the Event TranspOrdExecution TranspOrdEventCode TranspOrdEventStatus TransportationActivity TranspOrdEventIsRecalled Date/Time for the Event that can be used to calculate durations and delays TranspOrdEvtActualDateTime Location Location Management Information CreatedByUser CreationDateTime 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.