SAP Tutorials Blog



DATA root_id TYPE demo_cds_simple_tree_view-id.


DATA max_id TYPE demo_cds_simple_tree_view-id.


...


SELECT FROM HIERARCHY_ANCESTORS(

              SOURCE demo_cds_simple_tree( p_id = @root_id )

              START WHERE id = @max_id )

  FIELDS id,

          parent_id,

          name,

          hierarchy_distance

  INTO TABLE @FINAL(ancestors).


Serkan AKKAVAK

Computer Engineer BSc

Head of SAP & Software Department

Contact : serkurumsal@yandex.com