P_EAMOVERALLSTATUSPREVSEQUENCE

CDS View

Overall Status Sequence

P_EAMOVERALLSTATUSPREVSEQUENCE is a CDS View in S/4HANA. Overall Status Sequence. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EAMOverallStatusSequence view_entity from COMPOSITE Sequence of Overall Status

Fields (1)

KeyField CDS FieldsUsed in Views
KEY EAMOverallStatus EAMNextOverallStatus 1 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
   usageType.serviceQuality: #A,
   usageType.sizeCategory: #S,
   usageType.dataClass: #CUSTOMIZING
}

define view entity P_EAMOverallStatusPrevSequence
  as select from            I_EAMOverallStatus as _current
    left outer to many join I_EAMOverallStatus as _prev on  _prev.EAMOverallStatusProfile      = _current.EAMOverallStatusProfile
                                                        and _prev.EAMOverallStatusEntity       = _current.EAMOverallStatusEntity
                                                        and _prev.EAMOverallStatusSequence     < _current.EAMOverallStatusSequence
                                                        and _prev.EAMOverallStatusCanBeSkipped = ''
{
  key _current.EAMOverallStatusProfile                                                                       as EAMOverallStatusProfile,
  key _current.EAMOverallStatus                                                                              as EAMOverallStatus,
  key _current.EAMOverallStatusEntity                                                                        as EAMOverallStatusEntity,
  key _current.EAMOverallStatusSequence                                                                      as EAMOverallStatusSequence,

      max( case when _prev.EAMOverallStatusSequence is null then 0 else _prev.EAMOverallStatusSequence end ) as EAMPrevOverallStatusSequence
}
group by
  _current.EAMOverallStatusProfile,
  _current.EAMOverallStatus,
  _current.EAMOverallStatusEntity,
  _current.EAMOverallStatusSequence

Learn More