I_CapacityBasic

DDL: I_CAPACITYBASIC Type: view_entity COMPOSITE Package: VDM_PP_MD_WKC

Enterprise Resource Capacity

I_CapacityBasic is a Composite CDS View (Dimension) that provides data about "Enterprise Resource Capacity" in SAP S/4HANA. It reads from 1 data source (I_Capacity) and exposes 65 fields with key field CapacityInternalID. It has 1 association to related views. Part of development package VDM_PP_MD_WKC.

Data Sources (1)

SourceAliasJoin Type
I_Capacity I_Capacity from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CapacityTextBasic _Text $projection.CapacityInternalID = _Text.CapacityInternalID

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
EndUserText.label Enterprise Resource Capacity view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey CapacityInternalID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.sapObjectNodeType.name EnterpriseResourceCapacity view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID
Plant Plant
Capacity Capacity
CapacityCategoryCode CapacityCategoryCode
CapacityActiveVersion CapacityActiveVersion
CapacityIsFinite CapacityIsFinite
CapacityIsPooled CapacityIsPooled
CapacityHasIndivCapacities CapacityHasIndivCapacities
CapacityIsExcldFrmLongTermPlng CapacityIsExcldFrmLongTermPlng
CapacityNumberOfCapacities CapacityNumberOfCapacities
CapacityResponsiblePlanner CapacityResponsiblePlanner
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
CapacityBreakDuration CapacityBreakDuration
CapIsUsedInMultiOperations CapIsUsedInMultiOperations
ReferencedCapacityInternalID ReferencedCapacityInternalID
CapOverloadThresholdInPercent CapOverloadThresholdInPercent
FactoryCalendar FactoryCalendar
AuthorizationGroup AuthorizationGroup
ShiftGroup ShiftGroup
CapacityStartTimeID CapacityStartTimeID
CapacityEndTimeID CapacityEndTimeID
CapacityQuantityUnit CapacityQuantityUnit
CapacityBaseQtyUnit CapacityBaseQtyUnit
CapacityLastChangeDateTime CapacityLastChangeDateTime
ResourceType ResourceType
ResourceCategory ResourceCategory
RsceValidityStartOffsetInDays RsceValidityStartOffsetInDays
RsceValidityEndOffsetInDays RsceValidityEndOffsetInDays
ResourceSortText ResourceSortText
ResourceFinitenessLevel ResourceFinitenessLevel
ResourceIsBottleNeck ResourceIsBottleNeck
RsceOverlappingActiesSync RsceOverlappingActiesSync
ResourceTimeBufferQuantity ResourceTimeBufferQuantity
ResourceTimeBufferUnit ResourceTimeBufferUnit
ResourceMaxOverlapDuration ResourceMaxOverlapDuration
ResourceMaxOverlapDurationUnit ResourceMaxOverlapDurationUnit
ResourceIsCampaignRelevant ResourceIsCampaignRelevant
RsceShiftsAndBreaksAreDerived RsceShiftsAndBreaksAreDerived
PPDSPeriodSourceType PPDSPeriodSourceType
PPDSPeriodDurationSchema PPDSPeriodDurationSchema
PPDSPeriodTimeRatioInPercent PPDSPeriodTimeRatioInPercent
PPDSCapacitySupplyTimeCategory PPDSCapacitySupplyTimeCategory
RsceHasStorCharcs RsceHasStorCharcs
RsceStorageQuantityDimension RsceStorageQuantityDimension
RsceStorageQuantityUnit RsceStorageQuantityUnit
RsceStorageMinProductionQty RsceStorageMinProductionQty
RsceStorageMaxQuantity RsceStorageMaxQuantity
RsceStorIsZeroOnNoFillPurity RsceStorIsZeroOnNoFillPurity
CapacityPlanningPeriodLotSize CapacityPlanningPeriodLotSize
RsceStorHasMltplProds RsceStorHasMltplProds
RsceStorZeroFillPurityThldQty RsceStorZeroFillPurityThldQty
_CapacityCategory _CapacityCategory
_FactoryCalendar _FactoryCalendar
_Plant _Plant
_Text _Text
_ReferencedCapacityText _ReferencedCapacityText
_CapacityResponsiblePlanner _CapacityResponsiblePlanner
_ShiftGrouping _ShiftGrouping
_CapacityQuantityUnit _CapacityQuantityUnit
_CapacityBaseQtyUnit _CapacityBaseQtyUnit
_CapacityBySemanticKey _CapacityBySemanticKey
_Capacity _Capacity
_ResourceTimeBufferUnit _ResourceTimeBufferUnit
_RsceMaxOverlapDurationUnit _RsceMaxOverlapDurationUnit
_RsceStorageQuantityUnit _RsceStorageQuantityUnit
@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