Unable to Consume the Table created via SQL Command in SAP HANA Cloud via SAP CAP

[Omkar_Ghadashi]

Hi Experts,

I am trying to explore one of the requirement, please find the details steps followed below

1) Created the CAP project - capanalysis

2) Created the SAP HANA Schemas & HDI Containers instance with the HDI-shared plan and binded with the CAP project

3) through Database explorer created the table DEMOTEST using sql statement instead of the hdbtable (reason : bcoz we need to replicate the table from another system).

4) Made changes in the data modeling file accordingly and annotated it with the @cds.persistence.exists and service file.

5) executed the cds build command

6) While cds deploy i was facing the error "The file requires "db://DEMOTEST" which is not provided by any file"

7) Going further through the reference, https://community.sap.com/t5/technology-q-a/hana-express-2-0-sps-01-the-file-requires-quot-db-sbook-...

I added the hdbsynonym fil:

😎again executed the cds build and cds deploy but facing the cyclic dependency issue

It will be really great help you could guide me with the below issue ?

Regards,

Omkar