I_WorkCenterPooledCapacity

@AbapCatalog.sqlViewName: 'IWRKCTRPOOLEDCAP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction.enabled: true
@Analytics.internalName:#LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Work Center Pooled Capacity'
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
@ObjectModel.representativeKey: 'CapacityInternalID'
@ObjectModel.semanticKey: ['Capacity']
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #MASTER}
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.sapObjectNodeType.name: 'PooledCapacity'
define view I_WorkCenterPooledCapacity
  as select from I_Capacity

{
      @ObjectModel.text.association: '_Text'
  key CapacityInternalID,
      // Semantic Key

      @ObjectModel.foreignKey.association: '_Plant'
      Plant,
      @ObjectModel.foreignKey.association: '_CapacityBySemanticKey'
      Capacity,
      // Attributes

      @ObjectModel.foreignKey.association: '_CapacityCategory'
      CapacityCategoryCode,
      CapacityActiveVersion,
      CapacityIsFinite,
      CapacityIsPooled,
      CapacityHasIndivCapacities,
      CapacityIsExcldFrmLongTermPlng,
      CapacityNumberOfCapacities,
      @ObjectModel.foreignKey.association: '_CapacityResponsiblePlanner'
      CapacityResponsiblePlanner,
      CapacityPlanUtilizationPercent,
      CapacityBreakDuration,
      CapIsUsedInMultiOperations,
      @ObjectModel.text.association: '_ReferencedCapacityText'
      @ObjectModel.foreignKey.association: '_Capacity'
      ReferencedCapacityInternalID,
      CapOverloadThresholdInPercent,
      
      // Assignments

      @ObjectModel.foreignKey.association: '_FactoryCalendar'
      FactoryCalendar,
      AuthorizationGroup,
      @ObjectModel.foreignKey.association: '_ShiftGrouping'
      ShiftGroup,
      // Times

      @Semantics.durationInHours:true
      CapacityStartTimeID,
      @Semantics.durationInHours:true
      CapacityEndTimeID,
      // Unit of Measures

      @Semantics.unitOfMeasure: true
      CapacityQuantityUnit,
      @Semantics.unitOfMeasure: true
      CapacityBaseQtyUnit,
      @Semantics.systemDateTime.lastChangedAt: true
      CapacityLastChangeDateTime,
      // APO Fields

      ResourceType,
      ResourceCategory,
      RsceValidityStartOffsetInDays,
      RsceValidityEndOffsetInDays,
      ResourceSortText,
      ResourceFinitenessLevel,
      ResourceIsBottleNeck,
      RsceOverlappingActiesSync,
      @Semantics.quantity.unitOfMeasure : 'ResourceTimeBufferUnit'
      ResourceTimeBufferQuantity,
      ResourceTimeBufferUnit,
      @Semantics.quantity.unitOfMeasure : 'ResourceMaxOverlapDurationUnit'
      ResourceMaxOverlapDuration,
      ResourceMaxOverlapDurationUnit,
      ResourceIsCampaignRelevant,
      RsceShiftsAndBreaksAreDerived,
      PPDSPeriodSourceType,
      PPDSPeriodDurationSchema,
      PPDSPeriodTimeRatioInPercent,
      PPDSCapacitySupplyTimeCategory,
      RsceHasStorCharcs,
      RsceStorageQuantityDimension,
      RsceStorageQuantityUnit,
      @Semantics.quantity.unitOfMeasure : 'RsceStorageQuantityUnit'
      RsceStorageMinProductionQty,
      @Semantics.quantity.unitOfMeasure : 'RsceStorageQuantityUnit'
      RsceStorageMaxQuantity,
      RsceStorIsZeroOnNoFillPurity,
      CapacityPlanningPeriodLotSize,
      RsceStorHasMltplProds,
      @Semantics.quantity.unitOfMeasure : 'RsceStorageQuantityUnit'
      RsceStorZeroFillPurityThldQty,
      
      //Associations

      _CapacityCategory,
      _FactoryCalendar,
      _Plant,
      _Text,
      _ReferencedCapacityText,
      _CapacityResponsiblePlanner,
      _ShiftGrouping,
      _CapacityQuantityUnit,
      _CapacityBaseQtyUnit,
      _CapacityBySemanticKey,
      _Capacity,
      _ResourceTimeBufferUnit,
      _RsceMaxOverlapDurationUnit,
      _RsceStorageQuantityUnit    
}
where
  Capacity is not initial