I_WorkCenterPooledCapAlloc

DDL: I_WORKCENTERPOOLEDCAPALLOC Type: view_entity COMPOSITE Package: VDM_PP_MD_WKC

Work Center Pooled Capacity Allocation

I_WorkCenterPooledCapAlloc is a Composite CDS View (Dimension) that provides data about "Work Center Pooled Capacity Allocation" in SAP S/4HANA. It reads from 2 data sources (I_Capacity, I_WorkCenterCapacity) and exposes 21 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID. It has 1 association to related views. Part of development package VDM_PP_MD_WKC.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
I_Capacity Cap from
I_WorkCenterCapacity CapMap inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_WorkCenterCapacity _WorkCenterCapMap $projection.WorkCenterInternalID = _WorkCenterCapMap.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenterCapMap.WorkCenterTypeCode and $projection.CapacityCategoryAllocation = _WorkCenterCapMap.CapacityCategoryAllocation

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
EndUserText.label Work Center Pooled Capacity Allocation view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey CapacityInternalID view
ObjectModel.sapObjectNodeType.name WorkCenterPooledCapacityAlloc view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacity WorkCenterInternalID
KEY WorkCenterTypeCode I_WorkCenterCapacity WorkCenterTypeCode
KEY CapacityCategoryAllocation I_WorkCenterCapacity CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacity CapacityInternalID
LastChangeDate I_WorkCenterCapacity LastChangeDate
LastChangedByUser I_WorkCenterCapacity LastChangedByUser
Plant I_Capacity Plant
WorkCenter I_WorkCenterCapacity WorkCenter
WorkCenterCategoryCode I_WorkCenterCapacity WorkCenterCategoryCode
CapacityCategoryCode I_Capacity CapacityCategoryCode
Capacity I_Capacity Capacity
SetupCapRequirementFormula I_WorkCenterCapacity SetupCapRequirementFormula
ProcgCapRequirementFormula I_WorkCenterCapacity ProcgCapRequirementFormula
TeardownCapRequirementFormula I_WorkCenterCapacity TeardownCapRequirementFormula
OtherCapRequirementFormula I_WorkCenterCapacity OtherCapRequirementFormula
ValidityStartDate I_WorkCenterCapacity ValidityStartDate
ValidityEndDate I_WorkCenterCapacity ValidityEndDate
WorkCenterLastChangeDateTime I_WorkCenterCapacity WorkCenterLastChangeDateTime
_WorkCenter I_WorkCenterCapacity _WorkCenter
_WorkCenterTypeCode I_WorkCenterCapacity _WorkCenterTypeCode
_WorkCenterCapMap _WorkCenterCapMap 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
//@VDM: { viewType: #COMPOSITE, lifecycle.contract.type: #SAP_INTERNAL_API }

@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Work Center Pooled Capacity Allocation'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction.enabled: true
@Analytics.internalName: #LOCAL
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.representativeKey: 'CapacityInternalID'
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
@ObjectModel.sapObjectNodeType.name: 'WorkCenterPooledCapacityAlloc'

define view entity I_WorkCenterPooledCapAlloc
   as select from I_Capacity           as Cap
  inner join   I_WorkCenterCapacity as CapMap on Cap.CapacityInternalID = CapMap.CapacityInternalID
  
  association [1..1] to I_WorkCenterCapacity as _WorkCenterCapMap on  $projection.WorkCenterInternalID       = _WorkCenterCapMap.WorkCenterInternalID
                                                                  and $projection.WorkCenterTypeCode         = _WorkCenterCapMap.WorkCenterTypeCode
                                                                  and $projection.CapacityCategoryAllocation = _WorkCenterCapMap.CapacityCategoryAllocation
  
{     
      @ObjectModel.foreignKey.association: '_WorkCenter'
  key CapMap.WorkCenterInternalID,
      @ObjectModel.foreignKey.association: '_WorkCenterTypeCode'
  key CapMap.WorkCenterTypeCode,
      @ObjectModel.foreignKey.association: '_WorkCenterCapMap'
  key CapMap.CapacityCategoryAllocation,
  key CapMap.CapacityInternalID,
      CapMap.LastChangeDate,
      CapMap.LastChangedByUser,
      Cap.Plant,
      CapMap.WorkCenter,
      CapMap.WorkCenterCategoryCode,
      Cap.CapacityCategoryCode,
      Cap.Capacity,
      CapMap.SetupCapRequirementFormula,
      CapMap.ProcgCapRequirementFormula,
      CapMap.TeardownCapRequirementFormula,
      CapMap.OtherCapRequirementFormula,
      CapMap.ValidityStartDate,
      CapMap.ValidityEndDate,
      CapMap.WorkCenterLastChangeDateTime,
      
      // Associations

      CapMap._WorkCenter,
      CapMap._WorkCenterTypeCode,
      _WorkCenterCapMap
      
      
}
where
      CapMap.WorkCenterTypeCode = 'A'
  and Cap.CapacityIsPooled   is not initial

Learn More