I_RS_Prereq_Status

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_RS_Prereq_Status.
-- 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: IRSPREREQ

CREATE VIEW I_RS_Prereq_Status AS
SELECT
  _ReleaseStatus.frggr AS ReleaseGroup,
  _ReleaseStatus.frgsx AS PurchasingReleaseStrategy,
  _ReleasePreRequisite.frgco AS PurchasingReleaseCode,
  _ReleaseStatus.frgkx AS PurchasingReleaseStatus,
  _ReleasePreRequisite.frga1 AS PurchasingReleasePoint1,
  _ReleasePreRequisite.frga2 AS PurchasingReleasePoint2,
  _ReleasePreRequisite.frga3 AS PurchasingReleasePoint3,
  _ReleaseGroup.PurchasingReleaseCategory AS PurchasingReleaseCategory
INNER JOIN t16fk AS _ReleaseStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReleaseGroup AS _ReleaseGroup ON _ReleaseGroup.ReleaseGroup = ReleaseGroup  -- association [1..1]
LEFT OUTER JOIN I_ReleaseStrategy AS _ReleaseStrategy ON _ReleaseStrategy.PurchasingReleaseStrategy = PurchasingReleaseStrategy AND _ReleaseStrategy.ReleaseGroup = ReleaseGroup  -- association [1..1]
LEFT OUTER JOIN I_ReleaseIndicatorDesc AS _ReleaseIndicatorDesc ON _ReleaseIndicatorDesc.PurchasingReleaseCategory = PurchasingReleaseCategory  -- association [0..*]
;