Show TOC

Procedure documentationEnabling Customization of Table Views at Runtime Locate this document in the navigation structure

 

Visual Composer Web Dynpro runtimes (Web Dynpro HTML and Web Dynpro Flex) are integrated with SAP List Viewer (ALV). SAP List Viewer enables users to manipulate tabular data and resize the table at runtime. For example, runtime users can modify the data display; print data; save personalized settings; sort, filter, and group data; and add calculations.

Using Visual Composer Storyboard, you can specify which additional functionality runtime users are able to access, and you can also define default display settings for tables at runtime. For a description of the runtime functionality provided by SAP List Viewer, see SAP List Viewer for Web Dynpro for Java.

To use these customization features at runtime, the runtime user must enable CCM personalization. For more information, see Enabling CCM Personalization of Table Views at Runtime.

Prerequisites

The table for which you want to define SAP List Viewer settings is selected on the Design board.

Procedure

  1. From the task panel toolbar, choose Configure.

  2. To make ALV options available to users at runtime, expand the List Viewer Configuration property group and select the properties that you want. For the description of each of the properties, see the table below:

    Property

    Description

    Print

    Displays the Print Version button on the table at runtime, which enables the runtime user to print the table and its data to Adobe Acrobat format (PDF).

    Export

    Displays the Export button on the table at runtime, which enables the runtime user to export the table data to a spreadsheet-compatible format.

    Filter

    Displays the Filter button on the table at runtime, which enables the runtime user to filter the table data in any way required.

    Settings

    Displays the Settings button on the table at runtime, which enables the runtime user to open the Settings dialog box in which they can specify personalized display settings for the table and its data.

    If you choose to display this option, you can then choose which areas to display in the Settings dialog box at runtime. You can choose one or more of the following areas:

    • Column selection: Enables the runtime user to specify which columns should be displayed in the table, and the order of the columns.

    • Sort sequence: Enables the runtime user to define how the table data should be sorted (by which column(s)) and the direction of the sort.

    • Calculation: Enables the runtime user to perform different calculations on the table data and specify how the calculations should be displayed.

    • Views: Enables the runtime user to save different personalized views of the table data and display them as required.

    Grouping

    Enables the runtime user to group table data according to a specific control.

    Group by

    Specifies the control by which data should be grouped by default. The runtime user can change the grouping as required.

    This option is available only if the Grouping checkbox is selected.

    Display type

    Enables the runtime user to choose whether to display the data in table or graphical format, or both. It also enables the runtime user to define the chart type and chart properties to be used for the graphical format (in the Display tab of the Settings dialog box).

    Show calculations at top

    Specifies whether calculations are displayed in a row at the top of the table or the bottom of the table.

    Displayed cols

    Defines the number of columns to be displayed at one time at runtime. The number of displayed columns is in addition to the number of fixed columns defined using the Fixed cols property. Additional columns can be displayed at runtime by using the horizontal scroll bar. Specify zero to display all columns at once (without a horizontal scroll bar).

    Fixed cols

    Specifies the number of columns that should be fixed (frozen) on the left of the table. Fixed columns are not scrolled when the runtime user uses the horizontal scroll bar to scroll through columns in the table.

  3. To specify any initial sort or calculation settings that you want to apply at runtime to the table, expand the Initial Settings property group and select the properties that you want. For a description of each of the properties, see the table below:

    Property

    Description

    Sort Order

    Defines the initial sort order for the runtime table data. You can define the control(s) by which to sort the data, the direction of the sort (ascending or descending), and whether to display a calculation row after each grouping within the sort order.

    Calculation

    Defines calculations to be performed by default on controls with bound numeric fields in the runtime table data. You can choose from the following calculation types for each control that is bound to a numeric field: Average, Maximum, Minimum, and Total.

Result

At runtime, the application user can utilize the functionality you have selected to manipulate the data displayed in the table view.