R_WorkCenterPooledCapacityTP

//@AbapCatalog.sqlViewName: 'RWRKCTRPOOLCAPTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Pooled Capacity'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.sapObjectNodeType.name: 'PooledCapacity'
define root view entity R_WorkCenterPooledCapacityTP
  as select from I_WorkCenterPooledCapacity as header
  -- to Capacity Interval
  composition [1..*] of R_WrkCtrPooledCapIntervalTP   as _Interval
  --to Capacity Text
  composition [1..*] of R_WorkCtrPooledCapacityTextTP as _Description
  -- to ProductionPlanningOptimizer
  composition [1..*] of R_PPOptmzrCapCostConstraintTP   as _PPOptmzr
  -- to Time Dependent storage characteristics
  composition [1..*] of R_RsceTmeDepdntStorCharcsTP   as _TmeDepdntStorCharcs
{
  key CapacityInternalID,
      Plant,
      Capacity,
      CapacityCategoryCode,
      CapacityActiveVersion,
      CapacityIsFinite,
      CapacityIsPooled,
      CapacityHasIndivCapacities,
      CapacityIsExcldFrmLongTermPlng,
      CapacityNumberOfCapacities,
      CapacityResponsiblePlanner,
      CapacityPlanUtilizationPercent,
      CapacityBreakDuration,
      CapIsUsedInMultiOperations,
      ReferencedCapacityInternalID,
      CapOverloadThresholdInPercent,
      FactoryCalendar,
      AuthorizationGroup,
      ShiftGroup,
      // Times

      @Semantics.durationInSeconds:true
      CapacityStartTimeID,
      @Semantics.durationInSeconds:true
      CapacityEndTimeID,
      CapacityQuantityUnit,
      CapacityBaseQtyUnit,
      CapacityLastChangeDateTime,
      // APO Fields

      ResourceType,
      ResourceCategory,
      RsceValidityStartOffsetInDays,
      RsceValidityEndOffsetInDays,
      ResourceSortText,
      ResourceFinitenessLevel,
      ResourceIsBottleNeck,
      RsceOverlappingActiesSync,
      ResourceTimeBufferQuantity,
      ResourceTimeBufferUnit,
      ResourceMaxOverlapDuration,
      ResourceMaxOverlapDurationUnit,
      ResourceIsCampaignRelevant,
      RsceShiftsAndBreaksAreDerived,
      PPDSPeriodSourceType,
      PPDSPeriodDurationSchema,
      PPDSPeriodTimeRatioInPercent,
      PPDSCapacitySupplyTimeCategory,
      RsceHasStorCharcs,
      RsceStorageQuantityDimension,
      RsceStorageQuantityUnit,
      RsceStorageMinProductionQty,
      RsceStorageMaxQuantity,
      RsceStorIsZeroOnNoFillPurity,
      CapacityPlanningPeriodLotSize,
      RsceStorHasMltplProds,
      RsceStorZeroFillPurityThldQty,  
      /* Associations */
      _Interval,
      _Description,
      _PPOptmzr,
      _TmeDepdntStorCharcs
}
where
  Capacity is not initial