P_ORDERSTATUSBASICAGGRGN

@AbapCatalog.sqlViewName: 'PORDERSTSBASAGGR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the aggregated main order header status per ObjectInternalID

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


define view P_OrderStatusBasicAggrgn
  as select from P_OrderStatusBasic
{
      // Key

  key ObjectInternalID,

      // Status

      max(OrderIsCreated)                as OrderIsCreated,
      max(OrderIsReleased)               as OrderIsReleased,
      max(OrderHasMaterialShortage)      as OrderHasMaterialShortage,      
      max(OrderIsPrinted)                as OrderIsPrinted,
      max(OrderIsPartiallyPrinted)       as OrderIsPartiallyPrinted,
      max(OrderIsConfirmed)              as OrderIsConfirmed,
      max(OrderIsPartiallyConfirmed)     as OrderIsPartiallyConfirmed,
      max(OrderIsDelivered)              as OrderIsDelivered,
      max(OrderIsDeleted)                as OrderIsDeleted,
      max(OrderIsProductCosted)          as OrderIsProductCosted,
      max(OrderIsPreCosted)              as OrderIsPreCosted,
      max(SettlementRuleIsCreated)       as SettlementRuleIsCreated,
      max(OrderIsPartiallyReleased)      as OrderIsPartiallyReleased,
      max(OrderIsLocked)                 as OrderIsLocked,
      max(OrderIsTechnicallyCompleted)   as OrderIsTechnicallyCompleted,
      max(OrderIsClosed)                 as OrderIsClosed,
      max(OrderIsDistributionRelevant)   as OrderIsDistributionRelevant,
      max(OrderIsDistributedToMES)       as OrderIsDistributedToMES,
      max(OrderReleaseIsRejected)        as OrderReleaseIsRejected,
      max(OrderIsPartiallyDelivered)     as OrderIsPartiallyDelivered,
      max(OrderIsMarkedForDeletion)      as OrderIsMarkedForDeletion,
      max(SettlementRuleIsCrtedManually) as SettlementRuleIsCrtedManually,
      max(OrderHasCostCalculationError)  as OrderHasCostCalculationError,
      max(OrderIsScheduled)              as OrderIsScheduled,
      max(DistributionToMESIsCompleted)  as DistributionToMESIsCompleted,
      max(OrderIsDiscardedByMES)         as OrderIsDiscardedByMES,
      max(OrderIsReleasedByMES)          as OrderIsReleasedByMES,
      max(OrderHasPostedGoodsMovements)  as OrderHasPostedGoodsMovements,
      max(OrderHasGeneratedOperations)   as OrderHasGeneratedOperations,
      max(OrderIsToBeHandledInBatches)   as OrderIsToBeHandledInBatches,
      max(MaterialAvailyIsNotChecked)    as MaterialAvailyIsNotChecked,
      max(OrderHasNoMaterialComponents)  as OrderHasNoMaterialComponents,
      max(OrderIsShopFloorOrder)         as OrderIsShopFloorOrder,
      max(OrderIsHandedOverToProduction) as OrderIsHandedOverToProduction,
      max(OrderChangeIsRestricted)       as OrderChangeIsRestricted,

      // Associations

      _OrderIsCreatedCode,
      _OrderIsReleasedCode,
      _OrderHasMatlShortageCode,
      _OrderIsPrintedCode,
      _OrderIsPrtlyPrintedCode, 
      _OrderIsConfirmedCode, 
      _OrderIsPrtlyConfirmedCode,
      _OrderIsDeliveredCode, 
      _OrderIsDeletedCode,
      _OrderIsProductCostedCode,
      _OrderIsPreCostedCode,
      _SettlmtRuleIsCreatedCode, 
      _OrderIsPrtlyReleasedCode, 
      _OrderIsLockedCode,
      _OrderIsTechlyCmpltdCode,
      _OrderIsClosedCode,
      _OrderIsDistributionRlvtCode,
      _OrderIsDistrdToMESCode,
      _OrderReleaseIsRejectedCode,
      _OrderIsPrtlyDeliveredCode,
      _OrderIsMrkdForDeletionCode,
      _SettlmtRuleIsCrtedMnllyCode,
      _OrderHasCostCalcErrorCode,
      _OrderIsScheduledCode,
      _DistributionToMESCmpltdCode,
      _OrderIsDiscardedByMESCode,
      _OrderIsReleasedByMESCode,
      _OrderHasPostdGoodsMvtCode,
      _OrderHasGeneratedOpsCode,
      _OrderIsHandledInBatchesCode,
      _MatlAvailyIsNotCheckedCode,
      _OrderHasNoComponentsCode,
      _OrderIsShopFloorOrderCode,
      _OrderIsHandedOvrToProdnCode,
      _OrderChangeIsRestrictedCode
}
group by
  ObjectInternalID;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ORDERSTATUSBASIC"
],
"ASSOCIATED":
[
"I_STATUSCODE"
],
"BASE":
[
"P_ORDERSTATUSBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/