R_TransportationOrderEventTP

DDL: R_TRANSPORTATIONORDEREVENTTP Type: view_entity TRANSACTIONAL
15 Fields 2 Data Sources

Transportation Order Event - TP

R_TransportationOrderEventTP is a Transactional CDS View that provides data about "Transportation Order Event - TP" in SAP S/4HANA. It reads from 2 data sources (I_TransportationOrder, I_TranspOrdExecution) and exposes 15 fields with key field TransportationOrderEventUUID.

Data Sources (2)

SourceAliasJoin Type
I_TransportationOrder TransportationOrder inner
I_TranspOrdExecution TransportationOrderEvent from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transportation Order Event - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey TransportationOrderEventUUID view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderEventUUID I_TranspOrdExecution TransportationOrderEventUUID UUID
TransportationOrderUUID I_TranspOrdExecution TransportationOrderUUID
TransportationOrderEvent I_TranspOrdExecution TranspOrdExecution
TranspOrdEventCode I_TranspOrdExecution TranspOrdEventCode Event
TranspOrdEvtActualDateTime I_TranspOrdExecution TranspOrdEvtActualDateTime
TranspOrdEvtActualDateTimeZone I_TranspOrdExecution TranspOrdEvtActualDateTimeZone
LocationAdditionalUUID I_TranspOrdExecution LocationAdditionalUUID
TransportationOrderStopUUID I_TranspOrdExecution TransportationOrderStopUUID UUID of TO Stop
CreatedByUser I_TranspOrdExecution CreatedByUser User Name
CreationDateTime I_TranspOrdExecution CreationDateTime Timestamp
LastChangedByUser I_TranspOrdExecution LastChangedByUser User Name
ChangedDateTime I_TranspOrdExecution ChangedDateTime Time Stamp
TransportationOrderCategory I_TransportationOrder TransportationOrderCategory TO Category
_TransportationOrderStop I_TranspOrdExecution _TransportationOrderStop
_TransportationOrder _TransportationOrder

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 R_TransportationOrderEventTP.
-- 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 R_TransportationOrderEventTP AS
SELECT
  TransportationOrderEvent.TransportationOrderEventUUID AS TransportationOrderEventUUID,
  TransportationOrderEvent.TransportationOrderUUID AS TransportationOrderUUID,
  TransportationOrderEvent.TranspOrdExecution AS TransportationOrderEvent,
  TransportationOrderEvent.TranspOrdEventCode AS TranspOrdEventCode,
  TransportationOrderEvent.TranspOrdEvtActualDateTime AS TranspOrdEvtActualDateTime,
  TransportationOrderEvent.TranspOrdEvtActualDateTimeZone AS TranspOrdEvtActualDateTimeZone,
  TransportationOrderEvent.LocationAdditionalUUID AS LocationAdditionalUUID,
  TransportationOrderEvent.TransportationOrderStopUUID AS TransportationOrderStopUUID,
  TransportationOrderEvent.CreatedByUser AS CreatedByUser,
  TransportationOrderEvent.CreationDateTime AS CreationDateTime,
  TransportationOrderEvent.LastChangedByUser AS LastChangedByUser,
  TransportationOrderEvent.ChangedDateTime AS ChangedDateTime,
  TransportationOrder.TransportationOrderCategory AS TransportationOrderCategory,
  TransportationOrderEvent._TransportationOrderStop AS _TransportationOrderStop
FROM I_TranspOrdExecution AS TransportationOrderEvent
INNER JOIN I_TransportationOrder AS TransportationOrder ON /* join condition not captured in parsed metadata */
;

Learn More