Type Template Report
Excel Download template Download report
Excel Download template Download report
Excel XML Download template Download report
Generate this example Choose a template and create a fresh report with the demo service.

xtt->merge( iv_block_name = 'R' is_block =

JSON 
{"TITLE":"Title","T":[{"DIR":"R:","PAR_DIR":"","LEVEL":0,"SUM":2446345.0,"HAS_CHILDREN":"X"},{"DIR":"R:\\docProps","PAR_DIR":"R:","LEVEL":1,"SUM":597144.0,"HAS_CHILDREN":""},{"DIR":"R:\\xl","PAR_DIR":"R:","LEVEL":1,"SUM":1804679.0,"HAS_CHILDREN":"X"},{"DIR":"R:\\xl\\printerSettings","PAR_DIR":"R:\\xl","LEVEL":2,"SUM":502146.0,"HAS_CHILDREN":""},{"DIR":"R:\\xl\\theme","PAR_DIR":"R:\\xl","LEVEL":2,"SUM":227675.0,"HAS_CHILDREN":""},{"DIR":"R:\\xl\\worksheets","PAR_DIR":"R:\\xl","LEVEL":2,"SUM":771720.0,"HAS_CHILDREN":"X"},{"DIR":"R:\\xl\\worksheets\\_rels","PAR_DIR":"R:\\xl\\worksheets","LEVEL":3,"SUM":771720.0,"HAS_CHILDREN":""},{"DIR":"R:\\xl\\_rels","PAR_DIR":"R:\\xl","LEVEL":2,"SUM":303138.0,"HAS_CHILDREN":""},{"DIR":"R:\\_rels","PAR_DIR":"R:","LEVEL":1,"SUM":44522.0,"HAS_CHILDREN":""}],"C":[{"LEVEL":0,"SUB_NODES":[{"NAME":"R:\\docProps","ATTR":{"LEVEL":1,"SUB_NODES":[],"DATA":{"DIR":"R:\\docProps","PAR_DIR":"R:","LEVEL":1,"SUM":597144.0,"HAS_CHILDREN":""}}},{"NAME":"R:\\xl","ATTR":{"LEVEL":1,"SUB_NODES":[{"NAME":"R:\\xl\\printerSettings","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"DIR":"R:\\xl\\printerSettings","PAR_DIR":"R:\\xl","LEVEL":2,"SUM":502146.0,"HAS_CHILDREN":""}}},{"NAME":"R:\\xl\\theme","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"DIR":"R:\\xl\\theme","PAR_DIR":"R:\\xl","LEVEL":2,"SUM":227675.0,"HAS_CHILDREN":""}}},{"NAME":"R:\\xl\\worksheets","ATTR":{"LEVEL":2,"SUB_NODES":[{"NAME":"R:\\xl\\worksheets\\_rels","ATTR":{"LEVEL":3,"SUB_NODES":[],"DATA":{"DIR":"R:\\xl\\worksheets\\_rels","PAR_DIR":"R:\\xl\\worksheets","LEVEL":3,"SUM":771720.0,"HAS_CHILDREN":""}}}],"DATA":{"DIR":"R:\\xl\\worksheets","PAR_DIR":"R:\\xl","LEVEL":2,"SUM":771720.0,"HAS_CHILDREN":"X"}}},{"NAME":"R:\\xl\\_rels","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"DIR":"R:\\xl\\_rels","PAR_DIR":"R:\\xl","LEVEL":2,"SUM":303138.0,"HAS_CHILDREN":""}}}],"DATA":{"DIR":"R:\\xl","PAR_DIR":"R:","LEVEL":1,"SUM":1804679.0,"HAS_CHILDREN":"X"}}},{"NAME":"R:\\_rels","ATTR":{"LEVEL":1,"SUB_NODES":[],"DATA":{"DIR":"R:\\_rels","PAR_DIR":"R:","LEVEL":1,"SUM":44522.0,"HAS_CHILDREN":""}}}],"DATA":{"DIR":"R:","PAR_DIR":"","LEVEL":0,"SUM":2446345.0,"HAS_CHILDREN":"X"}}]}

).
Generate demo 060

Tree (group by field relations)

Request preview

Purpose

Demo ZCL_XTT_DEMO_060 handles hierarchies whose depth is not known in advance, such as folders, WBS elements, or HR organizational units. Each row identifies a node and its parent; TREE_CREATE_RELAT turns those relations into an XTT tree.

Define the node structure

Folders hierarchy

      BEGIN OF ts_tree_06,
        " Folders hierarchy
        dir     TYPE string,
        par_dir TYPE string,
        
        " Empty field. Filled in on_prepare_tree_06
        level   TYPE i,
      END OF ts_tree_06,
      tt_tree_06 TYPE STANDARD TABLE OF ts_tree_06 WITH DEFAULT KEY,

    " Document structure
    BEGIN OF ts_root,
      title TYPE string,
      t     TYPE REF TO data, " <-- Table of trees (better to use general REF TO)
    END OF ts_root.

Build the relation tree

After filling LT_FOLDERS, pass the node-key and parent-key component names to TREE_CREATE_RELAT:

    GET REFERENCE OF lt_folders INTO lr_table.
    ls_root-t = zcl_xtt_replace_block=>tree_create_relat(
      it_table      = lr_table        " from 7.5 REF #(lt_folders)
      iv_node_key   = 'DIR'
      iv_relat_key  = 'PAR_DIR' ).

Enrich generated nodes

Use the PREPARE_TREE event to calculate parent values or add hierarchy metadata. The demo stores only the generated depth in LEVEL:

METHOD on_prepare_tree_06.
  FIELD-SYMBOLS:
    <ls_data>     TYPE ts_tree_06.

  " Cast to the application type
  ASSIGN ir_data->* TO <ls_data>.
  <ls_data>-level = ir_tree->level.
ENDMETHOD.

Excel outline settings are copied to the generated child rows.