ANA_AQD_RELEASED_QUERIES

DDL: ANA_AQD_RELEASED_QUERIES SQL: ANA_AQD_RELQ Type: view

List of released queries

ANA_AQD_RELEASED_QUERIES is a CDS View that provides data about "List of released queries" in SAP S/4HANA. It reads from 3 data sources (ARS_APIS_RELEASED_FOR_C1, ddldependency, ddddlsrc).

3 data source(s)

Data Sources (3)

SourceAliasJoin Type
ARS_APIS_RELEASED_FOR_C1 api_releaseq left_outer
ddldependency ddl_dep inner
ddddlsrc ddl_src inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ANA_AQD_RELQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label List of released queries view 
// *******************

// This CDS view returns  queries which have been released as API for the C1 contract and use in key user apps.

//

// *******************

@AbapCatalog.sqlViewName: 'ANA_AQD_RELQ'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#NOT_REQUIRED
@EndUserText.label: 'List of released queries'
define view ANA_AQD_RELEASED_QUERIES
  as select
    queries.name,
    queries.description,
    ddl_src.source_origin,
    api_releaseq.state as status
  from              ANA_AQD_ANNO_QUERY       as queries
    inner join ddldependency as ddl_dep on ddl_dep.objectname = queries.name
    inner join ddddlsrc as ddl_src on ddl_src.ddlname = ddl_dep.ddlname
    left outer join ARS_APIS_RELEASED_FOR_C1 as api_releaseq on api_releaseq.tadir_obj_name = queries.name
                                                             or api_releaseq.object_key     = queries.name
  where
    api_releaseq.object_type = 'CDS_STOB'
    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ANA_AQD_ANNO_QUERY",
"ARS_APIS_RELEASED_FOR_C1",
"DDDDLSRC",
"DDLDEPENDENCY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More