Table Groupings

Table Groupings

SAP Fiori elements handle table groupings automatically.

The grouping of rows is supported in responsive tables (sap.m.Table) and analytical tables (sap.ui.Table.AnalyticalTable). Grid tables and tree tables are not supported.

Table grouping of rows looks like this:

Grouping Header Text

These group header formatters are automatically set by SAP Fiori elements:

  • Responsive table: Set a grouping function on the sorter: fnGroup of sap.ui.model.Sorter.

  • Analytical table: Set property groupHeaderFormatter of sap.ui.table.AnalyticalColumn.

Grouping Header Types

SAP Fiori elements supports these group header formatters:

OData Type SAP Display Format OData Example Unformatted Formatted Comments
Edm.DateTimeOffsetDate Date /Date(1485471600000 +0000)/ Fri Jan 27 2017 00:00:00 GMT+0100 (Central European Standard Time) Jan 26, 2017 UTC
Edm.DateTimeOffset /Date(1485471600000 +0000)/ Fri Jan 27 2017 00:00:00 GMT+0100 (Central European Standard Time) Jan 27, 2017, 12:00:00 AM
Edm.DateTime Date /Date(1485471600000 +0000)/ Fri Jan 27 2017 00:00:00 GMT+0100 (Central European Standard Time) Jan 26, 2017 UTC
Edm.DateTime /Date(1485471600000 +0000)/ Fri Jan 27 2017 00:00:00 GMT+0100 (Central European Standard Time) Jan 27, 2017, 12:00:00 AM
Edm.Time Time PT11H13M01S [object Object] is: {ms: 43980000, __edmType: "Edm.Time"} 11:13:01 AM
Edm.String Date 20180313 20180313 Mar 13, 2018
Edm.Boolean true true Yes
Edm.Decimal 10 10 10.000 m* Unit of measure
Edm.Decimal 2498.00 2498.00 2,498.00 EUR* Currency
Edm.String m m Meter (m)* Unit of measure and TextArrangement
Edm.String EUR EUR Euro (EUR)* Currency and TextArrangement

* Units of measure or currencies in the grouping header are supported only in responsive tables.

Limitations

For analytical tables, take the following limations into account:

  • Grouping can only be activated for dimension columns.

  • Grouping takes place on the server. The header formatter has no effect on the grouping itself. This means that groups stay separate even if they have the same header after formatting.

  • The TextArrangement annotation is not supported. A property with a text property is displayed as follows: “m – Meter”. For more information, see the API Reference for TextArrangement.

  • Displaying values with units of measure is not supported.

Note

Please note that this topic is currently only applicable to SAP Fiori elements for OData V2.