A_WorkCenterCapacity

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_WorkCenterCapacity.
-- 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: AWRKCTRCAP

CREATE VIEW A_WorkCenterCapacity AS
SELECT
  CapacityInternalID,
  Capacity,
  CapacityCategoryCode,
  CapacityActiveVersion,
  CapacityIsFinite,
  CapacityIsPooled,
  CapacityHasIndivCapacities,
  CapacityIsExcldFrmLongTermPlng,
  CapacityNumberOfCapacities,
  CapacityResponsiblePlanner,
  CapacityPlanUtilizationPercent,
  CapacityBreakDuration,
  Plant,
  FactoryCalendar,
  AuthorizationGroup,
  ShiftGroup,
  CapacityStartTime,
  CapacityEndTime,
  CapIsUsedInMultiOperations,
  ReferencedCapacityInternalID,
  CapOverloadThresholdInPercent,
  CapacityQuantityUnit,
  CapacityBaseQtyUnit,
  CapacityLastChangeDateTime
FROM I_Capacity
LEFT OUTER JOIN A_WorkCenterCapacityText AS _CapacityText ON CapacityInternalID = _CapacityText.CapacityInternalID  -- association [1..*]
LEFT OUTER JOIN A_WorkCenterCapacityInterval_2 AS _CapacityInterval ON CapacityInternalID = _CapacityInterval.CapacityInternalID AND CapacityActiveVersion = _CapacityInterval.CapacityActiveVersion  -- association [1..*]
;