RSRTS_QF4_QueryProvider_All

DDL: RSRTS_QF4_QUERYPROVIDER_ALL Type: view_entity Package: RSRTS_CDS_QUERY

Release CDS-Cube based Queries: View/ddlsource of query/cube

RSRTS_QF4_QueryProvider_All is a CDS View that provides data about "Release CDS-Cube based Queries: View/ddlsource of query/cube" in SAP S/4HANA. It reads from 5 data sources (RSODP_ABAP_CDS_ODPNAME, RSRTS_QF4_QueryProviderBasic, ddddlsrc02bt, RSRTS_APP_COMPONENT, ARS_APIS_RELEASED_C1_OR_GROUPS) and exposes 13 fields with key field queryCDSName. Part of development package RSRTS_CDS_QUERY.

5 data source(s) 13 fields

Data Sources (5)

SourceAliasJoin Type
RSODP_ABAP_CDS_ODPNAME _cube_odp inner
RSRTS_QF4_QueryProviderBasic _query_list from
ddddlsrc02bt _text1 left_outer
RSRTS_APP_COMPONENT akh inner
ARS_APIS_RELEASED_C1_OR_GROUPS ars_api_released left_outer

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY queryCDSName RSRTS_QF4_QueryProviderBasic queryCDSName
compid RSRTS_QF4_QueryProviderBasic compid
queryDDLname RSRTS_QF4_QueryProviderBasic queryDDLName
queryState ARS_APIS_RELEASED_C1_OR_GROUPS state
queryDevClass RSRTS_QF4_QueryProviderBasic queryDevClass
withProvContractAnalyticalQry RSRTS_QF4_QueryProviderBasic withProvContractAnalyticalQry
queryDescription ddddlsrc02bt ddtext
infoprovider
cubeDDLname RSODP_ABAP_CDS_ODPNAME ddlName
cubeCDSname RSRTS_QF4_QueryProviderBasic cubeCDSname
cubeDevclass RSODP_ABAP_CDS_ODPNAME devClass
akhAppComponent RSRTS_APP_COMPONENT app_component
cubeDataCategory RSRTS_QF4_QueryProviderBasic cubeDataCategory 
@AccessControl.authorizationCheck: #CHECK

define view entity RSRTS_QF4_QueryProvider_All

  as select from    RSRTS_QF4_QueryProviderBasic   as _query_list

  // release status

    left outer join ARS_APIS_RELEASED_C1_OR_GROUPS as ars_api_released on  ars_api_released.object_type = 'CDS_STOB'
                                                                       and ars_api_released.object_key  = _query_list.queryCDSName

  // get details of source views

    inner join      RSODP_ABAP_CDS_ODPNAME         as _cube_odp        on _cube_odp.cdsViewName = _query_list.cubeCDSname

  // application component of the source view -> will become the infoarea

    inner join      RSRTS_APP_COMPONENT            as akh              on akh.pkg = _cube_odp.devClass

  // label of the query

    left outer join ddddlsrc02bt   as _text1 on  _text1.ddlname    = _query_list.queryDDLName
                                             and _text1.strucobjn  = _query_list.queryCDSName 
                                             and _text1.as4local   = 'A'
                                             and _text1.ddlanguage = $session.system_language
                                             
{
      // query fields

  key _query_list.queryCDSName                                as queryCDSName,
      _query_list.compid                                      as compid,
      _query_list.queryDDLName                                as queryDDLname,
      ars_api_released.state                                  as queryState,
      _query_list.queryDevClass                               as queryDevClass,
      _query_list.withProvContractAnalyticalQry               as withProvContractAnalyticalQry,
      @Semantics.text: true
      _text1.ddtext                                           as queryDescription,
      
      // provider fields

      cast( concat( '2C', _cube_odp.odpName ) as rsinfoprov ) as infoprovider,
      _cube_odp.ddlName                                       as cubeDDLname,
      _query_list.cubeCDSname                                 as cubeCDSname,
      _cube_odp.devClass                                      as cubeDevclass,
      akh.app_component                                       as akhAppComponent,   
      _query_list.cubeDataCategory                            as cubeDataCategory  
}

Learn More