RSRTS_QF4_QUERYWOPROVIDER

DDL: RSRTS_QF4_QUERYWOPROVIDER Type: view_entity

Queries (without Provider Info)

RSRTS_QF4_QUERYWOPROVIDER is a CDS View that provides data about "Queries (without Provider Info)" in SAP S/4HANA. It reads from 4 data sources (dd02bnd, ddheadanno, RSODP_ABAP_CDS_ODPNAME, RSODP_ABAP_CDS_ODPNAME) and exposes 9 fields with key field queryCDSName.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
dd02bnd _contract inner
ddheadanno _headanno inner
RSODP_ABAP_CDS_ODPNAME _queryWithAnno from
RSODP_ABAP_CDS_ODPNAME _queryWithContract union_all

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Queries (without Provider Info) view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY queryCDSName RSODP_ABAP_CDS_ODPNAME cdsViewName
compid
queryDDLName RSODP_ABAP_CDS_ODPNAME ddlName
queryDevClass RSODP_ABAP_CDS_ODPNAME devClass
cdsViewNameasqueryCDSname
compid
queryDDLname RSODP_ABAP_CDS_ODPNAME ddlName
queryDevClass RSODP_ABAP_CDS_ODPNAME devClass
withProvContractAnalyticalQry 

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Queries (without Provider Info)'
@Metadata.ignorePropagatedAnnotations: true
define view entity RSRTS_QF4_QUERYWOPROVIDER
as select from RSODP_ABAP_CDS_ODPNAME  as _queryWithAnno 
 
     // query annotation      

    inner join ddheadanno   as   _headanno   on   _headanno.strucobjn = _queryWithAnno.cdsViewName
                                             and  _headanno.name  = 'ANALYTICS.QUERY'
                                             and  _headanno.value  <> 'false'
                                                                           
                                                                         {
  key _queryWithAnno.cdsViewName                                      as queryCDSName,
      cast( concat( '2C', _queryWithAnno.odpName ) as rszcompid)      as compid,
      _queryWithAnno.ddlName                                          as queryDDLName,
      _queryWithAnno.devClass                                         as queryDevClass,
      cast( ' ' as rsrtspcaq preserving type )                        as withProvContractAnalyticalQry      
        
}

 where (     _headanno.name  = 'ANALYTICS.QUERY' 
         and _headanno.value             <> 'false' )
    and _queryWithAnno.sourceType <> 'P' 
         
union all

  select from RSODP_ABAP_CDS_ODPNAME as _queryWithContract
    inner join dd02bnd as _contract   on  _contract.strucobjn = _queryWithContract.cdsViewName
                                                                       and _contract.nodename  = '.NODE1'
                                                                       and _contract.as4local  = 'A'   
 

{
  key _queryWithContract.cdsViewName                                      as queryCDSname,
      cast( concat( '2C', _queryWithContract.odpName ) as rszcompid)      as compid,
      _queryWithContract.ddlName                                          as queryDDLname,
      _queryWithContract.devClass                                         as queryDevClass,
      cast( 'X' as rsrtspcaq preserving type )                            as withProvContractAnalyticalQry                     
}

 where  _contract.provider_contract =  'AQ'  
    and _queryWithContract.sourceType = 'P'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSODP_ABAP_CDS_ODPNAME",
"DD02BND",
"DDHEADANNO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More