SAP Knowledge Base Article - Public

2014739 - OData Returns "No Data Found" For Report


You try to retrieve a report via an OData statement. The statement returns no data found.

When running the report via the web browser the report returns data as expected.


Please check if the web browser report has a default value assigned in the Initial selection. If yes check further if your OData statement contains a filter that is different from the default value in the report.

For example: Many financial reports are set to run with the Default Company in the selection area. Let's assume the default company is 1000. Now with your OData statement you are applying a filter on the same report which intends to retrieve the data by company 2000.

The explanation why OData returns no data found is that the filter only applies to data retrieved by the selection Initial of the report. So first comes the selection of the report and second comes the filter in OData i.e. the report returns data for company 1000 only and when you are trying to filter for data of company 2000 the logical result is that no data will be returned to OData.


A possible solution is to create a copy of the standard report via the Business Analytics work center, Design Reports view.

In a copy of the standard report you can maintain a different default value so that you will be able to overcome the default selection of the standard report.


KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions