Show TOC

ColumnsLocate this document in the navigation structure

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.