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 , 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.