RSRTS_QF4_QUERYPROVIDERBASIC
Query with Provider
RSRTS_QF4_QUERYPROVIDERBASIC is a CDS View in S/4HANA. Query with Provider. It contains 7 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| RSRTS_QF4_QueryProvider_All | view_entity | from | Release CDS-Cube based Queries: View/ddlsource of query/cube |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | queryCDSName | queryCDSName | 1 |
| compid | compid | 1 | |
| cubeCDSname | cubeCDSname | 1 | |
| cubeDataCategory | cubeDataCategory | 1 | |
| queryDDLName | queryDDLname | 1 | |
| queryDevClass | queryDevClass | 1 | |
| withProvContractAnalyticalQry | withProvContractAnalyticalQry | 1 |
@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
}