/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
Standard report does not show data through OData query instead shows the below message:
"Property C0CHAR_STRUCTURE (Entity Type ABC): mandatory filter is missing" (where ABC standard for the technical ID of the report.)
However, when you execute the web browser report you can see the data.
Environment
SAP Business ByDesign
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: "Property C0CHAR_STRUCTURE (Entity Type RPHCMTLMU01_Q0002): mandatory filter is missing".
Cause
Certain reports have a technical structure that cannot be queried through OData.
Resolution
You can execute such reports only through the web browser.
Keywords
Property C0CHAR_STRUCTURE, employee times, odata, report, mandatory filter is missing , KBA , mandatory filter is missing , property c0char_structure , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement