ABAP Keyword Documentation →  ABAP - Dictionary →  ABAP CDS in ABAP Dictionary →  ABAP CDS - Data Definitions →  ABAP CDS - DDL for Data Definitions →  ABAP CDS - DEFINE VIEW →  ABAP CDS - SELECT →  ABAP CDS - SELECT, data_source 

ABAP CDS - SELECT, parameters

Other versions: 7.31 | 7.40 | 7.54

Syntax

... ( pname1 : act1, pname2 : act2, ... ) ...

Effect

Passes actual parameters act1, act2, ... to the input parameters pname1, pname2, ... of a CDS entity.

The following can be specified for actual parameters:

• Literals

• Parameters

• Session variables

The data types of the actual parameters should match the typing of the input parameters exactly. However the following options are also possible:

• bind character-like actual parameters to character-like input parameters with a different length.

• bind numeric actual parameters to numeric input parameters with a greater value range.

Note

Currently, actual parameters can be passed to the input parameters of CDS views, CDS table functions, and CDS hierarchies used as data sources of the SELECT statement.

Example

The following CDS view uses the CDS view demo_cds_parameters in a join. The input parameters of this view are supplied with the input parameters of the current view as actual parameters. The program DEMO_CDS_PARAMETERS_JOIN uses SELECT to access the view. Here the input parameters are supplied with actual parameters.

@AbapCatalog.sqlViewName: 'DEMO_CDS_PARJOIN'
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view demo_cds_parameters_join
  with parameters
    in_distance_l :s_distance,
    in_distance_u :s_distance,
    in_unit       :s_distid
  as select from
           demo_cds_parameters
      ( p_distance_l : $parameters.in_distance_l,
        p_distance_u : $parameters.in_distance_u,
        p_unit       : $parameters.in_unit ) as flights
      join scarr on
        scarr.carrid = flights.carrid
    {
      key scarr.carrname,
      key flights.connid,
          flights.cityfrom,
          flights.cityto,
          flights.distance,
          flights.distid
    };