I_CustomCDSViewRoot

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_CustomCDSViewRoot.
-- 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: APS_CCV_I_ROOT_V

CREATE VIEW I_CustomCDSViewRoot AS
SELECT
  entity_name,
  scenario,
  view_name,
  type,
  entity_label,
  filter,
  migrated_ind,
  crea_uname,
  lchg_uname
FROM aps_ccv_d_root
LEFT OUTER JOIN I_CustomCDSViewDataSource AS _Datasource ON _Datasource.entity_name = entity_name  -- association [0..*]
LEFT OUTER JOIN I_CustomCDSViewFilter AS _Filter ON _Filter.entity_name = entity_name  -- association [0..*]
LEFT OUTER JOIN I_CustomCDSViewScenario AS _Scenario ON _Scenario.scenario = scenario  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewAuthCheck AS _AuthorizationCheck ON _AuthorizationCheck.AuthorizationCheck = authorization_check  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewLogicalLinkOp AS _LogicalLinkOperator ON _LogicalLinkOperator.LogicalLinkOperator = filter_comparison_operator  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewParameter AS _Parameter ON _Parameter.entity_name = entity_name  -- association [0..*]
LEFT OUTER JOIN I_CustomCDSViewParameterValue AS _ParameterValue ON _ParameterValue.entity_name = entity_name  -- association [0..*]
LEFT OUTER JOIN I_CustomCDSViewViewAnnotation AS _ViewAnnotation ON _ViewAnnotation.entity_name = entity_name  -- association [0..*]
LEFT OUTER JOIN I_CustomCDSViewElement AS _Element ON _Element.entity_name = entity_name  -- association [0..*]
;