I_WorkCenterCapacity_3
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
| Category | CDS Views for Basic Work Center Data |
|---|---|
| Data Category | Dimension |
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.
SAP API Hub
| Category | Composite |
|---|---|
| State | C1 |
| Line of Business | Manufacturing |
| Application Component | PP-BD-WKC-2CL |
| Capabilities | Data 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 |
| Package | Manufacturing 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
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_Capacity | Cap | from |
| I_WorkCenterCapacity | CapMap | inner |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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..*]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA