Question Re: Invalid parameter type used at function 'eq' on ODATA execution in Technology Q&A

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

Hanumath — Tue, 14 May 2019 00:46:19 GMT

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/RPXXXXXXXXXXXXXXXXXQueryResults?$inlinecount=allpages&$select=CBUS_PART_UUID,CCOMPANY_UUID,CCREATION_DATE,CIM_SUB_TYPE_C,CGLACCT,CACC_DOC_UUID_C,RCAMTLIT,CCURRLIT,CSP_CDT_F_DATE,CPOSTING_DATE,COED_DATE,COED_REF_F_ID,KCAMTLIT&$filter=(CSETOFBKS 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

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

may_thitsaoo — Tue, 14 May 2019 03:49:49 GMT

Hi Hanu,

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

Regards,

May

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

former_member226 — Tue, 14 May 2019 09:52:27 GMT

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

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

Hanumath — Tue, 14 May 2019 23:57:08 GMT

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