Table Features

Discover / Frameworks / SAP Fiori Elements / Tables and Lists / Table Features
information

No longer maintained, this article reflects the SAPUI5 version 1.136 release of SAP Fiori Elements for OData V2 and SAP Fiori Elements for OData V4.

To explore the design capabilities of SAP Fiori elements for OData V4 and the various options for the building blocks, and to experiment with their behavior – both standalone and when used in standard floorplans or custom pages, see: the SAP Fiori Development Portal.

information

No longer maintained, this article reflects the SAPUI5 version 1.136 release of SAP Fiori Elements for OData V2 and SAP Fiori Elements for OData V4.

For information on the latest release of both versions of SAP Fiori Elements, see: What's New in SAPUI5 documentation.

To explore the design capabilities of SAP Fiori elements for OData V4 and the various options for the building blocks, and to experiment with their behavior – both standalone and when used in standard floorplans or custom pages, see: the SAP Fiori Development Portal.

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

<div> <div> <h4 id="table-settings">Table Settings</h4> </div> <div> <h4 id="availability">Availability</h4> </div> </div> <div> <div>Column Header Labels</div> <div>You set these.</div> </div> <div> <div>Asterisk in Labels for Mandatory Fields</div> <div>In the object page, by default, a red asterisk (*) displays in the column header label for mandatory table fields with SAP Fiori elements for OData V4.</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23tooltips-on-column-headers">Tooltips on Column Headers</a></div> <div>Default</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23clear-all--select-all">Clear All</a></div> <div> <p>The <em>Clear All</em> <span class="icon icon-clear-all"></span>checkbox is displayed by default in both the list report and object page when the selection of multiple rows is enabled for:</p> <ul> <li>Grid tables</li> <li>Analytical tables</li> <li>Tree tables</li> </ul> <p>You can change the default.</p> </div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23clear-all--select-all">Select All</a></div> <div> <p>The <em>Select All</em> <span class="icon icon-border"></span>checkbox is displayed by default when the selection of multiple rows is enabled for a responsive table.</p> <p>You can change the default.</p> </div> </div> <div> <div>Sticky Column Header Behavior</div> <div>Default, you can turn it off.</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23column-width">Column Width</a></div> <div>The default width depends on the column contents. You can change it.</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23column-importance-in-responsive-tables">Column Importance</a></div> <div> <p>In a responsive table, by default, all columns have an importance of none, <strong>except</strong> for list report columns for key fields. These have high importance.</p> <p>You can change the level of importance.</p> </div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23freezing-columns">Freezing Columns</a></div> <div>Available in analytical tables, grid tables, and tree tables for the number of columns that you decide.</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23labels-for-multiple-fields-in-a-column">Labels for Multiple Fields in a Column</a></div> <div>Available in responsive tables with SAP Fiori elements for OData V4</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23sort-order">Ascending Sort Order on a Column</a></div> <div>Default, you can change it.</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23quick-sort-on-a-column">Quick Sort on a Column</a></div> <div>Available</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23grouping">Grouping</a></div> <div>Available in responsive and analytical tables, not in grid tables</div> </div> <div> <div>Filters on Aggregation</div> <div> <p>Available in analytical tables with SAP Fiori elements for OData V4.</p> <p>You can set filters on aggregated measures.</p> </div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23number-of-table-rows-displayed-at-once">Number of Table Rows Displayed at Once</a></div> <div>Work with the development team to find the <strong>best compromise</strong> between optimal user experience and optimal technical performance.</div> </div> <div> <div><a href="https%3A%2F%2Fsap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23no-data-found-message">No Data Found Message</a></div> <div> <p>By default:</p> <ul> <li>An illustrated message with generic placeholder text is displayed with SAP Fiori elements for OData V4. You can add an action to it. You can change it to a text-only message, as required.</li> <li>Generic placeholder text is displayed with SAP Fiori Elements for OData V2</li> </ul> <p>Replace the generic text with text that’s meaningful to the user.</p> </div> </div> <div> <div>Message Strip above the Table</div> <div> <p>You can display a custom message above the table in the:</p> <ul> <li>List report, object page, and analytical page with SAP Fiori elements for OData V2</li> <li>List report with SAP Fiori elements for OData V4</li> </ul> <p>In the object page, by default, a message strip is displayed when there are errors in the table.</p> <p>When there are multiple messages, the one with the highest severity is displayed.</p> </div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23generic-context-menu">Generic Context Menu</a></div> <div>Activated by default for all table types in the list report, object page, and analytical list report. It cannot be deactivated.</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23tree-table-context-menu">Tree Table Context Menu</a></div> <div>Default with SAP Fiori elements for OData V4</div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23order-of-nodes-in-the-tree-table">Order of Nodes in the Tree Table</a></div> <div> <p>With SAP Fiori elements for OData V4, by default, the tree table always displays a newly created node as the first in the table or as the first child below its parent node, even when a sort or a filter is applied to the table.</p> <p>You can change the default.</p> </div> </div> <div> <div> <h4 id="list-report-and-analytical-page-only">List Report and Analytical Page Only</h4> </div> <div> <h4 id="availability-1">Availability</h4> </div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23initial-expansion-of-table-levels">Number of Table Levels Expanded at Initial Load</a></div> <div>Default, you can change the number for the tree table and analytical table.</div> </div> <div> <div> <h4 id="list-report-only">List Report Only</h4> </div> <div> <h4 id="availability-2">Availability</h4> </div> </div> <div> <div>Copy</div> <div>Available</div> </div> <div> <div> <h4 id="object-page-only">Object Page Only</h4> </div> <div> <h4 id="availability-3">Availability</h4> </div> </div> <div> <div><a href="https%3A%2F%2Fwww.sap.com%2Fdesign-system%2Ffiori-design-web%2Fdiscover%2Fframeworks%2Fsap-fiori-elements%2Ftables-and-lists%2Ftable-features-sap-fiori-elements%23message-strip-for-rows-with-errors">Message Strip for Rows with Errors</a></div> <div>Default</div> </div> <div> <div>Rows Displayed in a Grid Table</div> <div> <p>Depends on the table height, which adjusts to the available onscreen space for an object page with:</p> <ul> <li>Anchor bar navigation and a single section that contains only a grid table</li> <li>Tab bar navigation and a current tab that contains only a grid table</li> </ul> </div> </div>

Table Settings

Tooltips on Column Headers

On desktop applications, all table columns display tooltips, based on the text in:

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 :icon-clear-allcheckbox is displayed by default in the selection column header for all tables, but the responsive table. You can change the default.

information
To select a range of items when the Clear All :icon-clear-allcheckbox is displayed, users can select an item, press Shift, and select others.
<div> <div> <h4 id="table-type">Table Type</h4> </div> <div> <h4 id="selection-default">Selection Default</h4> </div> <div> <h4 id="users-can-select">Users Can Select</h4> </div> </div> <div> <div> <p>Grid table</p> <p>Analytical table</p> <p>Tree table</p> </div> <div><em>Clear All</em><span class="icon icon-clear-all"></span></div> <div> <p>Up to 200 rows by default</p> <p>We recommend you consult the application development team on how changes to the limit would impact performance.</p> </div> </div> <div> <div>Responsive table</div> <div><em>Select All</em><span class="icon icon-border"></span></div> <div> <p>All the rows displayed on the interface, <strong>not all the rows in the table</strong>.</p> <p>A message informs users that “Only the first <em>n</em> of the items you selected were added to the selection,” where “<em>n</em>” equals the number of items loaded on the interface.</p> </div> </div>
warning

For grid tables, analytical tables, and tree tables, changing the default Clear All :icon-clear-allcheckbox to the Select All :icon-bordercheckbox can lead to performance issues because Select All :icon-borderloads all the table rows to the frontend.

Always ask the application development team about the impact on performance before you consider such a change.

guideline
When the object page is in tab bar mode, we recommend enabling the Clear All :icon-clear-allwhen the selection of multiple rows is enabled.

Column Width

The default column width varies according to the column contents:

You can change the width.

You can also ask the application developers to ensure the column width takes into account the contents of both the column and the column header.

hint
For more information, refer the development team to Setting the Default Column Width.

Column Importance in Responsive Tables

By default:

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:

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.

hint
For more information, refer application developers to Tables.

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:

For more information, see the sort guidelines according to table type:

Quick Sort on a Column

Available for any sortable column.

When a column contains a combination of fields, such an ID and a description or a field group, the users can specify a sort and sort order for each field in the column with the quick sort.

Number of Table Rows Displayed at Once

Responsive Table

By default, a responsive table loads the following number of rows at once:

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.

Tree Table, Analytical Table, and Grid Table

By default, when the object page has the default anchor bar navigation or when an object page section contains controls besides the table:

When more rows exist, the users can scroll to display them.

With SAP Fiori elements for OData V4, the default number of rows can be changed.

guideline
Use icon tab bar navigation when you use the grid table because the anchor bar navigation results in the display of two scroll bars – one for the object page and one for the grid table.
Row Display on Scroll

To optimize the display of rows as the users scroll, the grid table, analytical table, and tree table preload a default of 300 table rows from the backend. The application developer can change the default number as required for the use case.

guideline
Work with the development team to find the best compromise between optimal user experience and optimal technical performance.

Grouping

Grouping is available in responsive and analytical tables.

You can define the format of the grouping headers.

For more information, see:

No Data Found Message

By default:

guideline

Replace the placeholder text with text that’s meaningful to the user.

For more information, see: Replacing Placeholder Text

Generic Context Menu

For desktop and mobile applications, a generic context menu is activated and cannot be deactivated for all table types in the list report, object page, and analytical page.

The generic context menu generally behaves like the standard context menu described in the corresponding table articles, linked below.

The context of the generic context menu can be either a single row or multiple selected rows.

Single row context - a non-selected row is the "click target" so the context menu applies to the non-selected row

Single row context - a non-selected row is the

Multiple row context - one or more selected rows are the "click target " so the context menu applies to all the selected rows

Multiple row context - one or more selected rows are the

Actions

The following actions are always available on the generic context menu:

information
The Open in New Tab or Open in New Window action does not display in the context menu when the table is configured to navigate to an object page in edit mode.

For information on the standard context menu, see:

Tree Table Context Menu

With SAP Fiori elements for OData V4, the context menu for tree tables contains the actions from the generic context menu, and the actions specific to the tree table for example:

Bounded Create

The bounded Create action is active in the context menu for a single container node or leaf node. The new item is created as a child of the selected node.

When multiple items are selected, it is inactive.

A “bounded action” is one that becomes active only after item selection.

Move Up, Move Down

The Move Up and Move Down actions are active in the context menu for a single container node or leaf node, and the action is relevant for the node.

When the action is not relevant, the menu displays it as inactive. For example, in the context menu for the last node in a container node, the Move Up action is active and the Move Down action is inactive.

The actions aren’t in the context menu when multiple items are selected.

Expand All, Collapse All

The Expand All and Collapse All actions are active in the context menu for a single container node, and the action is relevant to the node’s current state.

The actions are in an inactive state in the context menu for a:

Paste

The paste action behaves differently, depending on the data structure in the backend table.

For a non-hierarchical data structure, when the users paste to a container node or leaf node at level n, the data is pasted as a child or children to the node at level n+1.

For a hierarchical data structure, when the users paste to:

Order of Nodes in the Tree Table

With SAP Fiori elements for OData V4, by default, a newly created node is always displayed first in the table or as the first child below its parent node, even when a sort or a filter is applied to the table. For example, a node created:

Instead, you can enable an option to display new nodes in the order that they were created in the table or parent node. For example, a node created:

This feature allows users to act directly on the table hierarchy — not just its display — when they:

information
  • With this feature, a message [strip/toast] informs the user when the filter criteria applied to a table prevents a new node from being displayed.
  • For backend systems on RAP, this feature is unavailable for tree tables in a list report.
hint
For more information, refer application developers to Tree Tables.

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:

You can change the default value for the tree table and analytical tables.

hint
For more information, refer the development team to Initial Expansion Level for Tables in List Reports & Analytical List Pages.

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.

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.