P_CapacityHeaderDef

DDL: P_CAPACITYHEADERDEF SQL: PCAPHDRDEF Type: view COMPOSITE
15 Fields 1 Data Sources

P_CapacityHeaderDef is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Capacity) and exposes 15 fields with key field CapacityInternalID.

Data Sources (1)

SourceAliasJoin Type
I_Capacity Capacity from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCAPHDRDEF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID I_Capacity CapacityInternalID Capacity ID
Plant I_Capacity Plant Valuation Area
FactoryCalendarendasFactoryCalendar
CapacityStartTime I_Capacity CapacityStartTime Start Time
CapacityEndTime I_Capacity CapacityEndTime End Time
CapacityNumberOfCapacities I_Capacity CapacityNumberOfCapacities Number
CapacityPlanUtilizationPercent I_Capacity CapacityPlanUtilizationPercent Utilization
CapacityBreakDuration I_Capacity CapacityBreakDuration Break Length
CapacityCategoryCode I_Capacity CapacityCategoryCode
CapacityCategoryName
Capacity I_Capacity Capacity Engine Capacity
CapacityResponsiblePlanner I_Capacity CapacityResponsiblePlanner Plng Segmnt No.
ShiftGroup I_Capacity ShiftGroup Shift Grouping
CapacityActiveVersion I_Capacity CapacityActiveVersion RA Version
CapacityIsPooled I_Capacity CapacityIsPooled Pooled Capacity

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 P_CapacityHeaderDef.
-- 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: PCAPHDRDEF

CREATE VIEW P_CapacityHeaderDef AS
SELECT
  Capacity.CapacityInternalID AS CapacityInternalID,
  Capacity.Plant AS Plant,
  case when Capacity.FactoryCalendar = '' then Capacity._Plant.FactoryCalendar when Capacity.FactoryCalendar <> '' then Capacity.FactoryCalendar end as FactoryCalendar AS FactoryCalendarendasFactoryCalendar,
  Capacity.CapacityStartTime AS CapacityStartTime,
  Capacity.CapacityEndTime AS CapacityEndTime,
  Capacity.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  Capacity.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  Capacity.CapacityBreakDuration AS CapacityBreakDuration,
  Capacity.CapacityCategoryCode AS CapacityCategoryCode,
  Capacity._CapacityCategory._Text[1:Language=$session.system_language].CapacityCategoryName AS CapacityCategoryName,
  Capacity.Capacity AS Capacity,
  Capacity.CapacityResponsiblePlanner AS CapacityResponsiblePlanner,
  Capacity.ShiftGroup AS ShiftGroup,
  Capacity.CapacityActiveVersion AS CapacityActiveVersion,
  Capacity.CapacityIsPooled AS CapacityIsPooled
FROM I_Capacity AS Capacity
;

Learn More