SAP Knowledge Base Article - Public

2419785 - Error in OData Query for Standard Report: Property C0CHAR_STRUCTURE

Symptom

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

Product

SAP Business ByDesign all versions