I_WorkCenterCapacityText

DDL: I_WORKCENTERCAPACITYTEXT SQL: IWRKCTRCAPTXT Type: view COMPOSITE
6 Fields 2 Data Sources

Capacity Description

I_WorkCenterCapacityText is a Composite CDS View that provides data about "Capacity Description" in SAP S/4HANA. It reads from 2 data sources (I_WorkCenterCapacity_2, I_CapacityText) and exposes 6 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, Language.

Data Sources (2)

SourceAliasJoin Type
I_WorkCenterCapacity_2 _Capacity inner
I_CapacityText _CapText from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWRKCTRCAPTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Capacity Description view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacity_2 WorkCenterInternalID Work Center
KEY WorkCenterTypeCode I_WorkCenterCapacity_2 WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation I_WorkCenterCapacity_2 CapacityCategoryAllocation
KEY CapacityInternalID I_CapacityText CapacityInternalID Capacity ID
KEY Language Language Report Text Language
CapacityText I_CapacityText CapacityText 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_WorkCenterCapacityText.
-- 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.
-- SQL view name: IWRKCTRCAPTXT

CREATE VIEW I_WorkCenterCapacityText AS
SELECT
  _Capacity.WorkCenterInternalID AS WorkCenterInternalID,
  _Capacity.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Capacity.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  _CapText.CapacityInternalID AS CapacityInternalID,
  Language,
  _CapText.CapacityText AS CapacityText
FROM I_CapacityText AS _CapText
INNER JOIN I_WorkCenterCapacity_2 AS _Capacity ON /* join condition not captured in parsed metadata */
;

Learn More