P_MfgOrderOpStatus

@AbapCatalog.sqlViewName: 'PMFGORDEROPSTS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_MfgOrderOpStatus

  as select from I_StatusObjectStatus as jest
{
  key StatusObject,

  key max(case jest.StatusCode
      when 'I0001' then 10
      when 'I0002' then 20
      when 'I0009' then 30
      when 'I0010' then 40
      end) as StatusCode

}
where
       StatusIsInactive = ''
//  and(

//       jest.StatusCode = 'I0001'

//    or jest.StatusCode = 'I0002'

//    or jest.StatusCode = 'I0009'

//    or jest.StatusCode = 'I0010'

//  )

  
group by
  StatusObject

//  as select from I_OrderOperationBasic     as afvc

//

//    inner join   I_StatusObjectStatusBasic as jest on  jest.StatusObject     = afvc.ObjectInternalID

//                                                   and jest.StatusIsInactive = ''

//

//{

//      // Technical Key

//  key afvc.OrderInternalID,

//  key afvc.OrderOperationInternalID,

//

//      // Status

//

//      afvc.ObjectInternalID,

//      max(case jest.StatusCode

//        when 'I0001' then 10

//        when 'I0002' then 20

//        when 'I0009' then 30

//        when 'I0010' then 40

//      end) as StatusCode

//

//

//}

//

////where

////     jest.StatusCode = 'I0001'

////  or jest.StatusCode = 'I0002'

////  or jest.StatusCode = 'I0009'

////  or jest.StatusCode = 'I0010'

//

//group by

//  OrderInternalID,

//  OrderOperationInternalID,

//  ObjectInternalID;

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