VB_CDS_SQLVIEWNAME

@AbapCatalog.sqlViewName: 'VBCDSSQLVIEWNAME'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #P
@ObjectModel.usageType.sizeCategory:  #L
@EndUserText.label: 'Getting sqlviewname for cds 2.0 cds'
define view VB_CDS_SQLVIEWNAME
  as select from  ddddlsrc as Views
    inner 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 <> '' )
  { // Entities with technical name annotation maintained

    key Views.ddlname         as DDLSourceName,
    upper( anno.value ) as SQLViewName,
    Views.ddlname       as CDSName,
    Views.source_origin as CDSOriginKey,
    Views.source_type as SourceType
  } where Views.source_type = 'W' and  Views.as4local = 'A' 
  union all
  select from ddddlsrc  as Views
    inner join ddheadanno as anno on Views.ddlname  = anno.strucobjn and anno.name = 'ANALYTICS.TECHNICALNAME'  and (anno.value is  null 
             or    anno.value = ''  or  anno.value  like '''') 
  { // Entities with the annotation maintained, but value is empty

    key Views.ddlname         as DDLSourceName,
    Views.ddlname as SQLViewName,
    Views.ddlname       as CDSName,
    Views.source_origin as CDSOriginKey,
    Views.source_type as SourceType
  } where Views.source_type = 'W' and  Views.as4local = 'A'
  union all
  select from ddddlsrc  as Views
    left outer join ddheadanno as anno on Views.ddlname  = anno.strucobjn and anno.name = 'ANALYTICS.TECHNICALNAME'
  { // Entities without the annotation

    key Views.ddlname         as DDLSourceName,
    Views.ddlname as SQLViewName,
    Views.ddlname       as CDSName,
    Views.source_origin as CDSOriginKey,
    Views.source_type as SourceType
  } where Views.source_type = 'W' and  Views.as4local = 'A' and anno.name is null 
  
  
//  

//  left outer join ddheadanno as anno on Views.ddlname = anno.strucobjn and anno.name = 'ANALYTICS.TECHNICALNAME'

//  

//{

//  key Views.ddlname         as DDLSourceName,

//  case when anno.value is null then Views.ddlname

//       when anno.value = '' then Views.ddlname

//       else replace( upper( anno.value ), '''', '')

//  end as SQLViewName,

//  Views.ddlname       as CDSName,

//  Views.source_origin as CDSOriginKey,

//  Views.source_type as SourceType 

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDDDLSRC",
"DDHEADANNO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/