C_MfgQualifnCertWrkCtrAssgmt

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_MfgQualifnCertWrkCtrAssgmt.
-- 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: CMFGCERTWC

CREATE VIEW C_MfgQualifnCertWrkCtrAssgmt AS
SELECT
  WorkCenter.MfgQualifnCertificate AS MfgQualifnCertificate,
  WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  WorkCenter.WorkCenterTypeCode AS WorkCenterTypeCode,
  WorkCenter.WorkCenter AS WorkCenter,
  WorkCenter.Plant AS Plant,
  _WorkCenter.Plant AS WorkCenterPlant,
  _WorkCenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  _WorkCenter.WorkCenterUsage AS WorkCenterUsage,
  _WorkCenter.SupplyArea AS SupplyArea,
  _WorkCenter.WorkCenterLocation AS WorkCenterLocation,
  WorkCenter.MfgQualifnRequiredSkillLevel AS MfgQualifnRequiredSkillLevel,
  WorkCenter.ValidityStartDate AS ValidityStartDate,
  WorkCenter.ValidityEndDate AS ValidityEndDate,
  _WorkCenter._WorkCenterCategory AS _WorkCenterCategory,
  _WorkCenter._WorkCenterUsage AS _WorkCenterUsage
FROM I_MfgQualifnCertWrkCtrAssgmtTP AS WorkCenter
LEFT OUTER JOIN C_MfgQualifnCertificate AS _Certificate ON MfgQualifnCertificate = _Certificate.MfgQualifnCertificate  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN C_MfgWorkCenterVH AS _WorkCenterVH ON WorkCenter = _WorkCenterVH.WorkCenter AND Plant = _WorkCenterVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _SupplyArea ON supplyarea = _SupplyArea.ProductionSupplyArea AND Plant = _SupplyArea.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterLocation AS _WorkCenterLocation ON Plant = _WorkCenterLocation.WorkCenterPlant AND workcenterlocation = _WorkCenterLocation.WorkCenterLocation  -- association [1..1]
;