I_ReviewBookletPage

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_ReviewBookletPage.
-- 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.

CREATE VIEW I_ReviewBookletPage AS
SELECT
  ReviewBookletPage.reviewbooklet AS ReviewBooklet,
  ReviewBookletPage.reviewbookletpage AS ReviewBookletPage,
  ReviewBookletPage.reviewbookletparentpage AS ReviewBookletParentPage,
  ReviewBookletPage.reviewbookletpagebusinessstyle AS ReviewBookletPageBusinessStyle,
  _ReviewBookletPageBusStyleText[1:Language=$session.system_language].ReviewBookletPageBusStyleName AS ReviewBookletPageBusStyleName,
  ReviewBookletPage.reviewbookletpageposition AS ReviewBookletPagePosition,
  ReviewBookletPage.reviewbookletuipattern AS ReviewBookletPageUIPattern,
  _ReviewBookletUIPatternText[1:Language=$session.system_language].ReviewBookletPageUIPatternName AS ReviewBookletPageUIPatternName,
  ReviewBookletPage.reviewbookletpageisvisible AS ReviewBookletPageIsVisible,
  ReviewBookletPage.reviewbookletpagehierarchylvl AS ReviewBookletPageHierarchyLvl,
  ReviewBookletPage.reviewbookletpageisdefault AS ReviewBookletPageIsDefault,
  ReviewBookletPage.reviewbookletpagelayout AS ReviewBookletPageLayout,
  ReviewBookletPage.revbookletelmntconstcystatus AS RevBookletElmntConstcyStatus
FROM rvb_page AS ReviewBookletPage
INNER JOIN rvb_def_c AS Scope ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReviewBookletBusStyleText AS _ReviewBookletPageBusStyleText ON _ReviewBookletPageBusStyleText.ReviewBookletPageBusinessStyle = ReviewBookletPageBusinessStyle  -- association [0..*]
LEFT OUTER JOIN I_ReviewBookletUIPatternText AS _ReviewBookletUIPatternText ON _ReviewBookletUIPatternText.ReviewBookletPageUIPattern = ReviewBookletPageUIPattern  -- association [0..*]
LEFT OUTER JOIN I_ReviewBookletColumnSetSel AS _ReviewBookletColumnSetSel ON _ReviewBookletColumnSetSel.ReviewBooklet = ReviewBooklet AND _ReviewBookletColumnSetSel.ReviewBookletPage = ReviewBookletPage  -- association [0..*]
LEFT OUTER JOIN I_ReviewBookletRowSetSelection AS _ReviewBookletRowSetSel ON _ReviewBookletRowSetSel.ReviewBooklet = ReviewBooklet AND _ReviewBookletRowSetSel.ReviewBookletPage = ReviewBookletPage  -- association [0..*]
LEFT OUTER JOIN I_ReviewBookletFilterDimnSel AS _ReviewBookletFilterDimnSel ON _ReviewBookletFilterDimnSel.ReviewBooklet = ReviewBooklet AND _ReviewBookletFilterDimnSel.ReviewBookletPage = ReviewBookletPage  -- association [0..*]
LEFT OUTER JOIN I_ReviewBookletPageContent AS _ReviewBookletPageContent ON /* condition not available in parsed metadata */  -- association [1..*]
;