Recursive Hierarchy in CAP

[thomasnelissen]

Hi CAP friends,

I have been struggeling with implementing a recursive hierarchy view in my CAP application.

I have a database table HierachyNode which represents an organisational hierarchy:

Customer Center 1->* Sales Organisation 1->* Country 1->* Customer.

Every node in the hierarcy can have 0...* functionalities, and when we read a node, we want to inhert all functionalities defined in the parnent nodes.

entity HierarchyNodes {<br>    key id                 : String;<br>        name               : String;<br>        parent             : Association to one HierarchyNodes;<br>        level              : Integer;<br>        lineage            : String;<br>        type               : String enum {<br>            CC;<br>            SALESORG;<br>            COUNTRY;<br>            CUSTOMER<br>        };<br>        virtual drillstate : String enum {<br>            expanded;<br>            Leaf;<br>        };<br>        functionalities    : Association to many NodeFunctionalities<br>                                 on functionalities.node = $self;<br>}<br>entity NodeFunctionalities {<br>    key node          : Association to one HierarchyNodes;<br>    key functionality :  String;<br>    key value         : String;<br>}

I found the following blog online about recursive CDS views in ABAP: https://blogs.sap.com/2020/01/13/abap-cds-recursive-association-using-hierarchy/

Is something similar possible in CAP? The annotations used in the blog are throwing errors. Are there examples available?

Happy holidays!

Thomas

[OliverKlemenz · Accepted solution]

Please find an example here:

https://blogs.sap.com/2022/07/01/display-of-hierarchical-data-in-sap-fiori-elements-using-sap-cloud-...

Oliver