Skip to Content
0
Dec 15, 2021 at 02:45 PM

SAP CPI OData $filter - Left hand expression of memberaccess operator has wrong cardinality

174 Views

Hello,

I am new in CPI and OData related topics and facing an issue when I want to $filter data.

I am using the API "Replicate Business Partners (Customers) from SAP S/4HANA Cloud to Salesforce as Accounts" from API Business Hub. Replicate Account from SAP S4HANA Cloud to Salesforce | IFlow | SAP API Business Hub

The requirment is to send only Customers in specific SalesOrganization (for example 0874) to Salesforce
It could be the case that one customer has several SalesOrganization in S4HC maintained.

In my OData channel I have selected following Entity with Sub Levels 2 to retrive the SalesOrganization

image.png

I have set up the $filter as followingimage.png

When I run the IFlow I am getting following error:
Left hand expression of memberaccess operator has wrong cardinality (to many not allowed)

I also tried several custom querys but always getting the same error.

For example:
$filter= Customer ne null and to_Customer/to_CustomerSalesArea/SalesOrganization eq '0874'


Any ideas how to get only the customers in specifc SalesOrganization ?

Thank you very much,

Arun

Attachments

image.png (49.0 kB)
image.png (18.2 kB)