I_WorkCenterCapacity_2

DDL: I_WORKCENTERCAPACITY_2 Type: view_entity COMPOSITE Package: ODATA_PP_WORKCENTER_API

Work Center Capacity

I_WorkCenterCapacity_2 is a Composite CDS View that provides data about "Work Center Capacity" in SAP S/4HANA. It reads from 2 data sources (I_Capacity, I_WorkCenterCapacity) and exposes 40 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID. Part of development package ODATA_PP_WORKCENTER_API.

2 data source(s) 40 fields

Data Sources (2)

SourceAliasJoin Type
I_Capacity _Cap from
I_WorkCenterCapacity _CapMap inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Center Capacity view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacity WorkCenterInternalID
KEY WorkCenterTypeCode I_WorkCenterCapacity WorkCenterTypeCode
KEY CapacityCategoryAllocation I_WorkCenterCapacity CapacityCategoryAllocation
KEY CapacityInternalID I_Capacity CapacityInternalID
LastChangeDate I_WorkCenterCapacity LastChangeDate
LastChangedByUser I_WorkCenterCapacity LastChangedByUser
WorkCenter I_WorkCenterCapacity WorkCenter
ObjectDescription
WorkCenterCategoryCode I_WorkCenterCapacity WorkCenterCategoryCode
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
Capacity I_Capacity Capacity
CapacityCategoryCode I_Capacity CapacityCategoryCode
CapacityActiveVersion I_Capacity CapacityActiveVersion
CapacityIsFinite I_Capacity CapacityIsFinite
CapacityIsPooled I_Capacity CapacityIsPooled
CapacityHasIndivCapacities I_Capacity CapacityHasIndivCapacities
CapacityIsExcldFrmLongTermPlng I_Capacity CapacityIsExcldFrmLongTermPlng
CapacityNumberOfCapacities I_Capacity CapacityNumberOfCapacities
CapacityResponsiblePlanner I_Capacity CapacityResponsiblePlanner
CapacityPlanUtilizationPercent I_Capacity CapacityPlanUtilizationPercent
CapacityBreakDuration I_Capacity CapacityBreakDuration
Plant I_Capacity Plant
FactoryCalendar I_Capacity FactoryCalendar
AuthorizationGroup I_Capacity AuthorizationGroup
ShiftGroup I_Capacity ShiftGroup
CapacityStartTimeID I_Capacity CapacityStartTimeID
CapacityEndTimeID I_Capacity CapacityEndTimeID
CapIsUsedInMultiOperations I_Capacity CapIsUsedInMultiOperations
ReferencedCapacityInternalID I_Capacity ReferencedCapacityInternalID
CapOverloadThresholdInPercent I_Capacity CapOverloadThresholdInPercent
CapacityQuantityUnit I_Capacity CapacityQuantityUnit
CapacityBaseQtyUnit I_Capacity CapacityBaseQtyUnit
CapacityText
CapacityLastChangeDateTime I_Capacity CapacityLastChangeDateTime 
@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