Define Table(CDS) with nested structure like JSON

[SBasu1234]

Hi Everyone

I want to create a 'define table ' with CDS view just like the below nested json

Later I would like to use this in fiori app also hence please suggest how to do

[sajid-khan]

Hi,

You're looking for association in CDS views. You'll have to create two CDS views and define association between those with 1..n cardinality (based on your screenshot).

Also checkout this blog post to get an Idea of how it might work with odata for your fiori app