/SSB/ALL_CDS_VIEWS

DDL: /SSB/ALL_CDS_VIEWS SQL: /SSB/ALLCDSVIEWS Type: view
12 Fields 5 Data Sources

All views including CDS 2.0 views

/SSB/ALL_CDS_VIEWS is a CDS View that provides data about "All views including CDS 2.0 views" in SAP S/4HANA. It reads from 5 data sources (ddddlsrc, /SSB/CDS_2_VIEWS_INFO, /SSB/ANALYTICS_CDS3_LIST, Cds_Sql_View, Cds_Stob_View) and exposes 12 fields with key field DDLSourceName.

Data Sources (5)

SourceAliasJoin Type
ddddlsrc AllCDSViews union_all
/SSB/CDS_2_VIEWS_INFO CDS_2_Views from
/SSB/ANALYTICS_CDS3_LIST CDS_3_Views union_all
Cds_Sql_View CDSSQLView inner
Cds_Stob_View CDSSTOBView inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName /SSB/ALLCDSVIEWS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label All views including CDS 2.0 views view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName /SSB/CDS_2_VIEWS_INFO DDLSourceName DDL Source Name
CDSViewType /SSB/CDS_2_VIEWS_INFO CDSViewType Source Origin
SQLViewName /SSB/CDS_2_VIEWS_INFO SQLViewName View Name
CDSName /SSB/CDS_2_VIEWS_INFO CDSName DDL Source Name
ddlnameasDDLSourceName
CDSViewType ddddlsrc source_origin Source Origin
SQLViewName Cds_Sql_View SQLViewName View Name
CDSName Cds_Stob_View CDSName DDL Source Name
CDSViewType CDSViewType Source Origin
SQLViewName SQLViewName View Name
CDSName DDLSourceName DDL Source Name
SourceType SourceType Source Type

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 /SSB/ALL_CDS_VIEWS.
-- 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: /SSB/ALLCDSVIEWS

CREATE VIEW /SSB/ALL_CDS_VIEWS AS
SELECT
  CDS_2_Views.DDLSourceName AS DDLSourceName,
  CDS_2_Views.CDSViewType AS CDSViewType,
  CDS_2_Views.SQLViewName AS SQLViewName,
  CDS_2_Views.CDSName AS CDSName,
  CDS_2_Views.SourceType AS ddlnameasDDLSourceName,
  SourceType
FROM /SSB/CDS_2_VIEWS_INFO AS CDS_2_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 */
-- UNION ALL with additional select branch(es): ddddlsrc, /SSB/ANALYTICS_CDS3_LIST
;

Learn More