Cds_Views_Extn

DDL: CDS_VIEWS_EXTN SQL: CDSVIEWSEXTN Type: view Package: S_DICT_VB

List of All CDS Views

Cds_Views_Extn is a CDS View that provides data about "List of All CDS Views" in SAP S/4HANA. It reads from 4 data sources (ddddlsrc, Cds_Sql_View, Cds_Stob_View, VB_CDS_SQLVIEWNAME_EXTENSION) and exposes 9 fields with key field DDLSourceName. Part of development package S_DICT_VB.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
ddddlsrc AllCDSViews union_all
Cds_Sql_View CDSSQLView inner
Cds_Stob_View CDSSTOBView inner
VB_CDS_SQLVIEWNAME_EXTENSION VB_CDS_SQLVIEWNAME_EXTENSION from

Annotations (6)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName DDLSourceName
CDSOriginKey CDSOriginKey
SQLViewName SQLViewName
CDSName CDSName
ddlnameasDDLSourceName
CDSOriginKey ddddlsrc source_origin
SQLViewName Cds_Sql_View SQLViewName
CDSName Cds_Stob_View CDSName
SourceType ddddlsrc source_type 
@AbapCatalog.sqlViewName: 'CDSVIEWSEXTN'
@EndUserText.label: 'List of All CDS Views'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter:true 
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Cds_Views_Extn as
select from VB_CDS_SQLVIEWNAME_EXTENSION 
{
  key DDLSourceName,
      CDSOriginKey,
      SQLViewName,
      CDSName,
      SourceType
}

union all  select from ddddlsrc      as AllCDSViews
    inner join   Cds_Sql_View  as CDSSQLView  on AllCDSViews.ddlname = CDSSQLView.DDLSourceName
    inner join   Cds_Stob_View as CDSSTOBView on AllCDSViews.ddlname = CDSSTOBView.DDLSourceName
{
  key AllCDSViews.ddlname       as DDLSourceName,
      AllCDSViews.source_origin as CDSOriginKey,
      CDSSQLView.SQLViewName    as SQLViewName,
      CDSSTOBView.CDSName,
      AllCDSViews.source_type   as SourceType
}
where
      AllCDSViews.as4local    = 'A'
  and AllCDSViews.source_type = 'X'

Learn More