ABAP - Keyword Documentation →  ABAP - Dictionary →  ABAP CDS in ABAP Dictionary →  ABAP CDS - Data Definitions →  ABAP CDS - DDL for Data Definitions → 

ABAP CDS - parameter

Syntax

... [@parameter_annot1]
    [@parameter_annot2]
    ...
    pname : typing
    [@<parameter_annot1]
    [@<parameter_annot2]
    ...


Addition:

... @parameter_annot ... @<parameter_annot

Effect

Defines an input parameter with the name pname in the parameter list of a CDS view or the parameter list of a CDS table function.

The name pname must comply with the naming rules for names. Furthermore, pname cannot contain any slash (/) characters and cannot be a reserved name in ABAP Dictionary. Also, the reserved name connection cannot be used in table functions. The reserved names that cannot be used are specified in the database table TRESE. They are not case-sensitive. The blanks in the comma-separated list are ignored and can be omitted. Each input parameter must be typed with an elementary data type typing.

A CDS entity can be used with input parameters as one of the following:

In these cases, each input parameter must be assigned a suitable actual parameter whose value is then used in the operand positions in which the parameter is specified. The actual parameters are assigned using a parenthesized comma-separated list as follows:

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

This list must be specified directly after the name of the view when using a view with parameters (both within the CDS DDL in ABAP CDS and in Open SQL). In Open SQL , an equals sign (=) is used instead of a colon (:).

Note

It is not currently possible to define optional input parameters or replacement parameters for input parameters. The annotation @Environment.systemField can be used, however, to make Open SQL pass ABAP system fields to an input parameter implicitly.

Addition

... @parameter_annot ... @<parameter_annot

Effect

Specifies annotations for the parameter. The annotations can be specified before the parameter using @parameter_annot or after the parameter using @parameter_annot.



Continue
ABAP CDS - parameter_annot