OData 2.0 expanded Object filter

[former_member746681]

So the original issue is that I have fields that I need to filter in the expand object of an OData 2.0 Service. This Expand Object is a 1:N (multiple item lines for a single purchase order). So does not allow me to filter directly.

Second option is the run the call in the line object first to get a list of the Order that qualified and use that to go back to header to filter. The problem now is, 2.0 does not support contain or in. And I can't use substringof because the order ID is a numeric so looks like string function does not apply. (I have tested the substringof for string and works great). Further more, I will have thousands of order list to filter against and using (PurchaseOrder eq 1 or PurchaseOrder eq 2) is not practical.

Any idea on how to do this type of expand object filter for OData 2.0?

[former_member746681]

Anyway to upgrade existing OData V2 in S4Hana to V4 service?