P_EAMOVERALLSTATUSNEXTSEQUENCE

CDS View

Overall Status Sequence

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

Used by 1 CDS view(s) 5 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EAMOverallStatusNextPrimary view_entity from BASIC Next Primary Overall Status

Fields (5)

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

define view entity P_EAMOverallStatusNextSequence
  as select from    eam_ostat as _current
    left outer join eam_ostat as _next on  _next.overall_status_profile = _current.overall_status_profile
                                       and _next.used_for_entity_type   = _current.used_for_entity_type
                                       and _next.sequence               > _current.sequence
                                       and _next.is_skippable           = ''
{
  key _current.overall_status_profile as EAMOverallStatusProfile,
  key _current.overall_status         as EAMOverallStatus,
  key _current.used_for_entity_type   as EAMOverallStatusEntity,
  key _current.sequence               as EAMOverallStatusSequence,

      min(_next.sequence)             as EAMNextOverallStatusSequence
}
group by
  _current.overall_status_profile,
  _current.overall_status,
  _current.used_for_entity_type,
  _current.sequence

Learn More