P_EAMOverallStatusPrevSequence

DDL: P_EAMOVERALLSTATUSPREVSEQUENCE Type: view_entity COMPOSITE Package: EAM_OVRL_STS

Overall Status Sequence

P_EAMOverallStatusPrevSequence is a Composite CDS View that provides data about "Overall Status Sequence" in SAP S/4HANA. It reads from 1 data source (I_EAMOverallStatus) and exposes 5 fields with key fields EAMOverallStatusProfile, EAMOverallStatus, EAMOverallStatusEntity, EAMOverallStatusSequence. Part of development package EAM_OVRL_STS.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_EAMOverallStatus _current from

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY EAMOverallStatusProfile I_EAMOverallStatus EAMOverallStatusProfile
KEY EAMOverallStatus I_EAMOverallStatus EAMOverallStatus
KEY EAMOverallStatusEntity I_EAMOverallStatus EAMOverallStatusEntity
KEY EAMOverallStatusSequence I_EAMOverallStatus EAMOverallStatusSequence
EAMPrevOverallStatusSequence 
@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