C_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 C_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: CRSPREREQ

CREATE VIEW C_RS_Prereq_Status AS
SELECT
  I_RS_Prereq_StatusWD.PurchasingReleaseStatus AS PurchasingReleaseStatus,
  I_RS_Prereq_StatusWD.PurchasingReleaseCode AS PurchasingReleaseCode,
  I_RS_Prereq_StatusWD.PurchasingReleaseStrategy AS PurchasingReleaseStrategy,
  I_RS_Prereq_StatusWD.ReleaseGroup AS ReleaseGroup,
  I_RS_Prereq_StatusWD.PurchasingReleaseCategory AS PurchasingReleaseCategory,
  I_RS_Prereq_StatusWD.PurchasingReleaseCodeForEdit AS PurchasingReleaseCodeForEdit,
  I_RS_Prereq_StatusWD.PurchasingReleaseStatusForEdit AS PurchasingReleaseStatusForEdit,
  PurchasingReleasePoint1,
  PurchasingReleasePoint2,
  PurchasingReleasePoint3,
  cast('' as frgct) AS PurchasingWorkflowApprover,
  I_RS_Prereq_StatusWD.ReleaseGroupForEdit AS ReleaseGroupForEdit
FROM I_PurReleaseStatusTP AS I_RS_Prereq_StatusWD
LEFT OUTER JOIN C_ReleaseStrategy AS _ReleaseStrategy ON _ReleaseStrategy.ReleaseGroup = ReleaseGroup AND _ReleaseStrategy.PurchasingReleaseStrategy = PurchasingReleaseStrategy  -- association [1..1]
LEFT OUTER JOIN C_PurReleaseCodeSrchHelp AS _PurReleaseCodeSrchHelp ON _PurReleaseCodeSrchHelp.PurchasingReleaseCode = PurchasingReleaseCodeForEdit AND _PurReleaseCodeSrchHelp.ReleaseGroup = ReleaseGroupForEdit  -- association [0..1]
LEFT OUTER JOIN I_PurReleaseCodeDesc AS _PurReleaseCodeDesc ON _PurReleaseCodeDesc.ReleaseGroup = ReleaseGroup AND _PurReleaseCodeDesc.PurchasingReleaseCode = PurchasingReleaseCode  -- association [0..*]
LEFT OUTER JOIN C_ReleaseStatusSrchHelp AS _ReleaseStatusSrchHelp ON _ReleaseStatusSrchHelp.PurchasingReleaseStatus = PurchasingReleaseStatusForEdit AND _ReleaseStatusSrchHelp.PurchasingReleaseCategory = PurchasingReleaseCategory AND _ReleaseStatusSrchHelp.ReleaseGroup = ReleaseGroupForEdit  -- association [0..1]
LEFT OUTER JOIN I_ReleaseIndicatorDesc AS _ReleaseIndicatorDesc ON _ReleaseIndicatorDesc.PurchasingReleaseStatus = PurchasingReleaseStatus AND _ReleaseIndicatorDesc.PurchasingReleaseCategory = PurchasingReleaseCategory  -- association [0..*]
LEFT OUTER JOIN C_ReleaseObjSrchHelp AS _ReleaseObjSrchHelp ON _ReleaseObjSrchHelp.PurchasingReleaseCategory = PurchasingReleaseCategory  -- association [0..1]
LEFT OUTER JOIN C_ReleaseGroupSrchHelp AS _ReleaseGroupSrchHelp ON _ReleaseGroupSrchHelp.ReleaseGroup = ReleaseGroupForEdit  -- association [0..1]
;