APS_V_GKE_CDS_C1_VH

@AbapCatalog.sqlViewName: 'APS_V_CDSC1_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Value help for C1 views'
define view APS_V_GKE_CDS_C1_VH as select distinct from ddldependency as stob 

 inner join ddddlsrc as _src
      on _src.ddlname     = stob.ddlname and
         _src.source_type = 'V' and
         _src.as4local    = 'A'       

  inner join ars_apis_released_for_c1 as _released_c1
      on _released_c1.object_key  = stob.objectname and
         _released_c1.object_type = 'CDS_STOB'
         
    left outer join ddheadanno                                                    as _AnaQueryAnno
      on _AnaQueryAnno.strucobjn = stob.objectname 
      and _AnaQueryAnno.name = 'ANALYTICS.QUERY'

    left outer join ddheadanno                                                    as _AnalyticsDatacategoryAnno
      on _AnalyticsDatacategoryAnno.strucobjn = stob.objectname 
      and _AnalyticsDatacategoryAnno.name = 'ANALYTICS.DATACATEGORY'
{

  stob.ddlname          as DdlName,
  stob.objectname       as CdsName,
  
  case
    when _AnaQueryAnno.value = 'true' then
      'X'
    else
      ' '
   end                                                                            as IsQuery,
          
          
      case 
        when _AnalyticsDatacategoryAnno.value = '#CUBE' then   
          'Cube' 
        when _AnalyticsDatacategoryAnno.value = '#DIMENSION' then   
          'Dimension' 
        else 
          case
            when _AnaQueryAnno.value = 'true' then
              'Query'
            else
              ''
          end 
      end                                                                         as AnalyticsDataCategory
} where
      stob.objecttype = 'STOB' and 
      stob.state = 'A'