C_ABI_Analytical_Query

DDL: C_ABI_ANALYTICAL_QUERY Type: view_entity CONSUMPTION Package: RS_ANA_ABI_MAIN

Analytical Query List

C_ABI_Analytical_Query is a Consumption CDS View that provides data about "Analytical Query List" in SAP S/4HANA. It reads from 4 data sources (ARS_APIS_RELEASED_C1_OR_GROUPS, dd02bnd, ddddlsrc, ddddlsrct) and exposes 2 fields with key field DDLSourceName. Part of development package RS_ANA_ABI_MAIN.

4 data source(s) 2 fields

Data Sources (4)

SourceAliasJoin Type
ARS_APIS_RELEASED_C1_OR_GROUPS ReleasedViews left_outer
dd02bnd StructuredNodes inner
ddddlsrc Views from
ddddlsrct ViewText left_outer

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Analytical Query List view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName ddddlsrc ddlname
CDSDescription ddddlsrct ddtext 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Analytical Query List'

@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #CONSUMPTION

define view entity C_ABI_Analytical_Query
  as select from           ddddlsrc                       as Views

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

    left outer join        ARS_APIS_RELEASED_C1_OR_GROUPS as ReleasedViews   on  Views.ddlname              = ReleasedViews.tadir_obj_name
                                                                             and ReleasedViews.tadir_object = 'DDLS'

    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  <> ''
                                                                              )
    left outer join      ddddlsrct   as ViewText  on Views.ddlname = ViewText.ddlname and ViewText.ddlanguage = $session.system_language

{
  key Views.ddlname  as DDLSourceName,
  
  ViewText.ddtext as CDSDescription
}

where
      Views.as4local    = 'A'
  and Views.source_type = 'P'

Learn More