Anonymous comments are disabled
While working on SAP HANA database with parametric CDS views that can be created using SAP HANA Studio, I come across with a few problems that seem to be hard to resolve.
For example, ABAP SQLScript developer can create parametric view.
It is also possible to assign a default value using annotations.
But it is not certain or at least I could not find a way to call a CDS view without explicitly assigning values to optional parameters.
Also I could not pass NULL values as CDS view parameter values.
TOP clause is also a question for me.
In fact if you are developing SQL, you will know that it is meaningless to use TOP n clause in a SQL View definition.
Maybe this is the reason SAP HANA database SQLScript also does not let me to use TOP to select top 10 rows for example in CDS view definition.
SQL Server administrator and T-SQL developer including BI components
Web programming with HTML, HTML5 and ASP, ASP.NET and .NET Framework developer
SAP ABAP and SAPUI5 development, Web Dynpro and Smart Form
Siemens HiPath Center CTI development