Nested Navigation in CDS OData

[winultimate]

Hello All,

I am creating a CDS view and publishing as an OData.

The expected metadata is something like

Entity_Type: head

-- Navgitaion: to_item

Entity_Type: item

-- Navigation: to_price

Entity_Type: price

This is what I created:

CDS view head (published as OData){ -- association to item, and association publicly exposed }

CDS view item { -- association to price, and association publicly exposed }

CDS view price

But with this, I do not get the Entity_Type price or the navgiation to_price.

Could you please advice on ho I can achieve this?

[winultimate]

Solved myself.
It appears correctly when we create a SEGW service for the CDS.

Strange behavior. Hopefully SAP will correct it in future relases.

[pokrakam]

Hello Sajid,

Thanks for providing the feedback to your own question, I wish more people would do that 🙂

However I'm not sure what you mean by 'created a GW service for the CDS'? When you publish it via the CDS annotation, it puts it into an SAP-internal service. How do you make it Did you create this afterwards or publish one of the intermediate services?

Or did you drop the @odata.publish altogether and referenced the CDSs in a custom GW service?

Thanks,

Mike

[winultimate]

Hello Mike,
Thanks. 🙂
I wish that too.. It feels sad to see that sometimes we see people having a similar issue to ours and have resolved it themselves but no idea on how they did it.

To answer your question.
Yes, I driooed the @OData.publish altogether. And included it as a reference in the GE service that I created

[LeonvNiekerk]

I found the following:

https://help.sap.com/docs/SAP_NETWEAVER_AS_ABAP_752/cc0c305d2fab47bd808adcad3ca7ee9d/ed2ed4e2cbc54ff...

[ex_bassam]

according to this link there is a limitation for creating odata service using auto exposure(@odata.publish annotation)

so it's preferred to create the odata manually using segw and refrence your cds view as the odata model there.