CDS view: How to SELECT from HANA schema table

[watle]

Hello,

I want to create a cds view and would like to know how I can select from a HANA schema table?

Is it a way to solve it?

Many Thanks!

Sylvain

[thomas_jung · Accepted solution]

You can reference an existing table (not defined as an entity via CDS) with the USING syntax. The limitation is that you can't specify a schema with this statement. Therefore these target tables need to either be in the same schema as the CDS file is targeting, a repository created table, or you have to create a synonym for the target.

See example here:

dev703/FLIGHT.hdbcds at master · I809764/dev703 · GitHub

[watle · Accepted solution]

thanks Jung!