I_RFM_MfgOrderStatusObject

@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'IRFMSTSOBJSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Manufacturing Order Status Object'
define view I_RFM_MfgOrderStatusObject
  as select from I_StatusObjectStatusBasic as _Status
{
  key _Status.StatusObject     as StatusObject,
  key _Status.StatusCode       as StatusCode,
      _Status.StatusIsInactive as StatusIsInactive,
      cast( case
           when StatusCode = 'I0001' then '01'
           when StatusCode = 'I0042' then '02'
           when StatusCode = 'I0002' then '03'
           when StatusCode = 'I0076' then '04'
           when StatusCode = 'I0010' then '05'
           when StatusCode = 'I0009' then '06'
           when StatusCode = 'I0074' then '07'
           when StatusCode = 'I0012' then '08'
           when StatusCode = 'I0043' then '09'
           when StatusCode = 'I0045' then '10'
           when StatusCode = 'I0046' then '11'
           when StatusCode = 'I0013' then '12'
           else ''
        end as abap.numc(2))   as OrderStatusInternalID
}
where
     _Status.StatusCode = 'I0001'
  or _Status.StatusCode = 'I0002'
  or _Status.StatusCode = 'I0009'
  or _Status.StatusCode = 'I0010'
  or _Status.StatusCode = 'I0012'
  or _Status.StatusCode = 'I0013'
  or _Status.StatusCode = 'I0042'
  or _Status.StatusCode = 'I0043'
  or _Status.StatusCode = 'I0045'
  or _Status.StatusCode = 'I0046'
  or _Status.StatusCode = 'I0074'
  or _Status.StatusCode = 'I0076'