cancel
Showing results for 
Search instead for 
Did you mean: 

Error with S/4HANA OData API

0 Kudos

Hello Experts,

I am trying to consume a S/4HANA OData API in CPI using an OData adapter. But on executing the API in CPI I am getting the below error.

Left hand expression of memberaccess operator has wrong cardinality (to many not allowed)

Mentioned below is the screenshot of the configuration done in the OData adapter for your reference.

Request you to please suggest a workaround for the stated issue.

Thanks & Regards,

Varun Vichare.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member306381
Participant
0 Kudos

Hi Varun,

Odata V2 Adapter does not support Navigation Entities in the Resource Path for GET Operation,

Work Around would be as below,

  • Ask your Abaper to pass those Date Parameters in the Filters then it would work.
  • Use HTTP Adapter.

Let me know if you face any issues.

Regards,

Bhaskar

0 Kudos

Hi Bhaskar,

I tried using HTTP adapter as a workaround for the stated issue. But not able to configure filter parameters in the query parameter of HTTP adapter. Please find below screenshot for your reference.

sumanth171
Active Participant
0 Kudos

Hi Varun,

Please find the note: https://launchpad.support.sap.com/#/notes/0003008698

Too many filters or 1..* cardinality will not be supported.

Regards,

Anil

0 Kudos

Hello Anil,

The same query along with filter is working in S/4HANA. But in CPI on execution of the interface I am getting the stated error. Below is the screenshot of the working query in S/4HANA.

Regards,

Varun Vichare.