Skip to Content
0
Oct 14, 2020 at 10:10 AM

How to return a deep entityset

73 Views

Hi,

Can anyone provide a suggestion for how to fetch an entityset with tables/collections in it?

I'm fetching material masterdata from backend (S/4 1909) to an offline odata store.

{ material
  material_group
  units [
          { unit_iso
            ean }
          ]

As you can see, I need a table below each entity with additional EAN numbers and their unit. Is the only way to do this to use $expand? The problem, the way I see it, is that I want to fetch all data in one call (one DB call) instead of a lot of expands, as the EAN's should be available for barcode scanning.