SAP Tutorials Blog


 


DATA root_id TYPE demo_cds_simple_tree_view-id.


...


SELECT FROM HIERARCHY( SOURCE demo_cds_simple_tree_view

                       CHILD TO PARENT ASSOCIATION _tree

                       START WHERE id = @root_id

                       SIBLINGS ORDER BY id

                       MULTIPLE PARENTS NOT ALLOWED ) "hierarchy

       FIELDS id,

              parent,

              name,

              hierarchy_rank,

              hierarchy_tree_size,

              hierarchy_parent_rank,

              hierarchy_level,

              hierarchy_is_cycle,

              hierarchy_is_orphan,

              node_id,

              parent_id

       INTO TABLE @FINAL(asql_cds_result).


ASSERT asql_cds_result = cds_result.


Serkan AKKAVAK

Computer Engineer BSc

Head of SAP & Software Department

Contact : serkurumsal@yandex.com