P_ORDEROPERATIONSTATUSBASICAGG

@AbapCatalog.sqlViewName: 'PPPORDEROPSTSA'
@AbapCatalog.compiler.compareFilter: 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 aggregated main operation status per ObjectInternalID

define view P_OrderOperationStatusBasicAgg
  as select from P_OrderOperationStatusBasic
{
      // Technical Key

  key ObjectInternalID,
      // Status

      max(OperationIsCreated)            as OperationIsCreated,
      max(OperationIsReleased)           as OperationIsReleased,
      max(OperationIsPrinted)            as OperationIsPrinted,
      max(OperationIsConfirmed)          as OperationIsConfirmed,
      max(OperationIsPartiallyConfirmed) as OperationIsPartiallyConfirmed,
      max(OperationIsDeleted)            as OperationIsDeleted,
      max(OperationIsTechlyCompleted)    as OperationIsTechlyCompleted,
      max(OperationIsClosed)             as OperationIsClosed,
      max(OperationIsConfdByMilestone)   as OperationIsConfdByMilestone,
      max(OperationIsManuallyConfirmed)  as OperationIsManuallyConfirmed,
      max(OperationIsScheduled)          as OperationIsScheduled,
      max(OperationIsGenerated)          as OperationIsGenerated,
      max(OperationIsPartiallyDelivered) as OperationIsPartiallyDelivered,
      max(OperationIsDelivered)          as OperationIsDelivered,
      max(ControlRecipeIsCreated)        as ControlRecipeIsCreated
}
group by
  ObjectInternalID;