SAP Tutorials Blog


 


DATA root_id TYPE demo_cds_simple_tree_view-id.


DATA sub_id TYPE demo_cds_simple_tree_view-id.


...


SELECT FROM HIERARCHY_DESCENDANTS(

              SOURCE demo_cds_simple_tree( p_id = @root_id )

              START WHERE id = @sub_id  )

  FIELDS id,

         parent_id,

         name,

         hierarchy_distance

  INTO TABLE @FINAL(descendants).


Serkan AKKAVAK

Computer Engineer BSc

Head of SAP & Software Department

Contact : serkurumsal@yandex.com