SAP Knowledge Base Article - Preview

3656442 - Analytical app displays inconsistent query results for different users in SAP S/4HANA

Symptom

  • Fiori App (e.g. F1250 - Sales Volume) displays inconsistent results depending on the user.
  • User ID <ABC> encounters no data returned when executing query (e.g. 2CCSDREVNFRMINVCQ) in transaction RSRT.
  • User ID <XZY> successfully retrieves data for the same query in transaction RSRT.
  • Checking with debug functions debug "Show DCL authorizations for CDS" and "Display SAP Hana Query" in RSRT additional condition present in SQL WHERE clause for user <ABC>, which restricts the query results.


Read more...

Environment

  • Fiori
  • SAP S/4HANA
  • SAP S/4HANA Cloud Private Edition

Product

SAP S/4HANA Cloud Private Edition all versions ; SAP S/4HANA all versions

Keywords

app f1250, inconsistent results, sap s/4hana, user roles, sql trace, rsrt query, access control, missing roles, authorization issue, fiori launchpad, query 2ccsdrevnfrminvcq, no data found, sql where clause, CDS Query, 0TCAKYFNM, S_RS_COMP, SDDLVIEW, Custom CDS Views, Custom Analytical Queries, annotation AccessControl.authorizationCheck, authorization relevant, CDS Access Controls, Access Controls, authorization, CDS authorization, Data Control Language (DCL), Data Control Language, DCL, missing data, inconsistent data, different data, f4-help missing values, f4 missing values, f4

, KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , SD-ANA , Analytics , SD-FIO-HBA , Analytical Apps , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.