Cds_Views_Info

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_Views_Info.
-- 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: CDSVIEWSINFO

CREATE VIEW Cds_Views_Info AS
SELECT
  Cds_Views.DDLSourceName AS DDLSourceName,
  Cds_Views.SQLViewName AS SQLViewName,
  Cds_Views.CDSName AS CDSName,
  case when CDSVDMType.CDSName is not null then CDSVDMType.CdsViewType else 'NA' end as CdsViewType AS CdsViewTypeelseNAendasCdsViewType,
  CDSPkgAppComp.ApplicationComponent AS ApplicationComponent,
  CDSPkgAppComp.ApplicationComponentName AS ApplicationComponentName,
  CDSPkgAppComp.CDSViewPackage AS CDSViewPackage,
  Cds_Views.CDSOriginKey AS CDSOriginKey,
  CDSPkgAppComp._CDSAppCompText AS _CDSAppCompText,
  CDSPkgAppComp.CDSViewSourceSystem AS CDSViewSourceSystem,
  Cds_Views.SourceType AS SourceType
FROM Cds_Views
LEFT OUTER JOIN Cds_Views_Vdm_Type AS CDSVDMType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Cds_Views_Pkg_Appcomp AS CDSPkgAppComp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Cds_View_Text AS _Text ON DDLSourceName = _Text.DDLSourceName AND CDSName = _Text.CDSName  -- association [0..*]
LEFT OUTER JOIN Cds_Views_Favorite AS _CdsFavorite ON DDLSourceName = _CdsFavorite.DDLSourceName  -- association [0..1]
LEFT OUTER JOIN Cds_Views_Tag_Count AS _CdsTagCount ON DDLSourceName = _CdsTagCount.DDLSourceName  -- association [0..1]
LEFT OUTER JOIN CDS_ALL_SUPPORTED_CAPABILITIES AS _CdsSupportedCapabilities ON DDLSourceName = _CdsSupportedCapabilities.Ddlsourcename  -- association [0..*]
;