P_OrderOperationStatusBasic

@AbapCatalog.sqlViewName: 'PPPORDEROPSTSB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the non-aggregated main operation system status per ObjectInternalID (multiple lines per key)

// to be used in aggregation views such as P_OrderOperationStatusBasicAgg only


/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view P_OrderOperationStatusBasic
  as select from I_StatusObjectStatusBasic as jest
{
      // Technical Key

  key jest.StatusObject as ObjectInternalID,
      // Status

      case jest.StatusCode
        when 'I0001' then 'X' else '' end as OperationIsCreated,
      case jest.StatusCode
        when 'I0002' then 'X' else '' end as OperationIsReleased,
      case jest.StatusCode
        when 'I0007' then 'X' else '' end as OperationIsPrinted,
      case jest.StatusCode
        when 'I0009' then 'X' else '' end as OperationIsConfirmed,
      case jest.StatusCode
        when 'I0010' then 'X' else '' end as OperationIsPartiallyConfirmed,
      case jest.StatusCode
        when 'I0013' then 'X' else '' end as OperationIsDeleted,
      case jest.StatusCode
        when 'I0045' then 'X' else '' end as OperationIsTechlyCompleted,
      case jest.StatusCode
        when 'I0046' then 'X' else '' end as OperationIsClosed,
      case jest.StatusCode
        when 'I0051' then 'X' else '' end as OperationIsConfdByMilestone,
      case jest.StatusCode
        when 'I0052' then 'X' else '' end as OperationIsManuallyConfirmed,
      case jest.StatusCode
        when 'I0117' then 'X' else '' end as OperationIsScheduled,
      case jest.StatusCode
        when 'I0328' then 'X' else '' end as OperationIsGenerated,        
      case jest.StatusCode
        when 'I0377' then 'X' else '' end as OperationIsPartiallyDelivered,
      case jest.StatusCode
        when 'I0378' then 'X' else '' end as OperationIsDelivered,
      case jest.StatusCode
        when 'I0650' then 'X' else '' end as ControlRecipeIsCreated
}
where
  (
       jest.StatusCode       = 'I0001'
    or jest.StatusCode       = 'I0002'
    or jest.StatusCode       = 'I0007'
    or jest.StatusCode       = 'I0009'
    or jest.StatusCode       = 'I0010'
    or jest.StatusCode       = 'I0013'
    or jest.StatusCode       = 'I0045'
    or jest.StatusCode       = 'I0046'
    or jest.StatusCode       = 'I0051'
    or jest.StatusCode       = 'I0052'
    or jest.StatusCode       = 'I0117'
    or jest.StatusCode       = 'I0328'
    or jest.StatusCode       = 'I0377'
    or jest.StatusCode       = 'I0378'
    or jest.StatusCode       = 'I0650'
 ) and jest.StatusIsInactive = '' 
   and jest.StatusObject like 'OV%';