I_TranspOrdStopLastRptdEvent

DDL: I_TRANSPORDSTOPLASTRPTDEVENT SQL: ITORSTPLSTREPEVT Type: view COMPOSITE

Transp. Order: Last Rep. Event at Stop

I_TranspOrdStopLastRptdEvent is a Composite CDS View that provides data about "Transp. Order: Last Rep. Event at Stop" in SAP S/4HANA. It reads from 2 data sources (I_TranspOrdExecution, P_TranspOrdStopLastRptdEvent) and exposes 17 fields with key field TransportationOrderStopUUID.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_TranspOrdExecution ExecData inner
P_TranspOrdStopLastRptdEvent LastRptdEventAtStop from

Annotations (13)

NameValueLevelField
EndUserText.label Transp. Order: Last Rep. Event at Stop view
ObjectModel.representativeKey TransportationOrderStopUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ITORSTPLSTREPEVT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderStopUUID P_TranspOrdStopLastRptdEvent TransportationOrderStopUUID
TranspOrdExecution P_TranspOrdStopLastRptdEvent TranspOrdExecution
CreatedByUser I_TranspOrdExecution CreatedByUser
CreationDateTime I_TranspOrdExecution TranspOrdEvtActualDateTime
LastChangedByUser I_TranspOrdExecution LastChangedByUser
ChangedDateTime I_TranspOrdExecution ChangedDateTime
TranspOrdEventCode I_TranspOrdExecution TranspOrdEventCode
TranspOrdEventStatus I_TranspOrdExecution TranspOrdEventStatus
TransportationActivity I_TranspOrdExecution TransportationActivity
TranspOrdEventIsRecalled I_TranspOrdExecution TranspOrdEventIsRecalled
TranspOrdEventReasonCode I_TranspOrdExecution TranspOrdEventReasonCode
TranspOrdEventReasonDesc I_TranspOrdExecution TranspOrdEventReasonDesc
TransportationOrderEventUUID I_TranspOrdExecution TransportationOrderEventUUID
_TranspOrdEventCode I_TranspOrdExecution _TranspOrdEventCode
_TranspOrdEventStatus I_TranspOrdExecution _TranspOrdEventStatus
_TransportationActivity I_TranspOrdExecution _TransportationActivity
_TranspOrdEventIsRecalled I_TranspOrdExecution _TranspOrdEventIsRecalled 
@EndUserText.label: 'Transp. Order: Last Rep. Event at Stop'
@ObjectModel:   {representativeKey:  'TransportationOrderStopUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #COMPOSITE}
@AbapCatalog.sqlViewName:            'ITORSTPLSTREPEVT'
@AbapCatalog:   {compiler:           {compareFilter: true},
                 buffering:          {status: #NOT_ALLOWED},
                 preserveKey: true
                }
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}
@Metadata.allowExtensions:  true
@ClientHandling.algorithm:  #SESSION_VARIABLE

define view I_TranspOrdStopLastRptdEvent
  as select from P_TranspOrdStopLastRptdEvent as LastRptdEventAtStop
    inner join   I_TranspOrdExecution         as ExecData on  LastRptdEventAtStop.TransportationOrderStopUUID = ExecData.TransportationOrderStopUUID
                                                          and LastRptdEventAtStop.TranspOrdExecution          = ExecData.TranspOrdExecution

{
  key LastRptdEventAtStop.TransportationOrderStopUUID as TransportationOrderStopUUID,
      LastRptdEventAtStop.TranspOrdExecution          as TranspOrdExecution,

      ExecData.CreatedByUser                          as CreatedByUser,
      ExecData.TranspOrdEvtActualDateTime             as CreationDateTime,
      ExecData.LastChangedByUser                      as LastChangedByUser,
      ExecData.ChangedDateTime                        as ChangedDateTime,
      ExecData.TranspOrdEventCode                     as TranspOrdEventCode,
      ExecData.TranspOrdEventStatus                   as TranspOrdEventStatus,
      ExecData.TransportationActivity                 as TransportationActivity,
      ExecData.TranspOrdEventIsRecalled               as TranspOrdEventIsRecalled,
      ExecData.TranspOrdEventReasonCode               as TranspOrdEventReasonCode,
      ExecData.TranspOrdEventReasonDesc               as TranspOrdEventReasonDesc,
      ExecData.TransportationOrderEventUUID           as TransportationOrderEventUUID,

      /* Associations */
      ExecData._TranspOrdEventCode,
      ExecData._TranspOrdEventStatus,
      ExecData._TransportationActivity,
      ExecData._TranspOrdEventIsRecalled

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORDEXECUTION",
"P_TRANSPORDSTOPLASTRPTDEVENT"
],
"ASSOCIATED":
[
"I_TRANSPORDEVENTCODE",
"I_TRANSPORDEVENTISRECALLED",
"I_TRANSPORDEVENTSTATUS",
"I_TRANSPORTATIONACTIVITY"
],
"BASE":
[
"I_TRANSPORDEXECUTION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More