P_EAMOVERALLSTATUSNEXTSEQUENCE

CDS View

P_EAMOVERALLSTATUSNEXTSEQUENCE is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EAMOverallStatusNextPrimary view from BASIC Next Primary Overall Status 
@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PEAMOSTATNXSEQ'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   usageType.serviceQuality: #A,
   usageType.sizeCategory: #S,
   usageType.dataClass: #CUSTOMIZING
}

define view 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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EAM_OSTAT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More