P_ORDEROPCOMPSTATUSBASICAGGRGN

@AbapCatalog.sqlViewName: 'PORDCOMPSTSBAGGN'
@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 order component status per ObjectInternalID

// to be used in OrderOperationComponent views (join) only!


/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view P_OrderOpCompStatusBasicAggrgn
  as select from P_OrderOpCompStatusBasic
{
      // Key

  key ObjectInternalID,

      // Status

      cast(max(MaterialComponentIsCreated)    as componentiscreated  preserving type) as MaterialComponentIsCreated,
      cast(max(MaterialComponentIsReleased)   as componentisreleased preserving type) as MaterialComponentIsReleased,
      cast(max(MaterialComponentIsPrinted)    as componentisprinted  preserving type) as MaterialComponentIsPrinted,
      cast(max(MaterialComponentIsDeleted)    as componentisdeleted  preserving type) as MaterialComponentIsDeleted,
      cast(max(MatlCompIsCreatedByOrderSplit) as iscrtedbyordersplit preserving type) as MatlCompIsCreatedByOrderSplit,

      // Associations

      _StatusObject,
      _ComponentIsCreatedCode,
      _ComponentIsReleasedCode,
      _ComponentIsPrintedCode,
      _ComponentIsDeletedCode,
      _CompIsCreatedByOrderSplitCode
}
group by
  ObjectInternalID