Skip to Content

Creating Joins between ECC tables in a HDBDD file

Hi All,

Out of curiosity, I wanted to create a view in a HDBDD file in native HANA (no S4 here).

All the examples I could find only joined tables defined in the same hdbdd file.

But how do I join 2 tables in a different schema (coming in from ECC).

Pardon my ignorance with the syntax here but can you please help me get this one working?

Florian Pfeffer : I've seen some of your replies on similar topics.. would you be able to help out here?

Thank you for your time.

namespace "MAINPACK"."SHYAM"."0PERF";


@Schema: 'SHYAM'
context NEWVIEW {


    view CompCode as select from "ECCSCHEMA"."T001"
    mixin {
        f: association[1] to "ECCSCHEMA"."T001A"
            on BUKRS = f.BUKRS;
    }
    into {
        f.BUKRS AS BUKRS
    };


};
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 13 at 07:02 PM

    No direct access to catalog objects is possible in XS classic CDS views. You have to define synonyms in the repository for your catalog tables (hdbsynonym), than you can use the synonyms when you define your view.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

    • I could repeat here the same things which where already discussed several times, but I will not do it :). Do a search here in the community then will find several discussions answering your questions. For instance one discussion can be found here.