C_CapEvalWorkCenterOverView

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 C_CapEvalWorkCenterOverView.
-- 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: CCAPEVALWCOVW
-- Parameters: P_WorkCenterEvaluationHorizon : char4

CREATE VIEW C_CapEvalWorkCenterOverView AS
SELECT
  WorkCenterInternalID,
  CapacityInternalID,
  WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  cast(' ' as abap.char(40)) AS CapacityCategoryName,
  cast('%' as meins) AS BaseUnit,
  cast(0 as abap.dec(10,2)) AS WorkCenterMaxUtilznInTimePerd,
  cast(' ' as abap.char(12)) AS WorkCenterCapFirstOverLoadDte,
  cast(0 as abap.dec(10,2)) AS WorkCenterCapacityBacklogInHrs,
  cast(0 as abap.dec(10,2)) AS WorkCenterTotCapInTimePeriod,
  cast(' ' as abap.sstring(40)) AS Capacity,
  cast(0 as abap.dec(10,2) ) AS WorkCenterMinUtilznInTmePeriod,
  cast(' ' as abap.char(12)) AS WorkCenterCapFirstCritlLoadDte,
  cast(0 as abap.dec(10,2)) AS WorkCenterAvgUtilznInTimePerd,
  cast(0 as abap.dec(10,2)) AS WorkCenterTotAvailCapInTmePerd,
  cast(0 as abap.dec(10,2)) AS WorkCenterTotUtilznInTmePerd,
  cast(' ' as abap.numc(2)) AS CapacityEvaluationTimePeriod,
  cast(' ' as meins) AS WorkCenterCapacityUnit,
  cast(' ' as meins) AS WorkCenterCapUnitText,
  cast(0 as abap.dec(10,2)) AS WorkCenterAvailableCapacity,
  cast(0 as abap.dec(10,2)) AS WorkCenterCapacityRequirement,
  cast(' ' as abap.char(3)) AS CapacityCategoryCode,
  WorkCenter,
  WorkCenterResponsible,
  WorkCenter._Capacity.CapacityResponsiblePlanner AS CapacityResponsiblePlanner,
  cast(' ' as domvalue_l) AS CapacityRequirementOrigin,
  cast(' ' as domvalue_l) AS OperationPlanningStatusCode,
  cast(' ' as j_txt04) AS OrderStatusCode,
  cast(0 as abap.int1) AS Criticality
FROM I_WorkCenter AS WorkCenter
LEFT OUTER JOIN C_CapEvalWcUtilznInEvalHorzn AS _WorkCenterUtilization ON WorkCenterInternalID = _WorkCenterUtilization.WorkCenterInternalID AND CapacityInternalID = _WorkCenterUtilization.CapacityInternalID  -- association [1..*]
;