I_CapacityBySemanticKey

DDL: I_CAPACITYBYSEMANTICKEY SQL: ICAPABYSEMKEY Type: view_entity BASIC
35 Fields 1 Data Sources 2 Associations

Capacity Header by Semantic Key

I_CapacityBySemanticKey is a Basic CDS View (Dimension) that provides data about "Capacity Header by Semantic Key" in SAP S/4HANA. It reads from 1 data source (I_Capacity) and exposes 35 fields with key fields Plant, Capacity. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Capacity kako from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Capacity _Capacity $projection.CapacityInternalID = _Capacity.CapacityInternalID
[0..1] I_Capacity _ReferencedCapacity $projection.ReferencedCapacityInternalID = _ReferencedCapacity.CapacityInternalID

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey Capacity view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Capacity Header by Semantic Key view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY Plant I_Capacity Plant Valuation Area
KEY Capacity I_Capacity Capacity Engine Capacity
CapacityInternalID I_Capacity CapacityInternalID Capacity ID
CapacityCategoryCode I_Capacity CapacityCategoryCode
CapacityActiveVersion I_Capacity CapacityActiveVersion RA Version
CapacityIsFinite I_Capacity CapacityIsFinite Finite Scheduling
CapacityIsPooled I_Capacity CapacityIsPooled Pooled Capacity
CapacityHasIndivCapacities I_Capacity CapacityHasIndivCapacities Individ. Capacities
CapacityIsExcldFrmLongTermPlng I_Capacity CapacityIsExcldFrmLongTermPlng No LongTerm Planning
CapacityNumberOfCapacities I_Capacity CapacityNumberOfCapacities Number
CapacityResponsiblePlanner I_Capacity CapacityResponsiblePlanner Plng Segmnt No.
CapacityPlanUtilizationPercent I_Capacity CapacityPlanUtilizationPercent Utilization
CapacityBreakDuration I_Capacity CapacityBreakDuration Break Length
CapIsUsedInMultiOperations I_Capacity CapIsUsedInMultiOperations
ReferencedCapacityInternalID I_Capacity ReferencedCapacityInternalID
CapOverloadThresholdInPercent I_Capacity CapOverloadThresholdInPercent Overload (%)
FactoryCalendar I_Capacity FactoryCalendar Factory Calendar
AuthorizationGroup
ShiftGroup I_Capacity ShiftGroup Shift Grouping
CapacityStartTime
CapacityEndTime
CapacityQuantityUnit I_Capacity CapacityQuantityUnit Capacity Unit
CapacityBaseQtyUnit I_Capacity CapacityBaseQtyUnit Valuation Unit
CapacityLastChangeDateTime I_Capacity CapacityLastChangeDateTime
_Plant _Plant
_Capacity _Capacity
_CapacityCategory _CapacityCategory
_FactoryCalendar _FactoryCalendar
_CapacityResponsiblePlanner _CapacityResponsiblePlanner
_ShiftGrouping _ShiftGrouping
_CapacityQuantityUnit _CapacityQuantityUnit
_CapacityBaseQtyUnit _CapacityBaseQtyUnit
_ReferencedCapacity _ReferencedCapacity
_Text _Text
_ReferencedCapacityText _ReferencedCapacityText

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_CapacityBySemanticKey.
-- 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: ICAPABYSEMKEY

CREATE VIEW I_CapacityBySemanticKey AS
SELECT
  kako.Plant AS Plant,
  kako.Capacity AS Capacity,
  kako.CapacityInternalID AS CapacityInternalID,
  kako.CapacityCategoryCode AS CapacityCategoryCode,
  kako.CapacityActiveVersion AS CapacityActiveVersion,
  kako.CapacityIsFinite AS CapacityIsFinite,
  kako.CapacityIsPooled AS CapacityIsPooled,
  kako.CapacityHasIndivCapacities AS CapacityHasIndivCapacities,
  kako.CapacityIsExcldFrmLongTermPlng AS CapacityIsExcldFrmLongTermPlng,
  kako.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  kako.CapacityResponsiblePlanner AS CapacityResponsiblePlanner,
  kako.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  kako.CapacityBreakDuration AS CapacityBreakDuration,
  kako.CapIsUsedInMultiOperations AS CapIsUsedInMultiOperations,
  kako.ReferencedCapacityInternalID AS ReferencedCapacityInternalID,
  kako.CapOverloadThresholdInPercent AS CapOverloadThresholdInPercent,
  kako.FactoryCalendar AS FactoryCalendar,
  kako.ShiftGroup AS ShiftGroup,
  kako.CapacityQuantityUnit AS CapacityQuantityUnit,
  kako.CapacityBaseQtyUnit AS CapacityBaseQtyUnit,
  kako.CapacityLastChangeDateTime AS CapacityLastChangeDateTime
FROM I_Capacity AS kako
LEFT OUTER JOIN I_Capacity AS _Capacity ON CapacityInternalID = _Capacity.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN I_Capacity AS _ReferencedCapacity ON ReferencedCapacityInternalID = _ReferencedCapacity.CapacityInternalID  -- association [0..1]
;

Learn More