Kontakt

Ansicht
Dokumentation

ABENCDS_SELECT_LIST_V1 - CDS SELECT LIST V1

ABENCDS_SELECT_LIST_V1 - CDS SELECT LIST V1

CL_GUI_FRONTEND_SERVICES - Frontend Services   CPI1466 during Backup  
This documentation is copyright by SAP AG.
SAP E-Book

- DDIC-Based View, SELECT, select_list

... element1, element2, ...
  $| * ...

Effect

Defines an element of a . The elements can be specified as follows:

  • In a comma-separated list, elements can be defined by specifying element1, element2 ...
  • * can be used to define all fields of the data source of the CDS view as elements and expose all CDS associations, CDS compositions, and CDS-to-parent associations of the current view. If another CDS view is used as a data source, the CDS associations, CDS compositions, and CDS-to-parent associations exposed in its SELECT list are not exposed by the current CDS view. The asterisk * cannot be specified if the current CDS view contains joins or union sets when the data source is specified.

The names of the elements of a CDS view must be unique. These are either

  • The names of the elements taken from the data sources
  • Alternative element names specified using AS

These names are also the names of the view fields of the CDS-managed DDIC view and the corresponding rules that must be kept.

Note

The maximum number of elements and the limit on the total of field lengths is determined by the corresponding limits for the associated CDS-managed DDIC view.

Example

The following CDS view sales_order is a view of the DDIC database table snwd_so. Three elements (so_id, currency_code, and gross_amount) are defined for this view.

@AbapCatalog.sqlViewName: 'SALES_ORDER_VW'
define view sales_order as
  select from snwd_so
    { key   so_id,
          @Semantics.currencyCode
            currency_code,
          @Semantics.amount.currencyCode: 'currency_code'
            gross_amount }

Example

The following CDS view sales_order is a view of all the fields of the DDIC database table snwd_so. Accessing the CDS view has the same effect as when the database itself is accessed.

@AbapCatalog.sqlViewName: 'SALES_ORDER_VW'
define view sales_order as
  select from snwd_so
         { * }






Addresses (Business Address Services)   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 4945 Date: 20240418 Time: 045209     sap01-206 ( 50 ms )