Table Features
Intro
The SAP Fiori elements templates support the features and settings for a table detailed below.
For design information see the table guidelines, starting with Table Overview, and the links within this article.
Feature Availability
[internal_only]
Table Settings
Availability
The
Clear All
checkbox is displayed by default in both the list report and object page when the selection of multiple rows is enabled for:
- Grid tables
- Analytical tables
- Tree tables
You can change the default.
The
Select All
checkbox is displayed by default when the selection of multiple rows is enabled for a responsive table.
You can change the default.
In a responsive table, by default, all columns have an importance of none,
except
for list report columns for key fields. These have high importance.
You can change the level of importance.
You can display a custom message above the table in the:
- List report, object page, and analytical page with SAP Fiori elements for OData V2
- List report with SAP Fiori elements for OData V4
In the object page, by default, a message strip is displayed when there are errors in the table.
When there are multiple messages, the one with the highest severity is displayed.
List Report and Analytical Page Only
Availability
List Report Only
Availability
Object Page Only
Availability
Depends on the table height, which adjusts to the available onscreen space for an object page with:
- Anchor bar navigation and a single section that contains only a grid table
- Tab bar navigation and a current tab that contains only a grid table
[/internal_only][external_only]
Table Settings
Availability
When the selection of multiple rows is enabled, the
Clear All
checkbox is displayed by default in both the list report and object page for:
- Grid tables
- Analytical tables
- Tree tables
You can change the default
When the selection of multiple rows is enabled for a responsive table in an object page, the
Select All
checkbox is displayed by default.
You can change the default.
In a responsive table, by default, all columns have an importance of none,
except
for list report columns for key fields. These have high importance.
You can change the level of importance.
You can display a custom message above the table in the:
- List report, object page, and analytical page with SAP Fiori elements for OData V2
- List report with SAP Fiori elements for OData V4
In the object page, by default, a message strip is displayed when there are errors in the table.
When there are multiple messages, the one with the highest severity is displayed.
List Report and Analytical Page Only
Availability
Object Page Only
Availability
Depends on the table height, which adjusts to the available onscreen space for an object page with:
- Anchor bar navigation and a single section that contains only a grid table
- Tab bar navigation and a current tab that contains only a grid table
[/external_only]
Table Settings
Tooltips on Column Headers
On desktop applications, all table columns display tooltips, based on the text in:
Common.QuickInfo
, when it’s visible- The column label, in all other cases
Tooltips are available only in desktop applications because users must hover their mouse on the column header to see them.
Clear All / Select All
When the selection of multiple rows is enabled for a table in the list report and object page, the Clear All checkbox is displayed by default in the selection column header for all tables, but the responsive table. You can change the default.
Table Type
Selection Default
Users Can Select
Grid table
Analytical table
Tree table
Up to 200 rows by default
We recommend you consult the application development team on how changes to the limit would impact performance.
All the rows displayed on the interface,
not all the rows in the table
.
A message informs users that “Only the first n of the items you selected were added to the selection,” where “n” equals the number of items loaded on the interface.
For grid tables, analytical tables, and tree tables, changing the default Clear All checkbox to the Select All checkbox can lead to performance issues because Select All loads all the table rows to the frontend.
Always ask the application development team about the impact on performance before you consider such a change.
Column Width
The default column width varies according to the column contents:
- Text: can range from 3 to 20 rem
- Image: 5 rem
- Rating or progress indicator: 6.875 rem
- Chart: 20 rem
You can can change the width.
With SAP Fiori elements for OData V4, you can also ask the application developers to ensure the column width is adjusted to both the contents of the column and the column header.
Column Importance in Responsive Tables
By default:
- Key fields have high importance in list reports.
- Other columns have the importance of none and are handled like columns assigned medium importance.
You can change the level of importance.
The importance assigned to a column determines whether or not the table displays its values onscreen when screen space is limited:
- The values from high importance columns are always displayed onscreen — as columns or in the pop-in area, depending on the screen size.
- The values in columns with low importance are first to be hidden.
When at least one column is hidden, the table toolbar displays the Show Details button so users can view the previously hidden columns in the table pop-in area. After the user clicks Show Details to display the column, the action changes to Hide Details.
You can also assign an importance to custom columns.
For more information, see:
Freezing Columns
You can freeze the first columns of an analytical table, grid table, or tree table so that they always remain visible when the users scroll the table horizontally. You specify the number of columns.
Labels for Multiple Fields in a Column
By default, with SAP Fiori elements for OData V4, when a column contains a field group with more than one field, the labels for those fields are not displayed.
You can enable the display of a label for each field. The field group label then is displayed as the column title in the header.
Sort Order
By default, the sort order for a column is ascending.
You can:
- Set the default sort order to descending.
- Define other, customized sort orders.
For more information, see the sort guidelines according to table type:
Number of Table Rows Displayed at Once
By default, a responsive table loads the following number of rows at once:
- 20 rows in a list report.
- 10 rows in an object page with multiple sections.
When more rows exist, the users can click the More button at the end of the table to view additional rows.
With SAP Fiori elements for OData V2, you can change the default number.
For an object page that includes one section and one subsection, the responsive table loads 20 rows and the user can scroll to view additional ones.
Grouping
Grouping is available in responsive and analytical tables.
You can define the format of the grouping headers.
[internal_only][/internal_only]
Grouped Totals in Analytical Tables
For now, with SAP Fiori elements for OData V4, in an analytical table where a group contains items with different units of measure — for example the sales revenue for different countries in different currencies — the grouped total has an asterisk (*) next to it, not a number. These totals cannot yet be calculated.
Example
For more information, see:
No Data Found Text
By default, the following text is displayed when no data is found.
- When the user has not applied filters, the text is “No data found.”
- When the user has applied filters from the personalization dialog, the text is: “No data found. Try adjusting the search or filter parameters.”
List Report and Analytical Page Only
Initial Expansion of Table Levels
By default, on initial load, the following expandable tables are expanded to this number of levels:
- Responsive table: 1 level
- Tree table: 1 level
- Analytical table: 0 levels
You can change the default value for the tree table and analytical tables.
Object Page Only
Message Strip for Rows with Errors
When table rows contain errors, a message strip is displayed above the table. It contains a Filter Items link that lets users see only the rows with errors. After the users click the link, a Clear Filter link replaces it.
Related Links
Elements and Controls
- Table Overview (guidelines)
- Table Personalization & Dialogs (guidelines)
- List Report Floorplan (guidelines)
- Object Page Floorplan (guidelines)