Cds_View_All

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 Cds_View_All.
-- 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: CDSVIEWALL

CREATE VIEW Cds_View_All AS
SELECT
  ddddlsrc.ddlname AS DDLSourceName,
  coalesce( dd02b.strucobjn_raw, Cds_Sql_View.DDLSourceName ) AS DDLSourceNameText,
  ddldependency.objectname AS CDSName,
  Cds_Sql_View.SQLViewName AS SQLViewName,
  tadir.devclass AS CDSViewPackage,
  tadir.srcsystem AS CDSViewSourceSystem,
  cast(ddddlsrc.source_origin as abap.char( 10 )) AS CDSOrigin,
  case when Public_Cds_View_Type.CDSName is not null then Public_Cds_View_Type.CdsViewType else 'NA' end as CdsViewType AS CdsViewTypeelseNAendasCdsViewType
FROM ddddlsrc
INNER JOIN ddldependency ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Public_Cds_View_Type ON /* join condition not captured in parsed metadata */
INNER JOIN Cds_Sql_View ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Cds_View_Annotation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARS_APIS_RELEASED_C1_OR_GROUPS AS ReleasedViews ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Cds_Application_Component AS _CdsApplComp ON DDLSourceName = _CdsApplComp.ObjectName  -- association [1..*]
LEFT OUTER JOIN vdm_browsertag AS _CdsBrowserTag ON DDLSourceName = _CdsBrowserTag.ddlsourcename  -- association [0..*]
LEFT OUTER JOIN Cds_Tag_Count AS _CdsTagCount ON DDLSourceName = _CdsTagCount.DDLSourceName  -- association [1..*]
LEFT OUTER JOIN Cds_Favorite AS _CdsFavorite ON DDLSourceName = _CdsFavorite.DDLSourceName  -- association [1..*]
LEFT OUTER JOIN Dictionary_Definition AS _CdsDefinition ON CDSName = _CdsDefinition.ObjectName  -- association [1..*]
LEFT OUTER JOIN Cds_View_Parameter AS _CdsViewParameter ON CDSName = _CdsViewParameter.CDSName  -- association [0..*]
LEFT OUTER JOIN Cds_View_Annotation AS _CdsViewAnnotation ON CDSName = _CdsViewAnnotation.CDSName  -- association [0..*]
LEFT OUTER JOIN Cds_View_Crossreference AS _CdsViewCrossreference ON SQLViewName = _CdsViewCrossreference.SQLViewName  -- association [1..*]
LEFT OUTER JOIN Cds_View_Text AS _Text ON DDLSourceName = _Text.DDLSourceName  -- association [0..*]
LEFT OUTER JOIN Cds_Editors_Text AS _EditorText ON CDSOrigin = _EditorText.CDSOrigin  -- association [0..*]
;