R_TransportationOrderEventTP

DDL: R_TRANSPORTATIONORDEREVENTTP Type: view_entity TRANSACTIONAL

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.

2 data source(s) 15 fields

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
TransportationOrderUUID I_TranspOrdExecution TransportationOrderUUID
TransportationOrderEvent I_TranspOrdExecution TranspOrdExecution
TranspOrdEventCode I_TranspOrdExecution TranspOrdEventCode
TranspOrdEvtActualDateTime I_TranspOrdExecution TranspOrdEvtActualDateTime
TranspOrdEvtActualDateTimeZone I_TranspOrdExecution TranspOrdEvtActualDateTimeZone
LocationAdditionalUUID I_TranspOrdExecution LocationAdditionalUUID
TransportationOrderStopUUID I_TranspOrdExecution TransportationOrderStopUUID
CreatedByUser I_TranspOrdExecution CreatedByUser
CreationDateTime I_TranspOrdExecution CreationDateTime
LastChangedByUser I_TranspOrdExecution LastChangedByUser
ChangedDateTime I_TranspOrdExecution ChangedDateTime
TransportationOrderCategory I_TransportationOrder TransportationOrderCategory
_TransportationOrderStop I_TranspOrdExecution _TransportationOrderStop
_TransportationOrder _TransportationOrder 
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl: {
  authorizationCheck: #MANDATORY,
  privilegedAssociations: [
    '_TransportationOrderStop'
  ]
}
@EndUserText.label: 'Transportation Order Event - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['TransportationOrderEvent'],
    representativeKey: 'TransportationOrderEventUUID'
}

define view entity R_TransportationOrderEventTP
  as select from I_TranspOrdExecution as TransportationOrderEvent
  /* We must join I_TransportationOrder to make I_TransportationOrder.TransportationOrderCategory available in the
   * projection views to filter by TransportationOrderCategory
   */
  inner join I_TransportationOrder as TransportationOrder on TransportationOrder.TransportationOrderUUID = TransportationOrderEvent.TransportationOrderUUID
  association to parent R_TransportationOrderTP as _TransportationOrder on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
{
      // Identification

  key TransportationOrderEvent.TransportationOrderEventUUID,
      TransportationOrderEvent.TransportationOrderUUID,
      TransportationOrderEvent.TranspOrdExecution as TransportationOrderEvent,
      TransportationOrderEvent.TranspOrdEventCode,
      
      // Dates and Times

      TransportationOrderEvent.TranspOrdEvtActualDateTime,
      TransportationOrderEvent.TranspOrdEvtActualDateTimeZone,

      // Location

      TransportationOrderEvent.LocationAdditionalUUID,
            
      // Event References

      TransportationOrderEvent.TransportationOrderStopUUID,

      // Administrative Data

      TransportationOrderEvent.CreatedByUser,
      TransportationOrderEvent.CreationDateTime,
      TransportationOrderEvent.LastChangedByUser,
      TransportationOrderEvent.ChangedDateTime,

      // (Technical/Hidden) Attributes

      TransportationOrder.TransportationOrderCategory,
      
      /* Associations */
      TransportationOrderEvent._TransportationOrderStop,
      _TransportationOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORDEXECUTION",
"I_TRANSPORTATIONORDER"
],
"ASSOCIATED":
[
"I_TRANSPORTATIONORDERSTOP",
"R_TRANSPORTATIONORDERTP"
],
"BASE":
[
"I_TRANSPORDEXECUTION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More