Skip to content

ABAP Keyword Documentation →  ABAP Dictionary →  ABAP CDS in ABAP Dictionary →  ABAP CDS - Views →  ABAP CDS - DDL Statements →  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 view.

The following can be specified for actual parameters:

The data types of the actual parameters should match the data types 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.


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'
define view demo_cds_parameters_join  
  with parameters in_distance_l:S_DISTANCE,
                  in_distance_o:S_DISTANCE,
                  in_unit:S_DISTID
  as select from demo_cds_parameters
                   ( p_distance_l : $parameters.in_distance_l,
                     p_distance_o : $parameters.in_distance_o,
                     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 };