A_WorkCenterAllCapacity

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 A_WorkCenterAllCapacity.
-- 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.

CREATE VIEW A_WorkCenterAllCapacity AS
SELECT
  WorkCenterCapacity.WorkCenterInternalID AS WorkCenterInternalID,
  WorkCenterCapacity.WorkCenterTypeCode AS WorkCenterTypeCode,
  WorkCenterCapacity.CapacityInternalID AS CapacityInternalID,
  WorkCenterCapacity.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WorkCenterCapacity.WorkCenter AS WorkCenter,
  WorkCenterCapacity.WorkCenterDesc AS WorkCenterDesc,
  WorkCenterCapacity.Plant AS Plant,
  WorkCenterCapacity.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WorkCenterCapacity.WorkCenterResponsible AS WorkCenterResponsible,
  WorkCenterCapacity.SupplyArea AS SupplyArea,
  WorkCenterCapacity.WorkCenterUsage AS WorkCenterUsage,
  _WorkCenterResponsible.WorkCenterResponsibleName AS WorkCenterResponsibleName,
  WorkCenterCapacity.CapacityCategoryCode AS CapacityCategoryCode
FROM I_WorkCenterAllCapacity AS WorkCenterCapacity
LEFT OUTER JOIN A_WorkCenterCapDayOp AS _WorkCenterTodayOp ON WorkCenterInternalID = _WorkCenterTodayOp.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN A_WorkCenterCapPplineOp AS _WorkCenterQueuingOp ON WorkCenterInternalID = _WorkCenterQueuingOp.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN A_WorkCenterResponsible AS _WorkCenterResponsible ON Plant = _WorkCenterResponsible.Plant AND WorkCenterResponsible = _WorkCenterResponsible.WorkCenterResponsible  -- association [0..1]
LEFT OUTER JOIN A_WorkCenterCapacityInterval AS _WorkCenterInterval ON WorkCenterInternalID = _WorkCenterInterval.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterInterval.WorkCenterTypeCode AND CapacityInternalID = _WorkCenterInterval.CapacityInternalID AND CapacityCategoryAllocation = _WorkCenterInterval.CapacityCategoryAllocation  -- association [1..*]
;