SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz Development Resources
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.

Software Development



Questions and Limitations on Parametric CDS Views on SAP HANA Database

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.

Published Thursday, April 06, 2017 8:32 PM
Filed Under: , ,

Comments

No Comments
Anonymous comments are disabled

About eralper

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
Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems