I_WORKCENTERCAPACITY_2

CDS View

Work Center Capacity

I_WORKCENTERCAPACITY_2 is a CDS View in S/4HANA. Work Center Capacity. It contains 3 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 3 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_MassMaintCapGrpCtPooledCap view_entity from COMPOSITE WrkCtrGrp Count for Pooled Capacity
I_MassMaintCapMatlCtPooledCap view_entity from COMPOSITE Material Count for Pooled Capacity
I_MassMaintCapOpsCtPooledCap view_entity from COMPOSITE Bill of ops count for pooled capacity
I_WorkCenterCapacityInterval_3 view_entity inner COMPOSITE Work Center Capacity Intervals
I_WorkCenterCapacityText view_entity inner COMPOSITE Capacity Description
R_WorkCenterCapacityTP view_entity from TRANSACTIONAL Work Center Capacity
R_WorkCenterPooledCapAllocTP view_entity from TRANSACTIONAL Work Center Pooled Capacity Allocation

Fields (3)

KeyField CDS FieldsUsed in Views
KEY CapacityCategoryAllocation CapacityCategoryAllocation 2
KEY WorkCenterInternalID WorkCenterInternalID 2
KEY WorkCenterTypeCode WorkCenterTypeCode 2 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Capacity'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM.viewType: #COMPOSITE
define view entity I_WorkCenterCapacity_2
  as select from I_Capacity           as _Cap
    inner join   I_WorkCenterCapacity as _CapMap on _Cap.CapacityInternalID = _CapMap.CapacityInternalID

{
  key _CapMap.WorkCenterInternalID       as WorkCenterInternalID,
  key _CapMap.WorkCenterTypeCode         as WorkCenterTypeCode,
  key _CapMap.CapacityCategoryAllocation as CapacityCategoryAllocation,
  key _Cap.CapacityInternalID            as CapacityInternalID,

      // Capacity Alloc Attributes

      _CapMap.LastChangeDate,
      _CapMap.LastChangedByUser,
      _CapMap.WorkCenter,
      _CapMap._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText as ObjectDescription,
      _CapMap.WorkCenterCategoryCode,
      _CapMap.SetupCapRequirementFormula,
      _CapMap.ProcgCapRequirementFormula,
      _CapMap.TeardownCapRequirementFormula,
      _CapMap.OtherCapRequirementFormula,
      _CapMap.ValidityStartDate,
      _CapMap.ValidityEndDate,
      _CapMap.WorkCenterLastChangeDateTime,

      // Capacity Attributes

      _Cap.Capacity,
      _Cap.CapacityCategoryCode,
      _Cap.CapacityActiveVersion,
      _Cap.CapacityIsFinite,
      _Cap.CapacityIsPooled,
      _Cap.CapacityHasIndivCapacities,
      _Cap.CapacityIsExcldFrmLongTermPlng,
      _Cap.CapacityNumberOfCapacities,
      _Cap.CapacityResponsiblePlanner,
      _Cap.CapacityPlanUtilizationPercent,
      _Cap.CapacityBreakDuration,

      // Assignments

      _Cap.Plant,
      _Cap.FactoryCalendar,
      _Cap.AuthorizationGroup,
      _Cap.ShiftGroup,

      // Times


      @Semantics.durationInHours:true
      _Cap.CapacityStartTimeID,
      @Semantics.durationInHours:true
      _Cap.CapacityEndTimeID,

      _Cap.CapIsUsedInMultiOperations,
      _Cap.ReferencedCapacityInternalID,
      _Cap.CapOverloadThresholdInPercent,

      // Unit of Measures

      _Cap.CapacityQuantityUnit,
      _Cap.CapacityBaseQtyUnit, 
      
      // Capacity Description

      _Cap._Text[1:Language=$session.system_language].CapacityText as CapacityText,

      _Cap.CapacityLastChangeDateTime
}

Learn More