ABAP on HANA – Step by step procedure to create a CDS view using input parameters to display multiple records.

This blog shows how to display multiple records by using input PARAMETERS keyword, As there is no provision to use ABAP keyword SELECT-OPTIONS which display multiple records in CDS View.

1. Go to Dictionary => ABAP DDL Sources => New Data Definition

2. Create a New Data Definition

3. Load the template and click on finish

4. Source Code

5. Output

4 Comments

You must be Logged on to comment or reply to a post.

Former Member

December 1, 2016 at 2:58 am

Useful..

Ibrahim Khan

December 8, 2016 at 8:06 am

Hi Sharmila,
We can have ranges parameter using the between operator, but how do we provide multiple values for a input parameter in the same way we do in select options,. please advice.

Sharmila Gurubelli

Blog Post Author

December 8, 2016 at 12:18 pm

Hi Ibrahim,

In CDS Views (ABAP on HANA) we don't have any functionality like select-options as in ABAB.

Here we can get the multiple values by using multiple input parameters and assign to where condition.

define view Zcds_View with  parameters 
                           p_ebeln1:ebeln,
                           p_ebeln2:ebeln,
                           p_ebeln3:ebeln,
                           p_ebeln4:ebeln,
                           p_ebeln5:ebeln

as select from ekko
        join ekpo 
        on ekko.ebeln = ekpo.ebeln
{
  ekko.ebeln as purchasing_docu,
  ekko.bukrs,
  ekko.ernam,
  ekpo.ebelp,
  ekpo.aedat,
  ekpo.meins
}

where ekpo.ebeln= :p_ebeln1 or 
      ekpo.ebeln= :p_ebeln2 or 
      ekpo.ebeln= :p_ebeln3 or 
      ekpo.ebeln= :p_ebeln4 or 
      ekpo.ebeln= :p_ebeln5;

Output:

This may help you 🙂

Ibrahim Khan

December 14, 2016 at 6:48 am

This is a work around and will not work in real time as we are not sure how much many values the user needs for input

ABAP on HANA – Step by step procedure to create a CDS view using input parameters to display multiple records.

Assigned Tags