P_RSHWCHeaderCapacityDefinitio

DDL: P_RSHWCHEADERCAPACITYDEFINITIO SQL: PRSHWCHEADCAPDEF Type: view CONSUMPTION
14 Fields 2 Data Sources

P_RSHWCHeaderCapacityDefinitio is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_Capacity, I_RSHAssignedWorkCenters) and exposes 14 fields with key field CapacityInternalID.

Data Sources (2)

SourceAliasJoin Type
I_Capacity Capacity from
I_RSHAssignedWorkCenters user_var inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PRSHWCHEADCAPDEF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID I_Capacity CapacityInternalID Capacity ID
WorkCenterInternalID I_RSHAssignedWorkCenters WorkCenterInternalID Work Center
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
WorkCenter I_RSHAssignedWorkCenters WorkCenter Work Center
WorkCenterCategoryCode I_RSHAssignedWorkCenters WorkCenterCategoryCode
WorkCenterTypeCode I_RSHAssignedWorkCenters WorkCenterTypeCode Object Type
Plant I_Capacity Plant Valuation Area
FactoryCalendarendasFactoryCalendar
ShiftGroup I_Capacity ShiftGroup Shift Grouping
CapacityActiveVersion I_Capacity CapacityActiveVersion RA Version

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_RSHWCHeaderCapacityDefinitio.
-- 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: PRSHWCHEADCAPDEF

CREATE VIEW P_RSHWCHeaderCapacityDefinitio AS
SELECT
  Capacity.CapacityInternalID AS CapacityInternalID,
  user_var.WorkCenterInternalID AS WorkCenterInternalID,
  Capacity.CapacityStartTime AS CapacityStartTime,
  Capacity.CapacityEndTime AS CapacityEndTime,
  Capacity.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  Capacity.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  Capacity.CapacityBreakDuration AS CapacityBreakDuration,
  user_var.WorkCenter AS WorkCenter,
  user_var.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  user_var.WorkCenterTypeCode AS WorkCenterTypeCode,
  Capacity.Plant AS Plant,
  case when Capacity.FactoryCalendar = '' then Capacity._Plant.FactoryCalendar else Capacity.FactoryCalendar end as FactoryCalendar AS FactoryCalendarendasFactoryCalendar,
  Capacity.ShiftGroup AS ShiftGroup,
  Capacity.CapacityActiveVersion AS CapacityActiveVersion
FROM I_Capacity AS Capacity
INNER JOIN I_RSHAssignedWorkCenters AS user_var ON /* join condition not captured in parsed metadata */
;

Learn More