I_CAPACITYBASIC

CDS View

Enterprise Resource Capacity

I_CAPACITYBASIC is a CDS View in S/4HANA. Enterprise Resource Capacity. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CapacityInterval view_entity inner COMPOSITE Enterprise Resource Capacity Interval
I_CapacityShift view_entity inner COMPOSITE Ent Resource Capacity Interval Shift
I_CapacityTextBasic view_entity inner COMPOSITE Enterprise Resource Capacity - Text 
@AccessControl.authorizationCheck: #MANDATORY
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction.enabled: true
@Analytics.internalName:#LOCAL
@EndUserText.label: 'Enterprise Resource 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: 'EnterpriseResourceCapacity'
define view entity I_CapacityBasic
  as select from I_Capacity
  association [0..*] to I_CapacityTextBasic as _Text            on $projection.CapacityInternalID = _Text.CapacityInternalID

{
      @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

      @ObjectModel.foreignKey.association: '_CapacityQuantityUnit'
      CapacityQuantityUnit,
      @ObjectModel.foreignKey.association: '_CapacityBaseQtyUnit'
      CapacityBaseQtyUnit,
      @Semantics.systemDateTime.lastChangedAt: true
      CapacityLastChangeDateTime,
      // APO Fields

      ResourceType,
      ResourceCategory,
      RsceValidityStartOffsetInDays,
      RsceValidityEndOffsetInDays,
      ResourceSortText,
      ResourceFinitenessLevel,
      ResourceIsBottleNeck,
      RsceOverlappingActiesSync,
      @Semantics.quantity.unitOfMeasure : 'ResourceTimeBufferUnit'
      ResourceTimeBufferQuantity,
      @ObjectModel.foreignKey.association: '_ResourceTimeBufferUnit'
      ResourceTimeBufferUnit,
      @Semantics.quantity.unitOfMeasure : 'ResourceMaxOverlapDurationUnit'
      ResourceMaxOverlapDuration,
      @ObjectModel.foreignKey.association: '_RsceMaxOverlapDurationUnit'
      ResourceMaxOverlapDurationUnit,
      ResourceIsCampaignRelevant,
      RsceShiftsAndBreaksAreDerived,
      PPDSPeriodSourceType,
      PPDSPeriodDurationSchema,
      PPDSPeriodTimeRatioInPercent,
      PPDSCapacitySupplyTimeCategory,
      RsceHasStorCharcs,
      RsceStorageQuantityDimension,
      @ObjectModel.foreignKey.association: '_RsceStorageQuantityUnit'
      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

Learn More