I_CmplRqVersionOverview

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_CmplRqVersionOverview.
-- 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: CMPLRQVERSOV

CREATE VIEW I_CmplRqVersionOverview AS
SELECT
  _CmplRqVers.CmplRqVersUUID AS CmplRqVersUUID,
  _CmplRqVers.CmplRqUUID AS CmplRqUUID,
  _CmplRqVers.CmplRqVersName AS CmplRqVersName,
  _CmplRqVers.EffectiveDate AS EffectiveDate,
  _CmplRqVers.CmplRqVersMaintStatus AS CmplRqVersMaintStatus,
  _CmplRqVersActvtn.ChmlCompositionType AS ChmlCompositionType,
  _CmplRqVersActvtn.CmplRqVersActivationDate AS CmplRqVersActivationDate,
  _CmplRqVersActvtn.CmplRqVersDeactivationDate AS CmplRqVersDeactivationDate,
  _SVTDetails.SVTProductionScenario AS SVTProductionScenario,
  _SVTDetails.SVTSalesScenario AS SVTSalesScenario,
  _SVTDetails.SVTPurchasingScenario AS SVTPurchasingScenario,
  _CmplRqVersActvtn.CmplRqDomain AS CmplRqDomain,
  _CmplRqVers._CmplncRqmtStatus AS _CmplncRqmtStatus
FROM I_CmplRqVersEnhanced AS _CmplRqVers
LEFT OUTER JOIN I_CmplRqmtVersionSVTScenario AS _SVTDetails ON CmplRqVersUUID = _SVTDetails.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqVersActvtn AS _CmplRqVersActvtn ON CmplRqVersUUID = _CmplRqVersActvtn.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqVersActvtnStatusTxt AS _CmplRqVersActvtnStatusTxt ON CmplRqVersActivationStatus = _CmplRqVersActvtnStatusTxt.CmplRqVersActivationStatus AND _CmplRqVersActvtnStatusTxt.Language = $session.system_language  -- association [1..1]
;