Skip to Content

CDS view: How to SELECT from HANA schema table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 14, 2016 at 03:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded