I_ReleaseStrategy

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_ReleaseStrategy.
-- 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: IPURRELSTRAT

CREATE VIEW I_ReleaseStrategy AS
SELECT
  frgsx AS PurchasingReleaseStrategy,
  _ReleaseStrategy.frggr AS ReleaseGroup,
  frgkl AS PurchasingReleaseClass,
  frgot AS PurchasingReleaseCategory,
  _ReleaseStrategyDesc.PurchasingReleaseStrategyDesc AS PurchasingReleaseStrategyDesc
FROM t16fs AS _ReleaseStrategy
INNER JOIN t16fg AS _ReleaseGroup 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_PurReleaseCode AS _ReleaseCode ON _ReleaseCode.ReleaseGroup = ReleaseGroup  -- association [1..*]
LEFT OUTER JOIN I_RS_Prereq_Status AS _RS_Prereq_Status ON _RS_Prereq_Status.ReleaseGroup = ReleaseGroup AND _RS_Prereq_Status.PurchasingReleaseStrategy = PurchasingReleaseStrategy  -- association [0..*]
LEFT OUTER JOIN I_PurgRelStrategyCharc AS _PurgRelStrategyCharc ON _PurgRelStrategyCharc.ReleaseGroup = ReleaseGroup AND _PurgRelStrategyCharc.PurchasingReleaseStrategy = PurchasingReleaseStrategy  -- association [0..*]
LEFT OUTER JOIN I_ReleaseStrategyDesc AS _ReleaseStrategyDesc ON _ReleaseStrategyDesc.ReleaseGroup = ReleaseGroup AND _ReleaseStrategyDesc.PurchasingReleaseStrategy = PurchasingReleaseStrategy  -- association [0..*]
LEFT OUTER JOIN I_ReleaseGroupDesc AS _ReleaseGroupDesc ON _ReleaseGroupDesc.ReleaseGroup = ReleaseGroup  -- association [1..*]
;