I_EAMOverallStatusSequence

@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Sequence of Overall Status'
@VDM.viewType: #COMPOSITE
@ObjectModel: {
   usageType.serviceQuality: #B,
   usageType.sizeCategory: #S,
   usageType.dataClass: #CUSTOMIZING
}

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view entity I_EAMOverallStatusSequence
  //  as select from    I_EAMOverallStatusNextPrimary

  //    left outer join I_EAMOverallStatus as _OverallStatus on  _OverallStatus.EAMOverallStatusProfile  =  I_EAMOverallStatusNextPrimary.EAMOverallStatusProfile

  //                                                         and _OverallStatus.EAMOverallStatusEntity   =  I_EAMOverallStatusNextPrimary.EAMOverallStatusEntity

  //                                                         and _OverallStatus.EAMOverallStatusSequence >  I_EAMOverallStatusNextPrimary.EAMOverallStatusSequence

  //                                                         and _OverallStatus.EAMOverallStatusSequence <= I_EAMOverallStatusNextPrimary.EAMNextOverallStatusSequence

  //{

  //  key I_EAMOverallStatusNextPrimary.EAMOverallStatusProfile,

  //  key I_EAMOverallStatusNextPrimary.EAMOverallStatus,

  //  key _OverallStatus.EAMOverallStatus as EAMNextOverallStatus,

  //

  //      cast( case

  //      when _OverallStatus.EAMOverallStatusSequence = I_EAMOverallStatusNextPrimary.EAMNextOverallStatusSequence then 'X'

  //      else ' ' end as xfeld )         as EAMOvrlStsCannotBeSkipped

  as select from           P_EAMOverallStatusPrevSequence
    left outer join        I_EAMOverallStatus as _OverallStatus on  _OverallStatus.EAMOverallStatusProfile  =  P_EAMOverallStatusPrevSequence.EAMOverallStatusProfile
                                                                and _OverallStatus.EAMOverallStatusEntity   =  P_EAMOverallStatusPrevSequence.EAMOverallStatusEntity
                                                                and _OverallStatus.EAMOverallStatusSequence <  P_EAMOverallStatusPrevSequence.EAMOverallStatusSequence
                                                                and _OverallStatus.EAMOverallStatusSequence >= P_EAMOverallStatusPrevSequence.EAMPrevOverallStatusSequence
    left outer to one join I_EAMOverallStatus as _TargetStatus  on  _TargetStatus.EAMOverallStatusProfile = P_EAMOverallStatusPrevSequence.EAMOverallStatusProfile
                                                                and _TargetStatus.EAMOverallStatus        = P_EAMOverallStatusPrevSequence.EAMOverallStatus
{
  key _OverallStatus.EAMOverallStatusProfile,
  key _OverallStatus.EAMOverallStatus,
  key P_EAMOverallStatusPrevSequence.EAMOverallStatus                                 as EAMNextOverallStatus,

      @Semantics.booleanIndicator: true
      case when _TargetStatus.EAMOverallStatusCanBeSkipped = 'X' then '' else 'X' end as EAMOvrlStsCannotBeSkipped
}
union select from I_EAMOverallStatusAltvSequence
{
  key EAMOverallStatusProfile,
  key EAMOverallStatus,
  key EAMNextOverallStatus,
      ' ' as EAMOvrlStsCannotBeSkipped
}