Cds_Views

@AbapCatalog.sqlViewName: 'CDSVIEWS'
@EndUserText.label: 'List of All CDS Views'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Cds_Views
  as select from VB_CDS_SQLVIEWNAME // CDS 2.0 view entities

{
  key DDLSourceName,
      CDSOriginKey,
      SQLViewName,
      CDSName,
      SourceType
}

union all

select from              ddddlsrc   as Views

  inner join             dd02bnd    as StructuredNodes on  StructuredNodes.strucobjn = Views.ddlname
                                                       and provider_contract         = 'AQ'

  left outer to one join ddheadanno as anno            on  Views.ddlname =  anno.strucobjn
                                                       and anno.name     =  'ANALYTICS.TECHNICALNAME'
                                                       and anno.value    not like ''''
                                                       and (
                                                          anno.value     is not null
                                                          or anno.value  <> ''
                                                        )
{
  key Views.ddlname       as DDLSourceName,
      Views.source_origin as CDSOriginKey,
      anno.value          as SQLViewName,
      Views.ddlname       as CDSName,
      Views.source_type   as SourceType

}
where
      Views.as4local    = 'A' 
   and Views.source_type = 'P'
      
 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 = 'V'