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
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
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.
SAP Knowledge Base Article - Preview