C_CapEvalWcUtilznInEvalHorzn

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_CapEvalWcUtilznInEvalHorzn.
-- 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: CCAPEVALWCUTHORZ

CREATE VIEW C_CapEvalWcUtilznInEvalHorzn AS
SELECT
  WorkCenterInternalID,
  WorkCenterTypeCode,
  CapacityCategoryAllocation,
  CapacityInternalID,
  cast('' as abap.char(12)) AS CapacityEvaluationTimePeriodWk,
  cast('' as abap.dats) AS CapacityEvaluationTimePeriod,
  cast ('' as abap.char(4)) AS ShiftName,
  WorkCenter,
  _CalcdField.WorkCenterEvaluationHorizon AS WorkCenterEvaluationHorizon,
  _CalcdField.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  _CalcdField.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  _CalcdField.OrderStatusCode AS OrderStatusCode,
  cast(0 as dec10_2) AS WorkCenterTotUtilznInTmePerd,
  cast(0 as pph_cfs_maint_util) AS WrkCtrMaintCapUtilznInPercent,
  cast(0 as dec10_2) AS WorkCenterUtilznInHours,
  cast('%' as meins) AS BaseUnit,
  '' AS WorkCenterCapUtilznValueColor,
  '' AS WorkCenterCapCumltvValueColor,
  '' AS WrkCtrMaintCapUtilznCrtyCode,
  _CalcdField.WorkCenterCumltvLoadInTmePerd AS WorkCenterCumltvLoadInTmePerd,
  _CalcdField.WorkCenterCumltvLoadInHours AS WorkCenterCumltvLoadInHours,
  _CalcdField.CurrentPlantDate AS CurrentPlantDate,
  _CalcdField.WorkCenterAvailableCapacity AS WorkCenterAvailableCapacity,
  _CalcdField.WorkCenterCapacityUnit AS WorkCenterCapacityUnit,
  _CalcdField.HorizonStartDate AS HorizonStartDate,
  _CalcdField.HorizonEndDate AS HorizonEndDate,
  _CalcdField.CapEvalStartDate AS CapEvalStartDate,
  _CalcdField.CapEvalBucketType AS CapEvalBucketType,
  _CalcdField.RemainingAvailableCapacityDurn AS RemainingAvailableCapacityDurn,
  cast(0 as pph_cfs_maint_util_hour) AS WrkCtrMaintCapUtilznInHours,
  _CalcdField.RmngAvailCapWthMaintDuration AS RmngAvailCapWthMaintDuration
FROM I_WorkCenterCapacity
LEFT OUTER JOIN P_CapEvalCalcdField AS _CalcdField ON WorkCenterInternalID = _CalcdField.WorkCenterInternalID AND WorkCenterTypeCode = _CalcdField.WorkCenterTypeCode AND CapacityCategoryAllocation = _CalcdField.CapacityCategoryAllocation AND CapacityInternalID = _CalcdField.CapacityInternalID  -- association [1..1]
;