Updated: April 22, 2021

Table Toolbar

Intro

The SAP Fiori elements templates support the features and settings for the table toolbar detailed below.

For design information, see the guidelines starting with Table Overview, and see the links below.

Feature Availability

 

Features in List Report and Object Page

 

Availability

Title Mandatory
Table Personalization Actions Default, you can turn them off.
Application-Specific Actions Available
Select All Action Available
Action Disabled Before Row Selection Available
Messages for Critical Actions Available
Messages for Destructive Actions Available
 

List Report-Specific Features

 

Availability

Toolbar Sticky Behavior Default, you can turn it off.
Standard ActionsCreateDelete, and Export to Spreadsheet Default, you can turn them off.
Object Creation via an Object Page Default, you can change it.
Object Creation via a Dialog Available in certain conditions
Hide Draft Values / Show Draft Values Available, with SAP Fiori elements for OData V2 only.
Hiding Actions in Multiple Content Layout Available
 

Object Page-Specific Features

 

Availability

Search Available, when the data allows it.
Edit Default, when the data allows it.
Delete Default, when the data allows it.
Subobject Creation via Subobject Page Default, you can change it.
Subobject Creation via Dialog Available for applications that are not draft-enabled in certain conditions
Create Not Visible In certain conditions
Inline Creation Available, in draft-enabled applications for grid and responsive tables
Prefilling Fields for New Object Creation Available, in draft-enabled applications
Copy and Paste from Microsoft Excel Available, in draft-enabled applications for grid and responsive tables, in certain conditions
Export to Spreadsheet Available

Default, when the copy and paste from Microsoft Excel feature is enabled.

Segmented Button for Switching Table Views Default for a table with a maximum of three views
Select Control for Switching Table Views Default for a table with four or more views

Features in List Report and Object Page

The information below relates to table toolbar actions and settings in both the list report and object page floorplans.


Table Personalization Actions

By default, Sort, Group and Order actions are enabled.

These actions are icon buttons that open the Personalization dialog to the tab for the corresponding action.

For specific use cases, you can disable them. When you do, the user must open the Personalization dialog to access the actions.

For more information, see Table Personalization (Overview).


Application-Specific Actions

You can define these actions and the text displayed on the buttons.

If the action navigates to a different application, the action can be hidden according to the user’s authorization or the screen availability.

For more information, see:



Select All

By default, Select All is hidden with SAP Fiori elements for OData V2. You can display it.

By default, Select All is displayed with SAP Fiori elements for OData V4 when you enable multiple item selection.

When the Select All button is hidden:

  • The user can select a range of multiple items, by selecting an item, pressing SHIFT, and selecting others. When the user selects more items than currently appear onscreen, additional items are loaded from the backend up to a specified limit. The default value for the limit is 200.
  • The Undo Selection button appears for the table, instead of the Select All, and allows the user to clear the selected items.

For a responsive table, enabling the multiple item selection is a prerequisite to enabling the Select All button.

For an analytical table, grid table, or tree table, ask the development team to use the Multi-Selection Plugin.

Warning
To ensure a positive user perception of performance, only display the Select All button for a small number of items.

When the user clicks Select All, all the items or rows load from the backend. Loading many items onscreen can require multiple requests to the system and, consequently, take time.

Developer Hint
For more information, see Enabling Multiple Selection in Tables.


Actions Disabled Until the User Selects a Row

You can set actions in the table toolbar to display as disabled until the user selects one or more table rows for the action.

Note that the development team may call actions that require selection “context-dependent” actions and actions that are enabled without a selection “context-independent” actions.

For more information, see UI Element States.


Messages for Critical Actions

For actions that you set as critical, you can display one of the following after the user triggers the action:

  • A message toast confirmation
  • A confirmation message box to ensure the user wants to proceed with specific critical actions

Also, the backend can require a confirmation on some actions. In this case, the confirmation message is always shown in a message box.

Guidelines
Overwrite the default message text so it’s meaningful to the users, as shown in the example below. Provide the new text to the development team. Then, the development team updates it in the application’s internationalization (i18n) file for the object type.

Ask the development team whether or not the backend requires confirmations for your use case.

Example


SAP Fiori elements for OData V2 SAP Fiori elements for OData V4
Default Text                          “Do you really want to execute the action <Action Label>?”

<Action Label> is the label shown on the button.

“Do you really want to perform this action?
Replacement Text “Are you sure you really want to activate this product?” “Are you sure you really want to activate this product?”


Messages for Destructive Actions

By default, a message is displayed for confirmation of an action that will delete or destroy important data.

Guidelines
Overwrite the default message text so it’s meaningful to the users, as shown in the example below. You do this by providing text that’s more meaningful to the user to the develoment team. The development team updates the text in the application’s internationalization (i18n) file for the object type.

Example


SAP Fiori elements for OData V2 SAP Fiori elements for OData V4
Default Text The default message reuses the title and the description defined for the object in the table.

  • In flexible column layout: Delete object <title> <description>?

    For example, “Delete object 12345 (Sales Order)?”

  • In full screen mode: Delete object <title>?

    For example, “Delete object 12345?”

“Do you really want to perform this action?
Replacement Text “Are you sure you really want to delete this product?” “Are you sure you really want to delete this product?”

List Report-Specific Features

The information below relates only to table toolbar actions and settings in the list report floorplan.


Standard Actions

By default, Create, Delete, and Export to Spreadsheet are enabled.

You can disable them.

You can also enable or disable the Delete button based on conditions specified in the backend.

Example

You can disable deletion for a sales order that has already been paid. When a user selects an item that cannot be deleted, the Delete button is disabled. In addition, if the user navigates from this item in the list report to the object page, the Delete button is hidden.

Guidelines
In a responsive table, if you put a Delete button in the toolbar, do not enable the inline Delete for table rows.

Create Object Actions

By default, the create action via the object page is enabled. The action opens the object page in create mode so the user can enter the data.

You can enable the object creation via a dialog for objects that have 8 fields maximum. The action opens a dialog in modal view so the user can enter the data.

This feature is supported only for:

  • List reports with the single content layout
  • Main object creation from the list report page
Warning
When you enable this feature, users cannot navigate to an object page in create mode. Instead, they can navigate to the object page in display mode and switch to edit mode. Also, Draft states are not maintained.

Hide Draft Values / Show Draft Values

With SAP Fiori elements for OData V2, you can display this button to allow users to choose between a display of only saved records or of all records. The button is displayed only when the Editing Status filter in the list report filter bar is set to All.

By default, the list report displays active (saved) records, draft (unsaved) records, and draft changes to active records.

Note that this feature is enabled at the application level and also displays the Display Saved Version / Return to Draft button in the object page header.

The selection in the list report determines the state of the object that opens when the user navigates to the object page:

  • From a list report with Hide Draft Values selected, the object page opens with the last saved version of the record. If a draft record also exists, the Return to Draft button shows. 
  • From a list report with Show Draft Values selected, the object page opens in edit mode for drafts with the Display Saved Version button displayed.

When the user navigates back to the list report, it displays with the previously selected state.


Hiding Actions in Multiple Content Layout

You can hide an action from a toolbar for a specific table when the list report contains multiple views with multiple tables.

For more information, see:

Object Page-Specific Features

The information below relates only to table toolbar actions and settings in the object page floorplan.


Search

You can enable a search on the table.

For more information, see Search.


Edit

By default, Edit is displayed when the business object shown in the table is editable.


Delete

By default, Delete is displayed in edit mode when the business object shown in the table is deletable.

You can enable or disable the Delete action to allow users to delete only in certain conditions.

For example, after the sales items for a Sales Order have shipped, you can hide the Delete action for the items. When a user selects an item that cannot be deleted, the Delete action is disabled.

When multiple selection is enabled for the table, the Delete action is enabled if at least one selected item is deletable.

Warning
In a responsive table, if you put a Delete action in the toolbar, do not enable the inline Delete for table rows.

Subobject Creation

By default:

  • Create is displayed in edit mode when the business object shown in the table is editable. For specific circumstances when the Create button is disabled, see Create Action Visibility below.
  • The default creation action is via the suboject page — the action opens the subobject page in create mode so the user can enter the data.

You can:

  • Enable or disable the Create action to allow users to create subobjects only in certain conditions. For example, after a sales order reaches the Delivery is Shipped status, you can hide the Create Sales Item action.
  • Enable creation of a subobject via a dialog with 8 fields maximum in an application that is not draft-enabled. The action opens a dialog in modal view so the user can enter the data. The dialog must contain all the mandatory fields for the subobject.
  • Enable inline create for draft-enabled applications in grid and responsive tables only. See Inline Creation below.
Guidelines
Replace the default dialog title or subobject page title “New Item” to reflect the name of the subobject and to provide a name for unnamed objects that’s meaningful to the user.

For more information, see:


Create Visibility

Whether or not the Create action is visible in the table toolbar depends on:

  • The object page mode.
  • Whether the flow is global or local.
  • Where the user enters the data for the new subobject — in the subobject page or directly in the table with the inline edit.

 

Flow Type

Read Mode for All Tables

Edit Mode for Tables with Subobject Pages

Edit Mode for Tables with Inline Edit

Global Flow for Draft-Enabled

Applications with Fiori Elements for OData V2

  • Navigation indicators   are visible (if required).
  • Create button is not visible.
  • Navigation indicators   are visible (if required).
  • Create button is visible.
  • Navigation indicators   are visible (if required).
  • Create button is visible.

Local Flow for Non-Draft Enabled Applications

  • Navigation indicators   are visible (if required).
  • Create button is visible.
  • Navigation indicators   are not visible.
  • Create button is not visible.
Not Supported.

Inline Creation

In grid and responsive tables, you can enable inline creation of entries for applications with draft handling enabled.

The Create action is displayed in edit mode.

The inline create action creates a new row in the table and users enter the data for the new subobject in the row.

When a new entry is created, the row is highlighted in blue. The highlighting disappears once the data is saved.

By default, the new entry is displayed at the top of the table. You can work with the development team to define a custom sort order.

For more information, see Add Items.


Prefilling Fields for New Object

You can turn this on in draft-enabled applications for the default create action via the object page, where the user navigates to another application to enter the data in the new object page.

The new object must be the main object on the object page.

You determine both the fields to prefill and the default values for the fields.


Copy and Paste from Microsoft Excel

By default, the table toolbar for responsive and grid tables displays Paste when the following are enabled:

  • Draft-handling for the application.
  • Inline creation for the object page table.

After users copy data from Microsoft Excel, they can place the focus anywhere in the table except for the cells and trigger the browser paste with the keyboard shortcut (CTRL+ V for Microsoft Windows, CMD + V for MacOS).

See below Limitations of Copy and Paste from Microsoft Excel.

Limitations of Copy and Paste from Excel

  • Pasting is supported only for fields that contain a single value, not for complex fields, such as smart links and images.
  • If there are validation errors, a dialog displays an error message so the user can take remedial action.
  • The greater the number of records copied, the longer the paste operation takes.
  • The order of the of the data copied from Microsoft Excel can differ from the order in the table in the application after the paste. SAP Fiori elements cannot control this.
  • Users cannot paste data into custom columns of tables.
  • This feature is not supported for custom tables.

Export to Spreadsheet

By default, Export to Spreadsheet is enabled with the copy and paste from Microsoft Excel feature above.

You can enable the button independently of the copy and paste from Microsoft Excel.

The Export to Spreadsheet button triggers the export of the values in the table.

For more information see Export to Spreadsheet.


Content Switch for Table Views

By default, the number of views that you set for the table determines the UI control for the content switch for table views.

By default, the count or number of records in the view is not displayed next to the title of the content switch for table views for performance reasons. Talk to the development team about how displaying the counts impacts performance for your use case.

Related Links