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.
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.