topic Re: Nested Navigation in CDS OData in Application Development and Automation Discussions

Nested Navigation in CDS OData

winultimate — Tue, 07 May 2019 07:06:17 GMT

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?

Re: Nested Navigation in CDS OData

winultimate — Thu, 09 May 2019 11:09:33 GMT

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

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

Re: Nested Navigation in CDS OData

pokrakam — Wed, 24 Jul 2019 14:28:06 GMT

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

Re: Nested Navigation in CDS OData

winultimate — Wed, 31 Jul 2019 08:45:27 GMT

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

Re: Nested Navigation in CDS OData

LeonvNiekerk — Tue, 22 Aug 2023 11:16:02 GMT

I found the following:

https://help.sap.com/docs/SAP_NETWEAVER_AS_ABAP_752/cc0c305d2fab47bd808adcad3ca7ee9d/ed2ed4e2cbc54ffdba3aead4f3a73640.html

Re: Nested Navigation in CDS OData

ex_bassam — Fri, 29 Sep 2023 00:25:54 GMT

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.