Symptom
When running a report in the app Balance Sheet/Income Statement - Multidimensional (App ID W0161), the following error messages appear:
The result set does not contain any relevant data
Result set for query 2CCFIFINSTMTCMP is empty.
Environment
SAP S/4HANA Cloud Public Edition.
Reproducing the Issue
- Open the Balance Sheet / Income Statement - Multidimensional reporting app.
- Run the report.
- Observe that the report returns no data and shows the message that the result set is empty.
Cause
Cause 1:
No shared currency type for the selected company codes
Currency type 10 is not unique with regard to the currency as company code currency
Error while reading data; navigation is possible
Result set for query 2CCFIFINSTMTCMP is empty
The Currency Type filter is set to value 10 (Company Code Currency), but multiple company codes with different currencies have been selected. There are no entries available for this query.
Cause 2:
The user executing the report does not have the required authorization to access the report results.
Resolution
For the error "No shared currency type for the selected company codes", ensure that all selected company codes have the same company code currency for Currency Type 10. To run the report with multiple company code currencies, select a different filter: Currency Type 30 (Group Currency), as all company codes share the same group currency.
For authorization issues, follow these steps for resolution:
- Open the Display Authorization Trace app and trace while running the affected report to capture missing authorizations. Refer to SAP Help Portal: How to Create an Authorization Trace
- Review the trace results to identify the exact authorization object/value (for example, read restrictions) that blocks data retrieval.
- In the Maintain Business Roles app, adjust the affected role by granting the required authorizations or setting the relevant read restrictions to unrestricted, as appropriate to organizational governance.
- Run the report again to confirm that data is returned as expected.
See Also
SAP Note 3565351 - Balance Sheet/Income Statement - Multidimensional error: No shared currency type for the selected company codes - SAP for Me
Keywords
balance sheet, income statement, multidimensional report, result set empty, query 2CCFIFINSTMTCMP, currency type 10, company code currency, reporting apps, SAP S/4HANA Cloud, Result set for query 2CCFIFINSTMTCMP is empty, No shared currency type for the selected company codes, FE778, Error reading the data of InfoProvider 2CIFIFINSTMTCUBE, BW_REPORTING_FPM 014 , KBA , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem
Product
Attachments
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
SAP Knowledge Base Article - Public