CDS View with Multiple Parameters

light111CDS View with Multiple Parameters referring to the data element or abap data types


The below post created a CDS view with input parameters and input parameters refer to the ABAP DDIC data elements.

1

Define two input parameters and specify their data element to define their data type and length details.

2

Save and Activate the CDS view. Now in SE11 , the SQL view has selection condition.

34


 

5

Make data preview and it asks for the input parameters.

6

7

Provide input parameters.

8

Go to the SQL Console.

9

This is how the SQL query is made and later will see how from ABAP report/class to make SQL statement.

10

Also once you select Parameters it allows to change the input parameters.

111213


This is how we can make SQL query on CDS view with parameters.

1415


In above CDS the input parameters refer to the ABAP data elements but it is also possible to declare input parameters where it can be represented by the ABAP data types and specifying the length as made for the input parameter : p_connid .

1

Save and activate CDS view.

2

Data preview the CDS view.

3456


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s