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.

3 data source(s) 3 fields

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
SQLViewName Cds_Sql_View SQLViewName
CDSName Cds_Stob_View CDSName 
@AbapCatalog.sqlViewName: 'QBCDSVIEWSINFO'
@EndUserText.label: 'List of All CDS Views with details'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
define view QB_CDS_VIEWS_INFO  as select from QB_CDS_VIEWS as Cds_Views

inner join Cds_Sql_View as CDSSQLView
on Cds_Views.DDLSourceName = CDSSQLView.DDLSourceName 

inner join Cds_Stob_View as CDSSTOBView
on Cds_Views.DDLSourceName = CDSSTOBView.DDLSourceName 

 {

  key Cds_Views.DDLSourceName,
  CDSSQLView.SQLViewName,
  CDSSTOBView.CDSName
  }
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"CDS_SQL_VIEW",
"CDS_STOB_VIEW",
"QB_CDS_VIEWS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More