ALL_CDS_SQL_VIEWS

DDL: ALL_CDS_SQL_VIEWS SQL: ALLCDSSQLVIEWS Type: view Package: S_ANA_BEX_LAS

SQL view name of all cds views

ALL_CDS_SQL_VIEWS is a CDS View that provides data about "SQL view name of all cds views" in SAP S/4HANA. It reads from 1 data source (ddldependency) and exposes 2 fields with key field DDLSourceName. Part of development package S_ANA_BEX_LAS.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
ddldependency ddldependency from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName ALLCDSSQLVIEWS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SQL view name of all cds views view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName ddldependency ddlname
SQLViewName ddldependency objectname 
@AbapCatalog.sqlViewName: 'ALLCDSSQLVIEWS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SQL view name of all cds views'
define view ALL_CDS_SQL_VIEWS as select from ddldependency {
  key ddldependency.ddlname as DDLSourceName,
  ddldependency.objectname as SQLViewName
} where ddldependency.state = 'A' and ddldependency.objecttype = 'VIEW'

Learn More