I_CCV_DATASOURCE_HELPER

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Custom CDS View Datasource Helper'
define view entity I_CCV_DATASOURCE_HELPER
  as select from dd02b                        as stob

    inner join   ddldependency                as dep        on  dep.objectname = stob.strucobjn
                                                            and dep.state      = 'A'
                                                            and dep.objecttype = 'STOB'
    inner join   ddddlsrc                     as src        on  src.ddlname  = dep.ddlname
                                                            and src.as4local = 'A'
                                                            and ( src.source_type = 'V' or src.source_type = 'W' )
                                                            and src.parentname = ''
                                                            and (    src.source_origin = 0
                                                                  or src.source_origin = 1
                                                                  or src.source_origin = 3
                                                                  or src.source_origin = 4
                                                                  or src.source_origin = 5 )
    inner join    ARS_APIS_RELEASED_C1_OR_GROUPS as rel_c1_grp on  rel_c1_grp.object_key  = stob.strucobjn
                                                            and rel_c1_grp.object_type = 'CDS_STOB'
                                                            and (     rel_c1_grp.state = 'RELEASED'
                                                                  or  rel_c1_grp.state = 'DEPRECATED' )
 
    -- Annotation value 'ODATA.PUBLISH'
    /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
    association [0..1] to ddheadanno                   as _odata                on  _odata.strucobjn = stob.strucobjn
                                                                                and _odata.name      = 'ODATA.PUBLISH'
    -- Annotation value 'ANALYTICS.DATACATEGORY'
    /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
    association [0..1] to ddheadanno                   as _analytics_category   on  _analytics_category.strucobjn = stob.strucobjn
                                                                                and _analytics_category.name      = 'ANALYTICS.DATACATEGORY'
    -- Annotation value 'ANALYTICS.QUERY'
    /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
    association [0..1] to ddheadanno                   as _analytics_query      on  _analytics_query.strucobjn = stob.strucobjn
                                                                                and _analytics_query.name      = 'ANALYTICS.QUERY'
    -- Annotation value 'ACCESSCONTROL.AUTHORIZATIONCHECK'
    /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
    association [0..1] to ddheadanno                   as _access_control       on  _access_control.strucobjn = stob.strucobjn
                                                                                and _access_control.name      = 'ACCESSCONTROL.AUTHORIZATIONCHECK'
    -- Show DCLs protecting DDLs
    association [0..1] to Sacm_Public_Dcl_For_Entity   as _dcl_for_entity       on  _dcl_for_entity.entity = stob.strucobjn

    -- Annotation value 'OBJECTMODEL.DATACATEGORY'
    /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
    association [0..1] to ddheadanno                   as _object_category      on  _object_category.strucobjn = stob.strucobjn
                                                                                and _object_category.name      = 'OBJECTMODEL.DATACATEGORY'
    association [0..1] to I_CustomCDSViewSourceOrigin    as _SourceOrigin       on  _SourceOrigin.SourceOrigin = src.source_origin
    association [0..1] to I_CustomCDSViewAccProtection   as _AccessProtection   on  _AccessProtection.AccessProtection = $projection.AccessProtection
    association [0..1] to I_CustomCDSViewAnaDataCategory as _AnaDataCategory    on  _AnaDataCategory.AnalyticsDatacategory = $projection.AnalyticsDataCategory

{
      @EndUserText.label: 'Entity Name Raw'
  key cast(stob.strucobjn_raw                 as abap.char(30))                       as DataSourceName,
      @EndUserText.label: 'Entity Name Upper Case'
      cast(stob.strucobjn                     as abap.char(30))                       as DataSourceNameUpper,
      @EndUserText.label: 'Source Origin'
      src.source_origin                                                               as SourceOrigin,

      @ObjectModel.foreignKey.association: '_AccessProtection'
      cast (case when _dcl_for_entity.dclname <> '' and
                      _access_control .value = '#PRIVILEGED_ONLY' then '2'
                 when _dcl_for_entity.dclname <> ''               then '1'
                 else                                                  '0'
      end as abap.char(1) )                                                           as AccessProtection, // 0=None, 1=Protected, 2=Privileged Only


      @EndUserText.label: 'Is Text View'
      @Consumption.filter : { selectionType: #SINGLE,  multipleSelections : false}
      case when _object_category.value = '#TEXT' then 'X'
      end                                                                             as TextViewIndicator, 

      @ObjectModel.foreignKey.association: '_AnaDataCategory'
      cast (case when _analytics_category.value = '#CUBE'      then '1'
                 when _analytics_category.value = '#DIMENSION' then '2'
      end as abap.char(1) )                                                           as AnalyticsDataCategory,

      @EndUserText.label: 'Is Masterdata View'
      @Consumption.filter : { selectionType: #SINGLE,  multipleSelections : false}
      case when _analytics_category.value = '#DIMENSION' then 'X'
      end                                                                             as MasterdataViewIndicator,

      //Associations

      _SourceOrigin,
      _AccessProtection,
      _AnaDataCategory

}
where stob.strucobjn_raw is not initial
  and stob.as4local = 'A'
  and (    _analytics_query.name   is null    // but do not show analytical queries                                 

       or  _analytics_query.value  = 'false'
      )
  and (    src.source_origin != 1             // custom CDS views without OData + non Custom CDS Views with and without OData                                  

      or (   _odata.name  is null
          or _odata.value = 'false'
         )
      );