CDS_VIEWS_INFO
List of All CDS Views with details
CDS_VIEWS_INFO is a CDS View in S/4HANA. List of All CDS Views with details. It contains 13 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Vb_Core_Cdsviews | view | from | View Browser Core CDS Views |
Fields (13)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DDLSourceName | DDLSourceName | 1 |
| _CDSAppCompText | _CDSAppCompText | 1 | |
| _CdsFavorite | _CdsFavorite | 1 | |
| _CdsSupportedCapabilities | _CdsSupportedCapabilities | 1 | |
| _CdsTagCount | _CdsTagCount | 1 | |
| _Text | _Text | 1 | |
| ApplicationComponent | ApplicationComponent | 1 | |
| ApplicationComponentName | ApplicationComponentName | 1 | |
| CDSName | CDSName | 1 | |
| CDSViewPackage | CDSViewPackage | 1 | |
| CDSViewSourceSystem | CDSViewSourceSystem | 1 | |
| SourceType | SourceType | 1 | |
| SQLViewName | SQLViewName | 1 |
@AbapCatalog.sqlViewName: 'CDSVIEWSINFO'
@EndUserText.label: 'List of All CDS Views with details'
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Cds_Views_Info as select from Cds_Views
//left outer 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
left outer join Cds_Views_Vdm_Type as CDSVDMType
on Cds_Views.CDSName = CDSVDMType.CDSName
left outer join Cds_Views_Pkg_Appcomp as CDSPkgAppComp
on Cds_Views.DDLSourceName = CDSPkgAppComp.DDLSourceName
association [0..*] to Cds_View_Text as _Text on $projection.DDLSourceName = _Text.DDLSourceName and $projection.CDSName = _Text.CDSName
association [0..1] to Cds_Views_Favorite as _CdsFavorite on $projection.DDLSourceName = _CdsFavorite.DDLSourceName
association [0..1] to Cds_Views_Tag_Count as _CdsTagCount on $projection.DDLSourceName = _CdsTagCount.DDLSourceName
association [0..*] to CDS_ALL_SUPPORTED_CAPABILITIES as _CdsSupportedCapabilities on $projection.DDLSourceName = _CdsSupportedCapabilities.Ddlsourcename
{
key Cds_Views.DDLSourceName,
Cds_Views.SQLViewName,
Cds_Views.CDSName,
case when CDSVDMType.CDSName is not null
then CDSVDMType.CdsViewType
else 'NA' //if the VDM view type is not maintained it is marked as NA(Undefined)
end as CdsViewType,
CDSPkgAppComp.ApplicationComponent,
CDSPkgAppComp.ApplicationComponentName,
CDSPkgAppComp.CDSViewPackage,
Cds_Views.CDSOriginKey,
CDSPkgAppComp._CDSAppCompText,
CDSPkgAppComp.CDSViewSourceSystem,
_Text,
_CdsFavorite,
_CdsTagCount,
_CdsSupportedCapabilities,
Cds_Views.SourceType
}