I_MFGORDERSTATUS

@AbapCatalog.sqlViewName: 'IPPMFGORDERSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.representativeKey: 'ManufacturingOrder'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Manufacturing Order Header Status'
// provides the aggregated status per order header

define view I_MfgOrderStatus
  as select from P_MfgOrderStatus
{
      // Key

  key ManufacturingOrder,

      // for DCLS

      ManufacturingOrderCategory,
      ManufacturingOrderType,
      ProductionPlant,

      // Status

      ManufacturingObject,
      @ObjectModel.foreignKey.association: '_StatusProfile'      
      StatusProfile,
      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

      _StatusProfile,
    _OrderIsCreatedCode,
    _OrderIsReleasedCode,
    _OrderHasMatlShortageCode,
    _OrderIsPrintedCode,
    _OrderIsPrtlyPrintedCode, 
    _OrderIsConfirmedCode, 
    _OrderIsPrtlyConfirmedCode,
    _OrderIsDeliveredCode, 
    _OrderIsDeletedCode, 
    _OrderIsPreCostedCode,
    _OrderIsProductCostedCode,
    _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
  ManufacturingOrder,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionPlant,
  ManufacturingObject,
  StatusProfile;