Table personalization can be used to modify the display and settings of a table.

It is a UI pattern that is used to change one or more of the following attributes:

• Visibility of columns
• Order of columns
• Sorting
• Grouping
• Filtering

Table personalization can be applied to simple tables (up to about 20 columns) and complex tables (more than about 20 columns) using different controls.

Usage

Use the view settings dialog if:

• The user is able to personalize fewer than about 20 columns.
• A combination of sorting, filtering, and grouping is needed.

Use the table personalization dialog if:

• The user is able to personalize fewer than about 20 columns.
• Columns need to be shown/hidden and reordered.

Use the view settings dialog AND the table personalization dialog if:

• The user wants to personalize fewer than about 20 columns.
• A combination of show/hide and one other function is needed.

Use the P13n dialog if:

• You are using an analytical table (ALV).
• The user is able to personalize more than about 20 columns.
• Complex queries have to be built for the respective table.

Do not use table personalization at all if:

• The table has very few columns and rows.
• A very complex filter is needed. In this case, consider using a filter bar instead of the filter tab.

Types

Simple Table Personalization

Table Personalization Dialog

View Settings Dialog

The sort, filter, and group features can all be applied to a table simultaneously.

Sort

The first tab in the view settings dialog is the sort feature, which allows the table content to be sorted according to the chosen attribute.

The dialog offers two sort features:

• The first group sorts the table by a general ascending or descending order.
• The second group lets the user choose an attribute that fits either a column or part of a column since there are also columns that contain more than one data point.

Filter

The second tab in the view settings dialog is the filter feature, which can offer a single filter selection list or a category list. The category list provides an overview and guides the user to detailed filter selection lists via drilldown. The options available are single selection, multiselection, a category list, a predefined list, and a custom filter.

Group

The third tab in the view settings dialog is the group feature, which also offers two groups of attributes:

• The first group offers a general ascending or descending order that controls the order in which the defined groups appear.
• The second group offers attributes with which to group the corresponding data in the table.

Complex Table Personalization

P13n Dialog

Sort
It also allows the user to sort the table content according to the columns that are chosen and in a specific order.

For more complex sorting needs, the user can add the required number of criteria by clicking the  button (Add New Line) at the end of the line.

Filter
A filter option allows the user to filter the table information according to specific filter criteria, which can be included or excluded in the relevant section of the filter.

Each filter criterion consists of a column, an operator (depending on the data type of the column), and a value by which the selected column is filtered.

For more complex cases, the user can add filters by clicking the   button (Add New Line), and remove them by clicking the  button (Remove Line) at the end of each filter item.

Group
The Group tab enables the user to group the table data by one or more columns.

For more complex grouping scenarios, the user can add more grouping options by clicking the   button (Add New Line) at the right-hand side of each grouping line (only available for the ALV table).

Resources