QB_CDS_VIEWS_INFO

DDL: QB_CDS_VIEWS_INFO SQL: QBCDSVIEWSINFO Type: view

List of All CDS Views with details

QB_CDS_VIEWS_INFO is a CDS View that provides data about "List of All CDS Views with details" in SAP S/4HANA. It reads from 3 data sources (QB_CDS_VIEWS, Cds_Sql_View, Cds_Stob_View) and exposes 3 fields with key field DDLSourceName.

Data Sources (3)

SourceAliasJoin Type
QB_CDS_VIEWS Cds_Views from
Cds_Sql_View CDSSQLView inner
Cds_Stob_View CDSSTOBView inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName QBCDSVIEWSINFO view
EndUserText.label List of All CDS Views with details view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName QB_CDS_VIEWS DDLSourceName DDL Source Name
SQLViewName Cds_Sql_View SQLViewName View Name
CDSName Cds_Stob_View CDSName Object name

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 QB_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: QBCDSVIEWSINFO

CREATE VIEW QB_CDS_VIEWS_INFO AS
SELECT
  Cds_Views.DDLSourceName AS DDLSourceName,
  CDSSQLView.SQLViewName AS SQLViewName,
  CDSSTOBView.CDSName AS CDSName
FROM QB_CDS_VIEWS AS Cds_Views
INNER JOIN Cds_Sql_View AS CDSSQLView ON /* join condition not captured in parsed metadata */
INNER JOIN Cds_Stob_View AS CDSSTOBView ON /* join condition not captured in parsed metadata */
;