SAP Knowledge Base Article - Public

2419785 - Standard Report not showing data through Odata

Symptom

Standard report does not show data through OData query instead shows the below message as in screenshot. However, when you execute the web browser report you can see the data. 

OData.PNG

Reproducing the Issue

Create the Odata URL according to prerequisites for any standard report which is assigned to any work center.

Example: For standard report "Employee Times: Monthly(HCMTLMU01_Q0002)"

https://myxxxxx.sapbydesign.com/sap/byd/odata/HCM_TIMEADMINISTRATION_analytics.svc/RPHCMTLMU01_Q0002QueryResults

It shows the above message in the response as in the screenshot "Property C0CHAR_STRUCTURE (Entity Type RPHCMTLMU01_Q0002): mandatory filter is missing". 

Cause

Currently, this is system designed behavior.

Resolution

Such reports with that structure cannot be queried through OData. It is expected behavior.

You can execute them only through web browser report.

Keywords

KBA , property c0char_structure , mandatory filter is missing , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

Product

SAP Business ByDesign all versions