Cds_View_Cubes

@AbapCatalog.sqlViewName: 'CDSVIEWCUBES'
@EndUserText.label: 'All Analytical Cubes'
@ObjectModel.usageType.serviceQuality:  #B
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.sizeCategory:  #L
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Cds_View_Cubes as select from ddddlsrc 

  inner join ddldependency
  on ddddlsrc.ddlname = ddldependency.ddlname
  and ddddlsrc.as4local = 'A' and ddldependency.state = 'A' and ddldependency.objecttype = 'STOB'
  
  left outer to one join Cds_Sql_View ----------------Please don't change the left outer joi to inner join this is done for V1 built over V2 for marketing 
  on ddddlsrc.ddlname = Cds_Sql_View.DDLSourceName

  inner join Cds_View_Annotation as _Cubes
  on ddldependency.objectname = _Cubes.CDSName
  and _Cubes.AnnotationName = 'ANALYTICS.DATACATEGORY' and _Cubes.AnnotationValue = '#CUBE' {
      
    key ddddlsrc.ddlname as DDLSourceName,
    ddldependency.objectname as CDSName,
    coalesce( Cds_Sql_View.SQLViewName, ddddlsrc.ddlname) as SQLViewName, ----------------Please don't change the left outer joi to inner join this is done for V1 built over V2 for marketing 
   // Cds_Sql_View.SQLViewName as SQLViewName,

    _Cubes.AnnotationName,
    _Cubes.AnnotationValue
}