Skip to Content
1

How to map Schema's in HANA CDS Views ?

Apr 03, 2017 at 10:59 AM

304

avatar image

I have created CDS views in our development environment under schema "ABC". The annotation would look like @Schema: 'ABC' which works as expected.

When we transport the CDS view to Quality system we get an error "cannot find artifact - table name" due to Schema mapping. (ABC is mapped to 'DEF' schema in Quality)

Is there a possibility to circumvent this error ?

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Thomas Jung
Apr 03, 2017 at 11:47 AM
1

Schema mapping is not supported by CDS. Only modeled views support this. You should instead use a separate, customer owned schema as the target schema in the header of hdbdd.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

That's exactly what we did. Thank you, Thomas.

We created a separate schema with the same name across the landscape and used it in our HDBDD file, as the tables belong to a different schema we created their Synonyms and used them instead.

Would have preferred to use design time synonyms (.hdbsynonyms file) but the HDBDD file was throwing an error so create synonyms manually through SQL statement in each system, worked just fine.

0