[1319800] Views with parameters are not supported in XS Classic

[Former Member]

Hi,

I am getting below error while using SAP HANA Studio to create CDS Views with Parameters (referred https://help.sap.com/viewer/09b6623836854766b682356393c6c416/2.0.00/en-US/2247aca08f054d30b0f749f757...).

"[1319800] Views with parameters are not supported in XS Classic"

SAP HANA DB version that I am using is - 2.00.031.00.1528768600 (fa/hana2sp03)
This instance was created from AWS market place and it is HANA express + application.

Code snippet for CDS View with Parameters that is added in hdbdd is as below -

entity AddressNew {
       key id      : Integer;
           zipCode : Integer;
           city    : String(80);
           type    : String(10); // home, office
   }
   technical configuration {
       column store;
   };
view AddressViewNew1 with parameters LOWER_LIMIT: Integer as
       select from AddressNew
       {
           id
       } where id = :LOWER_LIMIT;

[pfefferf]

You used an ".hdbdd" artifact in the HANA respository which is an XS Classic artifact. As the message says and the documentation (chapter "with parameters") describes, XS Classic does not support CDS Views with parameters. If you wanna use that you have to switch to XS Advanced and use an ".hdbcds" artifact (within an MTA project HANA db module).

[Former Member]

Hi Florian,

Thanks for your response!

I am currently using WEB IDE(instead of HANA Studio) where I am able to create CDS view with parameter but I would like to deploy cds artifact in the SAP HANA Database (that I have added using steps :: Under Tools->Database Explorer -> Add Database Type as SAP HANA Database) instead of HDI Container.

I did below steps.

1) I created a project from Template (Multi Target Application project) -> SAP HANA Database Module -> provided the Schema Name.

2) right click on src folder-> HDB CDS Artifact.

3) On Deploying the CDS, Entity / view is getting created in HDI Container.

How can I deploy CDS in SAP HANA Database instead of HDI Container?

Thanks in advance!

[pfefferf]

An HDI Container is part of your HANA Database, therefore I do not get your question.