- Latest Version 1.128
- Version 1.126
- SAPUI Version 1.124
- SAPUI5 Version 1.122
- SAPUI5 Version 1.120
- SAPUI5 Version 1.118
- SAPUI5 Version 1.116
- SAPUI5 Version 1.114
- SAPUI5 Version 1.112
- SAPUI5 Version 1.110
- SAPUI5 Version 1.108
- SAPUI5 Version 1.106
- SAPUI5 Version 1.102
- SAPUI5 Version 1.100
- SAPUI5 Version 1.98
- SAPUI5 Version 1.96
- SAPUI5 Version 1.94
- SAPUI5 Version 1.92
- SAPUI5 Version 1.90
- SAPUI5 Version 1.88
- SAPUI5 Version 1.86
- SAPUI5 Version 1.84
- SAPUI5 Version 1.82
- SAPUI5 Version 1.80
- SAPUI5 Version 1.78
- SAPUI5 Version 1.76
- SAPUI5 Version 1.74
- SAPUI5 Version 1.72
- SAPUI5 Version 1.70
- SAPUI5 Version 1.68
- SAPUI5 Version 1.66
- SAPUI5 Version 1.64
- SAPUI5 Version 1.62
- SAPUI5 Version 1.60
- SAPUI5 Version 1.58
- SAPUI5 Version 1.56
- SAPUI5 Version 1.54
- SAPUI5 Version 1.52
- SAPUI5 Version 1.50
- SAPUI5 Version 1.48
- SAPUI5 Version 1.46
- SAPUI5 Version 1.44
- SAPUI5 Version 1.42
- SAPUI5 Version 1.40
- SAPUI5 Version 1.38
- SAPUI5 Version 1.36
- SAPUI5 Version 1.34
- SAPUI5 Version 1.32
- SAPUI5 Version 1.30
- SAPUI5 Version 1.28
- SAPUI5 Version 1.26
- Latest Version 1.128
- Version 1.126
- SAPUI Version 1.124
- SAPUI5 Version 1.122
- SAPUI5 Version 1.120
- SAPUI5 Version 1.118
- SAPUI5 Version 1.116
- SAPUI5 Version 1.114
- SAPUI5 Version 1.112
- SAPUI5 Version 1.110
- SAPUI5 Version 1.108
- SAPUI5 Version 1.106
- SAPUI5 Version 1.104
- SAPUI5 Version 1.102
- SAPUI5 Version 1.100
- SAPUI5 Version 1.98
- SAPUI5 Version 1.96
- SAPUI5 Version 1.94
- SAPUI5 Version 1.92
- SAPUI5 Version 1.90
- SAPUI5 Version 1.88
- SAPUI5 Version 1.86
- SAPUI5 Version 1.84
- SAPUI5 Version 1.82
- SAPUI5 Version 1.80
- SAPUI5 Version 1.78
- SAPUI5 Version 1.76
- SAPUI5 Version 1.74
- SAPUI5 Version 1.72
- SAPUI5 Version 1.70
- SAPUI5 Version 1.68
- SAPUI5 Version 1.66
- SAPUI5 Version 1.64
- SAPUI5 Version 1.62
- SAPUI5 Version 1.60
- SAPUI5 Version 1.58
- SAPUI5 Version 1.56
- SAPUI5 Version 1.54
- SAPUI5 Version 1.52
- SAPUI5 Version 1.50
- SAPUI5 Version 1.48
- SAPUI5 Version 1.46
- SAPUI5 Version 1.44
- SAPUI5 Version 1.42
- SAPUI5 Version 1.40
- SAPUI5 Version 1.38
- SAPUI5 Version 1.36
- SAPUI5 Version 1.34
- SAPUI5 Version 1.32
- SAPUI5 Version 1.30
- SAPUI5 Version 1.28
- SAPUI5 Version 1.26
Table Personalization (Overview)
Intro
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
Table Personalization Dialog
All table personalization dialogs are opened via the Settings button on the right-hand side of the table toolbar.
The table personalization dialog can show/hide and reorder columns.
Hide/Show
To show or hide columns, the user only needs to select or deselect the checkboxes of the respective list item. Alternatively, the user can select all the items at once.
Reorder
Two buttons on the left-hand side enable a selected column to be moved up or down.
The user confirms the dialog to apply the options to the table.
For more information, see 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.
P13n Dialog
The P13n Dialog is the most complex personalization option for tables. It is used if none of the other options are sufficient. Like the view settings dialog, it can combine any of the tabs available. By allowing inclusion and exclusion filters, as well as several group options (for some tables only), it can form more complex queries than the other options.
It can also be used for smart chart.
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 Add button (Add Filter), and remove them by clicking the button (Remove Filter) 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, a new line is automatically added as soon as a column is selected (only available for the analytical table).
Resources
Want to dive deeper? Follow the links below to find out more about related controls, the SAPUI5 implementation, and the visual design.
Elements and Controls
- Table Overview (guidelines)
- Table Personalization Dialog (guidelines)
- P13n-Dialog (guidelines)
- View Settings Dialog (guidelines)
Implementation
- Table Personalization (SAPUI5 samples)
- View Settings Dialog (SAPUI5 samples)
- P13n Dialog (SAPUI5 samples)
- Table Personalization Dialog (SAPUI5 API reference)
- Table Personalization Provider (SAPUI5 API reference)