CDS View for tree table

[vinayaknath_singh]

Hi,

I have a requirement where I have to show Purchase Order and Purchase Order item in a tree structure. All purchase order items should be shown as child of purchase order.

There will be a filter bar above tree table where we will enter search filed to search Purchase Order/Purchase order Item.

For this I have created a CDS which returns all Purchase order Items in a linear structure. But to show data in tree structure, I have to make it hierarchical? What is best way to do it?

Regards,

Vinayak

[Attila]

Hi Vinayak,

maybe this is helpful, it is about CDS hierarchical annotations:
https://help.sap.com/saphelp_nw75/helpdata/en/23/473e6a8b1c4da2b0ba5be4f319a16c/content.htm?frameset...

Maybe you can combine it with one of the below controls with small efforts (I'm planning to do such combination after we upgraded to NW 7.51, at the moment I load the data from the backend and build the tree manually into a JSON model and use the first control.At the moment we are on a low NW release and do not have the possibility to implement this more simple, onyl using JSON using ABAP backend):

https://sapui5.hana.ondemand.com/explored.html#/entity/sap.ui.table.TreeTable/samples

https://sapui5.hana.ondemand.com/explored.html#/entity/sap.m.Tree/samples

OData service example with annotations for tree/hierarchy representation:
https://blogs.sap.com/2015/10/23/treetable-odata-binding/

The service should be called on first level and every time you expand a node.

Regards

Attila