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, Operands and Expressions 

ABAP CDS - parameter

Other versions: 7.31 | 7.40 | 7.54

Syntax

... :pname|$parameters.pname ...

Effect

Specifies an input parameter pname from the parameter list parameter_list in an operand position of a SELECT statement of a CDS view.

The name of the parameter pname must be prefixed by a colon (:) or $parameters..

Example

Specifies the parameters p1 and p2 using both syntax options in the SELECT list.

@AbapCatalog.sqlViewName: 'SPFLI_PROJECTION'
define view spfli_proj
  with parameters p1 : abap.int4,
                  p2 : abap.int4 as
  select from scarr
         { key carrid,
               :p1 as para1,
               $parameters.p2 as para2
         };