I_WorkCenterCapacity_3

DDL: I_WORKCENTERCAPACITY_3 Type: view_entity COMPOSITE Package: ODATA_PP_WORKCENTER_API

Work Center Capacity

I_WorkCenterCapacity_3 (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

WorkCenterCapacity · Manufacturing

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

SAP Help Documentation

CategoryCDS Views for Basic Work Center Data
Data CategoryDimension
Purpose
This CDS view is designed to provide a comprehensive overview of work center capacities within an organization. It integrates data from various sources to offer insights into the capacity attributes, assignments, and associated details of work centers. The view is structured to support analytical dimensions and data extraction, making it suitable for reporting and analysis purposes. This CDS view provides the data to answer the following business questions: What are the capacity attributes and requirements for each work center within the organization? How is the capacity allocated across different work centers and what are the associated formulas for setup, processing, and tear down? What are the validity periods for the capacity allocations in each work center? Who is responsible for planning and managing the capacities in the work centers? What are the start and end times for the capacities, and how are they utilized in multi-operations? What are the unit measures used for capacity quantities and how are they defined? How are work centers categorized and what are their types and internal IDs? What are the last change dates and users associated with the capacity allocations and work centers? How is the capacity planned in terms of utilization percentage and overload thresholds? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: C_KAPA_PLA - CIM: Capacity planning These restriction types are edited in the Maintain Business Roles app.

Structure
Important Fields Important fields in this view include the following: Field Name Description WorkCenterInternalID Object ID WorkCenterTypeCode Object Type CapacityCategoryAllocation Capacity Allocation CapacityInternalID Capacity ID LastChangeDate Changed on LastChangedByUser User Name WorkCenter Work Center WorkCenterCategoryCode Work Center Category SetupCapRequirementFormula Setup Formula ProcgCapRequirementFormula Processing Formula TeardownCapRequirementFormula Teardown Formula OtherCapRequirementFormula Other Formula ValidityStartDate Start date ValidityEndDate End Date WorkCenterLastChangeDateTime Date and Time of Last Change Capacity Capacity CapacityCategoryCode Capacity Category CapacityActiveVersion Active Version CapacityIsFinite Finite Scheduling CapacityIsPooled Pooled Capacity CapacityHasIndivCapacities Individ. Capacities CapacityIsExcldFrmLongTermPlng No LongTerm Planning CapacityNumberOfCapacities No. Ind. Capacities CapacityResponsiblePlanner Capacity Planner CapacityPlanUtilizationPercent Capacity Utilization CapacityBreakDuration Break Duration Plant Plant FactoryCalendar Factory Calendar AuthorizationGroup Authorization ShiftGroup Shift Grouping CapacityStartTimeID Start Time in Seconds CapacityEndTimeID End Time in Seconds CapIsUsedInMultiOperations Can Be Used By Several Operations ReferencedCapacityInternalID Referenced Capacity ID CapOverloadThresholdInPercent Overload (%) CapacityQuantityUnit Capacity Unit CapacityBaseQtyUnit Capacity Base Unit CapacityLastChangeDateTime Capacity Last Change Date Time

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessManufacturing
Application ComponentPP-BD-WKC-2CL
CapabilitiesData Source for Data Extraction,Analytical Dimension,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageManufacturing for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view is designed to provide a comprehensive overview of work center capacities within an organization. It integrates data from various sources to offer insights into the capacity attributes, assignments, and associated details of work centers. The view is structured to support analytical dimensions and data extraction, making it suitable for reporting and analysis purposes.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the capacity attributes and requirements for each work center within the organization?</p></li> <li><p>How is the capacity allocated across different work centers and what are the associated formulas for setup, processing, and tear down?</p></li> <li><p>What are the validity periods for the capacity allocations in each work center? </p></li> <li><p>Who is responsible for planning and managing the capacities in the work centers?</p></li> <li><p>What are the start and end times for the capacities, and how are they utilized in multi-operations?</p></li> <li><p>What are the unit measures used for capacity quantities and how are they defined?</p></li> <li><p>How are work centers categorized and what are their types and internal IDs?</p></li> <li><p>What are the last change dates and users associated with the capacity allocations and work centers?</p></li> <li><p>How is the capacity planned in terms of utilization percentage and overload thresholds?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (2)

SourceAliasJoin Type
I_Capacity Cap from
I_WorkCenterCapacity CapMap inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_WorkCenterCapacity _WorkCenterCapMap $projection.WorkCenterInternalID = _WorkCenterCapMap.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenterCapMap.WorkCenterTypeCode and $projection.CapacityCategoryAllocation = _WorkCenterCapMap.CapacityCategoryAllocation
[1..*] I_WorkCenterCapacityText_2 _Text $projection.WorkCenterInternalID = _Text.WorkCenterInternalID and $projection.WorkCenterTypeCode = _Text.WorkCenterTypeCode and $projection.CapacityCategoryAllocation = _Text.CapacityCategoryAllocation and $projection.CapacityInternalID = _Text.CapacityInternalID

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY 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
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.representativeKey CapacityInternalID view
ObjectModel.sapObjectNodeType.name WorkCenterCapacity view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacity WorkCenterInternalID Object ID of the resource
KEY WorkCenterTypeCode I_WorkCenterCapacity WorkCenterTypeCode Object types of the CIM resource
KEY CapacityCategoryAllocation I_WorkCenterCapacity CapacityCategoryAllocation Capacity Category Allocation
KEY CapacityInternalID I_Capacity CapacityInternalID Capacity ID
LastChangeDate I_WorkCenterCapacity LastChangeDate Time Stamp
LastChangedByUser I_WorkCenterCapacity LastChangedByUser User Name
WorkCenter I_WorkCenterCapacity WorkCenter Work Center
WorkCenterCategoryCode I_WorkCenterCapacity WorkCenterCategoryCode Work Center Category
SetupCapRequirementFormula I_WorkCenterCapacity SetupCapRequirementFormula Formula for Setup Capacity Requirements
ProcgCapRequirementFormula I_WorkCenterCapacity ProcgCapRequirementFormula Formula for Processing Capacity Requirements
TeardownCapRequirementFormula I_WorkCenterCapacity TeardownCapRequirementFormula Formula for Teardown Capacity Requirements
OtherCapRequirementFormula I_WorkCenterCapacity OtherCapRequirementFormula Formula for Other Capacity Requirements
ValidityStartDate I_WorkCenterCapacity ValidityStartDate Validity Start Date
ValidityEndDate I_WorkCenterCapacity ValidityEndDate End Date
WorkCenterLastChangeDateTime I_WorkCenterCapacity WorkCenterLastChangeDateTime Date and Time of Last Change
Capacity I_Capacity Capacity Engine Capacity
CapacityCategoryCode I_Capacity CapacityCategoryCode Capacity Category
CapacityActiveVersion I_Capacity CapacityActiveVersion Active Version of Available Capacity
CapacityIsFinite I_Capacity CapacityIsFinite Indicator: Capacity Relevant to Finite Scheduling
CapacityIsPooled I_Capacity CapacityIsPooled Pooled Capacity Indicator
CapacityHasIndivCapacities I_Capacity CapacityHasIndivCapacities Has Individual Capacities
CapacityIsExcldFrmLongTermPlng I_Capacity CapacityIsExcldFrmLongTermPlng Indicator: Capacity Excluded From Long-Term Planning
CapacityNumberOfCapacities I_Capacity CapacityNumberOfCapacities Number of Individual Capacities
CapacityResponsiblePlanner I_Capacity CapacityResponsiblePlanner Capacity Responsible Planner Group
CapacityPlanUtilizationPercent I_Capacity CapacityPlanUtilizationPercent Capacity Utilization Ratio in Percent
CapacityBreakDuration I_Capacity CapacityBreakDuration Cumulative Break Duration in Seconds (internal)
Plant I_Capacity Plant Valuation Area
FactoryCalendar I_Capacity FactoryCalendar Factory Calendar ID
AuthorizationGroup I_Capacity AuthorizationGroup Authorization Group
ShiftGroup I_Capacity ShiftGroup Grouping for Shift Definitions and Shift Sequences
CapacityStartTimeID I_Capacity CapacityStartTimeID Start Time in Seconds (Internal)
CapacityEndTimeID I_Capacity CapacityEndTimeID End Time in Seconds (Internal)
CapIsUsedInMultiOperations I_Capacity CapIsUsedInMultiOperations Indicator: Several Operations Can Use Capacity
ReferencedCapacityInternalID I_Capacity ReferencedCapacityInternalID Referenced Capacity ID
CapOverloadThresholdInPercent I_Capacity CapOverloadThresholdInPercent Overload (%)
CapacityQuantityUnit I_Capacity CapacityQuantityUnit Capacity Unit of Measure
CapacityBaseQtyUnit I_Capacity CapacityBaseQtyUnit Capacity Base Unit of Measure
CapacityLastChangeDateTime I_Capacity CapacityLastChangeDateTime Capacity Last Change Date Time
_WorkCenter I_WorkCenterCapacity _WorkCenter
_WorkCenterTypeCode I_WorkCenterCapacity _WorkCenterTypeCode
_WorkCenterCapMap _WorkCenterCapMap
_Text _Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_WorkCenterCapacity_3.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_WorkCenterCapacity_3 AS
SELECT
  CapMap.WorkCenterInternalID AS WorkCenterInternalID,
  CapMap.WorkCenterTypeCode AS WorkCenterTypeCode,
  CapMap.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  Cap.CapacityInternalID AS CapacityInternalID,
  CapMap.LastChangeDate AS LastChangeDate,
  CapMap.LastChangedByUser AS LastChangedByUser,
  CapMap.WorkCenter AS WorkCenter,
  CapMap.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  CapMap.SetupCapRequirementFormula AS SetupCapRequirementFormula,
  CapMap.ProcgCapRequirementFormula AS ProcgCapRequirementFormula,
  CapMap.TeardownCapRequirementFormula AS TeardownCapRequirementFormula,
  CapMap.OtherCapRequirementFormula AS OtherCapRequirementFormula,
  CapMap.ValidityStartDate AS ValidityStartDate,
  CapMap.ValidityEndDate AS ValidityEndDate,
  CapMap.WorkCenterLastChangeDateTime AS WorkCenterLastChangeDateTime,
  Cap.Capacity AS Capacity,
  Cap.CapacityCategoryCode AS CapacityCategoryCode,
  Cap.CapacityActiveVersion AS CapacityActiveVersion,
  Cap.CapacityIsFinite AS CapacityIsFinite,
  Cap.CapacityIsPooled AS CapacityIsPooled,
  Cap.CapacityHasIndivCapacities AS CapacityHasIndivCapacities,
  Cap.CapacityIsExcldFrmLongTermPlng AS CapacityIsExcldFrmLongTermPlng,
  Cap.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  Cap.CapacityResponsiblePlanner AS CapacityResponsiblePlanner,
  Cap.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  Cap.CapacityBreakDuration AS CapacityBreakDuration,
  Cap.Plant AS Plant,
  Cap.FactoryCalendar AS FactoryCalendar,
  Cap.AuthorizationGroup AS AuthorizationGroup,
  Cap.ShiftGroup AS ShiftGroup,
  Cap.CapacityStartTimeID AS CapacityStartTimeID,
  Cap.CapacityEndTimeID AS CapacityEndTimeID,
  Cap.CapIsUsedInMultiOperations AS CapIsUsedInMultiOperations,
  Cap.ReferencedCapacityInternalID AS ReferencedCapacityInternalID,
  Cap.CapOverloadThresholdInPercent AS CapOverloadThresholdInPercent,
  Cap.CapacityQuantityUnit AS CapacityQuantityUnit,
  Cap.CapacityBaseQtyUnit AS CapacityBaseQtyUnit,
  Cap.CapacityLastChangeDateTime AS CapacityLastChangeDateTime,
  CapMap._WorkCenter AS _WorkCenter,
  CapMap._WorkCenterTypeCode AS _WorkCenterTypeCode
FROM I_Capacity AS Cap
INNER JOIN I_WorkCenterCapacity AS CapMap ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenterCapacity AS _WorkCenterCapMap ON WorkCenterInternalID = _WorkCenterCapMap.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterCapMap.WorkCenterTypeCode AND CapacityCategoryAllocation = _WorkCenterCapMap.CapacityCategoryAllocation  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterCapacityText_2 AS _Text ON WorkCenterInternalID = _Text.WorkCenterInternalID AND WorkCenterTypeCode = _Text.WorkCenterTypeCode AND CapacityCategoryAllocation = _Text.CapacityCategoryAllocation AND CapacityInternalID = _Text.CapacityInternalID  -- association [1..*]
;