P_RealTimeMfgOrderStatus

@AbapCatalog.sqlViewName: 'PRTMFORDSTAT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ControllingObject'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
//@EndUserText.label: 'CO PCC Object Max Status'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@VDM.viewType: #COMPOSITE
@VDM.private:true

define view P_RealTimeMfgOrderStatus
  as select from I_StatusObjectStatusBasic
{
  key StatusObject as ControllingObject,

      case substring(StatusObject, 1, 2)
        when 'OR'
            then substring(StatusObject, 3, 12)
        when 'OP'
            then substring(StatusObject, 3, 12)
        else ''
      end          as OrderID,

      case substring(StatusObject, 1, 2)
        when 'OR'
            then '0000'
        when 'OP'
            then substring(StatusObject, 15, 4)
        else ''
      end          as OrderItem,

      max(StatusCode) as StatusCode
}
where
  (
       StatusCode       =  'I0002' //Released

    or StatusCode       =  'I0012' //Delivered

    or StatusCode       =  'I0045' //Technically Completed

    or StatusCode       =  'I0046'
    or StatusCode       =  'I0076'
  )
  and  StatusIsInactive =  ''
  //and  StatusCode       <> 'I0046' // CLSD = closed

  //and  StatusCode       <> 'I0076' // DLFL = deletion flag

group by
  StatusObject
  //StatusCode

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSOBJECTSTATUSBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/