SAPUI5 - oData expand multiple associations

[jakob_steen-petersen]

Hi

I have an oData Entity with multiple associations. Like this:

PurchaseOrder
---> PurchaseOrderItems (PurchaseOrderToItems)

---> PurchaseOrderPartners (Po2Partners)

I can expand the items with

/sap/opu/odata/SAP/ZVDKONTRAKT_SRV/PurchaseOrderSet('4500000313')?$expand=PurchaseOrderToItem

But i wan´t to expand bot in one call. How do i do that?

/sap/opu/odata/SAP/ZVDKONTRAKT_SRV/PurchaseOrderSet('4500000313')?$expand=PurchaseOrderToItem,Po2Partners

Returns error...

Please note: PurchaseOrderPartners is a subset of PurchaseOrder NOT Items!

[sergei-u-niq]

this is how it should work

[vibhor_bhatnagar]

Hi,

You can use multiple levels of $expand:

/sap/opu/odata/SAP/ZVDKONTRAKT_SRV/PurchaseOrderSet('4500000313')?$expand=PurchaseOrderItems($expand=PurchaseOrderToItems),PurchaseOrderPartners($expand=Po2Partners)

[jakob_steen-petersen]

Are you sure if that syntax? I cannot get it to work.

Do we really need 4 times "expand" when i only need to expand 2 associations?

[vibhor_bhatnagar]

Try this:


/sap/opu/odata/SAP/ZVDKONTRAKT_SRV/PurchaseOrderSet('4500000313')?$expand=PurchaseOrderItems/PurchaseOrderToItems,PurchaseOrderPartners/Po2Partners

If this is also not working can you share the metadata ?

[jakob_steen-petersen]

Hi

Don´t know why (maybee i have misspelled..., but i got this to work:

/sap/opu/odata/SAP/ZVDKONTRAKT_SRV/PurchaseOrderSet('4500000313')?$expand=PurchaseOrderToItem,Po2Partners