Columns

Get information about what UI annotations to use to work with columns of lists or tables for SAP Fiori UIs.

What columns are needed for a table or list depends on the use case, for example, an overview table may require more fields than a value help list. For this reason, you can define several list layouts and table layouts that are distinguished by a qualifier, for example 'ValueList'.

If a CDS view contains analytical annotations, for example the @DefaultAggregation annotation, the UI automatically takes this into consideration and no additional UI annotations are required.

Figure 1: Example of @DefaultAggregation annotation

For more information about the @DefaultAggregation annotation, see section DefaultAggregation Annotations linked below.

You can use the following UI annotation to define what can be displayed in the title of a table or a list:

@UI.lineItem

Sample Code

...
define view ZExample_SalesOrder as select from sepm_cds_sales_order as so {
  @UI.lineItem: [ { position: 10 }, { qualifier: 'ValueList', position: 10 } ]
  key so.sales_order_id as SalesOrder,
  
  @UI.lineItem: [ { position: 20 }, { qualifier: 'ValueList', position: 20 } ]
  so.customer.company_name as CompanyName,
  
  @UI.lineItem: [ { position: 30 } ]
  so.currency_code as CurrencyCode, 
  
  @DefaultAggregation: #SUM
  @UI.lineItem: [ { position: 40 } ]
  so.gross_amount as GrossAmount
}

For more information about positioning, see section Positioning Fields linked below.