Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
Showing results for 
Search instead for 
Did you mean: 
Version: SAP S/4 HANA 1909


In SAP Embedded Analytics world ABAP Core Data Service Views also known as ABAP CDS Views. ABAP CDS Views are defined on top of existing database tables. Which can be further used in UI5 application for reporting purpose. When we deal with reports, then we need some selection parameters to restrict data in to get expected output. Which works as selection screen in UI5 application. Such functionality can be achieved with help ABAP CDS view.

Based on my experience & learning; I am drafting information in below article.

With continuation to previous article, lets see how to develop a report based on CDS view having Optional Input Parameter.

CDS views can be created with parameters & without parameters. If we create view with parameters, then it will become mandatory to provide input while executing a report.

Example –

Executing CDS via RSRT Tcode –


Question: Is it possible to develop a report based on CDS view having facility of optional input parameters?

Answer is yes, let see how we can achieve this by doing minor changes in CDS view.

CDS View –

We will add 2 annotations in CDS view to generate prompts while executing of report based on CDS view.

@Consumption.filter.mandatory: false
@Consumption.filter.selectionType: #SINGLE

Executing CDS View via RSRT Tcode –

Here, in above image we can see input parameter is optional here.

Sample Code -
//with parameters P_ANLAGE : abap.char( 10 )
as select from ZCDS_WITH_PARAMETER
@AnalyticsDetails.query.axis: #ROWS
@Consumption.filter.selectionType: #SINGLE
anlage as Installation,
@AnalyticsDetails.query.axis: #ROWS
bis as ValidTo,
@AnalyticsDetails.query.axis: #ROWS
ab as ValidFrom
} //where anlage = $parameters.P_ANLAGE


If we use annotation @Consumption.filter.mandatory: True then its mandatory to provide input in prompt.

More details related consumption annotation are available here.

Conclusion –

  • We can develop a report based on CDS view with optional input parameters.