Encounter error code 259 for Hana cloud database table in SAP CAP project

[SAPWayneSG]

Dear all,

In my MTA CAP project, I have defined an entity in test.cds file

namespace app.test;
  <br>define entity obddetails {<br> Batch: String(15);
  <br>};

Then I have test_srv.cds as per below:

using app.test from '../db/test';
service CatalogService {
  entity obddetails as projection on test.obddetails;
}<br>

I build & deploy it, this table obddetails is visible in Hana database Explorer.

However, when I add approute and try to access it from below route URL, error code 259 encounter.

Is there any file or configuration to manually define this schema?

I couldn't find the schema file.

[SAPWayneSG]

Hi Neeraj Jain,

Thanks for your quick response, just read the question you have recommended.

I don't know how to apply it to my issue.

Can you explain more on below 2 lines?

"Run the report – RUTDDLSACT

Put * in the DDL Source or View Names field"

By the way, my database is Hana Cloud, it is deployed to Cloud Foundry.

[Neeraj_Jain]

Hello sapwaynesg,

Please refer below SAP thread. Hope it's clarifies your query.

https://answers.sap.com/questions/13567660/sql-code-259-with-the-error-text-sql-message-inval.html

Regards,

Neeraj Jain