P_TRANSPORDSTOPLASTRPTDEVENT

CDS View

P_TRANSPORDSTOPLASTRPTDEVENT is a CDS View in S/4HANA. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TranspOrdStopLastRptdEvent view from COMPOSITE Transp. Order: Last Rep. Event at Stop

Fields (2)

KeyField CDS FieldsUsed in Views
KEY TransportationOrderStopUUID TransportationOrderStopUUID 1
TranspOrdExecution TranspOrdExecution 1 
//@EndUserText.label: 'Transp. Order: Last Rep. Event at Stop'

@ObjectModel:   {representativeKey:  'TransportationOrderStopUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #COMPOSITE,
                 private:            true}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'PTORSTPLSTREPEVT',
                 buffering:          {status: #NOT_ALLOWED},
                 preserveKey: true
                 }
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking: #BLOCKED_DATA_EXCLUDED}    //Archiving for data blocking, as oon business purpose is done

@ClientHandling.algorithm:           #SESSION_VARIABLE

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view P_TranspOrdStopLastRptdEvent
  as select distinct from I_TranspOrdExecution
{
  key cast(TransportationOrderStopUUID as /scmtms/vdm_tor_db_key preserving type) as TransportationOrderStopUUID,
      max(TranspOrdExecution)                                                     as TranspOrdExecution

}
where
      TranspOrdEventIsRecalled =  ''
  and TranspOrdExecution       <> ''
group by
  TransportationOrderStopUUID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORDEXECUTION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More