I_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 I_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: IPPWRKCNTRCAP

CREATE VIEW I_WorkCenterCapacity AS
SELECT
  crca.objid AS WorkCenterInternalID,
  crca.objty AS WorkCenterTypeCode,
  cast(crca.canum as pph_cr_capnum preserving type) AS CapacityCategoryAllocation,
  crca.aedat_kapa AS LastChangeDate,
  crca.aenam_kapa AS LastChangedByUser,
  _WorkCenter.Plant AS Plant,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  _WorkCenter.WorkCenterResponsible AS WorkCenterResponsible,
  crca.kapid AS CapacityInternalID,
  _Capacity.CapacityCategoryCode AS CapacityCategoryCode,
  _Capacity.Capacity AS Capacity,
  crca.fork1 AS SetupCapRequirementFormula,
  crca.fork2 AS ProcgCapRequirementFormula,
  crca.fork3 AS TeardownCapRequirementFormula,
  crca.forkn AS OtherCapRequirementFormula,
  crca.begda AS ValidityStartDate,
  crca.endda AS ValidityEndDate,
  _Capacity.CapacityQuantityUnit AS CapacityQuantityUnit
FROM crca
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON Plant = _WorkCenterBySemanticKey.Plant AND WorkCenter = _WorkCenterBySemanticKey.WorkCenter  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterTypeCode ON WorkCenterTypeCode = _WorkCenterTypeCode.WorkCenterTypeCode  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterCategory AS _WorkCenterCategory ON WorkCenterCategoryCode = _WorkCenterCategory.WorkCenterCategoryCode  -- association [1..1]
LEFT OUTER JOIN I_Capacity AS _Capacity ON CapacityInternalID = _Capacity.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN I_CapacityCategory AS _CapacityCategory ON CapacityCategoryCode = _CapacityCategory.CapacityCategoryCode  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CapacityQuantityUnit ON CapacityQuantityUnit = _CapacityQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterResponsible AS _WorkCenterResponsible ON Plant = _WorkCenterResponsible.Plant AND WorkCenterResponsible = _WorkCenterResponsible.WorkCenterResponsible  -- association [0..1]
;