Gateway Query with too many filters

[Former Member]

Hi Experts, Im trying to develop a query service to get material price from ECC, this requirements is for all items therefore I need to recieve in ECC header information, item information and price conditions for each item, as you can see there are a lot of properties fields that con not be received in 'get_entity_set' method  with filter option, does any body know any option to do that? I'm working in a Sap NetWeaver 7.4, using the SEGW transaction. Any sugestion would be appreciated.

[kammaje_cis]

Create multiple Entities and link them with Association and Navigations as Kedar said.

Use query option $expand to fetch all entities at a time. (Google odata $expand).

[kedarT]

Hi Gerardo,

How about using Associations with entities, look at this blog -

Hope this helps.