I_ACMApplicationDocumentStatus

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Application Document Status'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_ACMApplicationDocumentStatus
  as select from jest
    inner join   I_SystemStatusText as _StatusText on  _StatusText.SystemStatus = jest.stat
                                                   and _StatusText.Language     = $session.system_language
{
  key jest.objnr                   as ApplicationStatusObject,
  key jest.stat                    as StatusProfileName,
      @Semantics.booleanIndicator: true
      jest.inact                   as ChangeDocumentStatusIsInactive,
      _StatusText.SystemStatusName as SystemStatusName
}
where
  (
       jest.stat  = 'I7A01'
    or jest.stat  = 'I7A02'
    or jest.stat  = 'I7A03'
    or jest.stat  = 'I7A04'
    or jest.stat  = 'I7A05'
    or jest.stat  = 'I7A06'
    or jest.stat  = 'I7A08'
    or jest.stat  = 'I7A12'
    or jest.stat  = 'I7A13'
    or jest.stat  = 'I7A14'
    or jest.stat  = 'I7A15'
    or jest.stat  = 'I7A20'
    or jest.stat  = 'I7C01'
    or jest.stat  = 'I7C02'
    or jest.stat  = 'I7C03'
    or jest.stat  = 'I7C04'
    or jest.stat  = 'I7C05'
    or jest.stat  = 'I7C07'
    or jest.stat  = 'I7L01'
    or jest.stat  = 'I7L02'
    or jest.stat  = 'I7L03'
    or jest.stat  = 'I7R01'
    or jest.stat  = 'I7R02'
    or jest.stat  = 'I7R03'
    or jest.stat  = 'I7R04'
    or jest.stat  = 'I7R05'
  )
  and  jest.inact is initial