Invalid parameter type used at function 'eq' on ODATA execution

[Hanumath]

Hello Community,

I am facing an issue with the ODATA service execution as shown below

I found the issue is with the filter parameter on the Accounting Period/Year (CFISCALYEARPERIO eq '2018010')in the AR report. I have tried with the following API including the filter parameters

https://myXXXXX.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/RPXXXXXXXXXXXXXXXX... eq 'SOB3') and (CCOMPANY_UUID eq 'XXX') and (CFISCALYEARPERIO eq '2018010')&$format=json.

I would like to pass the value of October 2018 to the highlighted field. Being it fiscal accounting year and period, I am passing the values as '2018010'.

Let me know how to resolve this.

Regards

Hanu K

[may_thitsaoo · Accepted solution]

Hi Hanu,

Please try as CFISCALYEARPERIO eq 102018 (without ' ' ).

Regards,

May

[former_member226]

Hi Hanu,

You need to use filter as "CFISCALYEARPERIO gt datetime'2018-10-01T00:00:00'"

You can refer to https://answers.sap.com/questions/10743713/how-to-use-odata-date-filter-query-to-filter-data.html

Thanks
Saurabh

[Hanumath]

Thanks, Saurabh. Unfortunately, this didn't work.

This field is not a Date Time field. It is a combination of the Fiscal Year and Accounting Period together.

Date Time conversion will not work on this.

Regards

Hanu K