Read ABAP CDS view data in HANA CDS view

[s0004895470]

Hi experts,

We have created some ABAP CDS views, which we would like to reuse in a HANA CDS view.

When I refer to the ABAP CDS view as "SAP<SYSID>"."Z_ABAP_VIEW_NAME" in the HANA CDS view definition, I get a syntax error: Cannot find artifact...

Is it possible to re-use the ABAP view in my HANA CDS definition?

Is there an alias for the SAP<SYSID> schema? When we apply the developments on a QA or PRD system, the name of the erp content schema will be different...

Kind regards,

Luk

[former_member69893 · Accepted solution]

Hi luk,
you can directly consume ABAP CDS views in HANA CDS through synonym. Create a synonym for the ABAP CDS view in your schema where you are creating your HANA CDS view. Try calling the synonym in your HANA CDS view creation and you should be able to consume the ABAP View.
Try this and let me know if you face an issue.
Regards,
Prabuddha

[former_member69893]

Hi luk,
You can use the ABAP CDS views in HANA CDS. You have to change the schema name while creating the HANA CDS view.
@schema:'$<schema> ' should contain your ABAP CDS view then you can consume it. the artifact cannot be found because you are creating HANA CDS in a different schema.

regards,
Prabuddha