Link Search Menu Expand Document
All libraries

Basic table example

To represent table in a template you have to declare it as a internal table

    " Document structure
    BEGIN OF ts_root,
      footer   TYPE string,
      header   TYPE string,
      t        TYPE tt_rand_data, " internal flat table ( In template {R-T} )
      date     TYPE d,            " 8
      time     TYPE t,            " 6
      datetime TYPE char14,       " date(8) + time(6)
    END OF ts_root.

Where tt_rand_data is a standard table

      " Random table data
      BEGIN OF ts_rand_data,
        group   TYPE string,
        caption TYPE string,
        date    TYPE d,
        sum1    TYPE p LENGTH 13 DECIMALS 2,
        sum2    TYPE p LENGTH 13 DECIMALS 2,
      END OF ts_rand_data,
      tt_rand_data TYPE STANDARD TABLE OF ts_rand_data WITH DEFAULT KEY,

The template

The pattern for rows can take several rows (From row with first {R-T} to the last one)

Data filling

    " {R-T} in a temaplte. @see get_random_table description
    ls_root-t      = cl_main=>get_random_table( ).

    " For printing
    ls_root-footer = 'Footer'.
    ls_root-header = 'Header'.



The final result for MS Word

All list objects in Excel with corresponding formulas would be properly zoomed.

Ctl + F3

image

Also data validation are expanding automatically image

Formulas with scope are supported (Worksheet or Workbook)
Including “Print titles”

image