RSRTS_QF4_QueryProviderBasic

DDL: RSRTS_QF4_QUERYPROVIDERBASIC Type: view_entity Package: RSRTS_CDS_QUERY

Query with Provider

RSRTS_QF4_QueryProviderBasic is a CDS View that provides data about "Query with Provider" in SAP S/4HANA. It reads from 3 data sources (RSRTS_QF4_DirectBaseCDSViews, ddheadanno, RSRTS_QF4_QUERYWOPROVIDER) and exposes 7 fields with key field queryCDSName. Part of development package RSRTS_CDS_QUERY.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
RSRTS_QF4_DirectBaseCDSViews _cube inner
ddheadanno _cube_dataCategory inner
RSRTS_QF4_QUERYWOPROVIDER _query_list from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Query with Provider view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY queryCDSName RSRTS_QF4_QUERYWOPROVIDER queryCDSName
compid RSRTS_QF4_QUERYWOPROVIDER compid
queryDDLName RSRTS_QF4_QUERYWOPROVIDER queryDDLName
queryDevClass RSRTS_QF4_QUERYWOPROVIDER queryDevClass
withProvContractAnalyticalQry RSRTS_QF4_QUERYWOPROVIDER withProvContractAnalyticalQry
cubeCDSname RSRTS_QF4_DirectBaseCDSViews direct_base_object
cubeDataCategory ddheadanno value 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Query with Provider'
define view entity RSRTS_QF4_QueryProviderBasic

  as select from RSRTS_QF4_QUERYWOPROVIDER    as _query_list
  // get the source views (from-clause but unfortunately also associations)

  // only these with Analytics.dataCategory are relevant

  // target of association are always DIMENSION, so the one with direct_base_object not DIMENSION has to be taken

  // in case of query on DIMENSION it is more sophisticated / will be solved on ABAP-side

    inner join   RSRTS_QF4_DirectBaseCDSViews as _cube              on _cube.entity_name = _query_list.queryCDSName
    inner join   ddheadanno                   as _cube_dataCategory on  _cube_dataCategory.strucobjn = _cube.direct_base_object
                                                                    and _cube_dataCategory.name      = 'ANALYTICS.DATACATEGORY'
                                                                    
{
  key _query_list.queryCDSName,
      _query_list.compid,
      _query_list.queryDDLName,
      _query_list.queryDevClass,
      _query_list.withProvContractAnalyticalQry,

      _cube.direct_base_object as cubeCDSname,
      _cube_dataCategory.value as cubeDataCategory

}

Learn More