Skip to Content

How to Consume table from different schema in CDS View

Hi,

I'm trying to create a CDS View with tables from two different schemas.

One schema is the SAPDAT, which is SAP's default where all the standard tables exist.

The other schema is a custom one (custom_schema) I built in HANA Studio, in which the table I need is not visible in the application layer in SE11.

So far I'm struggling to consume the table from custom_schema in my CDS view, as it says the object does not exist.

Is there a way to consume tables from different schemas in CDS views?

Thank you!

Marcelo

Add comment
10|10000 characters needed characters exceeded

  • Are you talking about ABAP CDS Views or HANA CDS views?

  • ABAP CDS Views. I'm in the ABAP perspective within HANA Studio

  • I am also getting same Error "Object does not Exist or not active" When I am trying to use it with below Example:

    Refer to the table in CDS View with <Schema_Name>.<Table_NAME>

    eg: "SAPDATA".VBAP

    Any other way to use the table of different Schema, My scenario is we have HR tables in S/4 HANA DB so we have a S/4 Schema and we need to use it in another CAR Schema, So I thought of creating a CDS View and get the DATA in the ABAP end to write my Logic.

    But unfortunately this is not working, Do we have any solution for this?

  • Get RSS Feed

2 Answers

  • May 12, 2017 at 04:22 AM

    To my knowledge there is not option to access a table from a different schema directly in an ABAP CDS View. One option (on system with a NetWeaver >= 7.50) would be to create an ABAP CDS Table Function which determines the data from the required table. This function than can be used in an ABAP CDS View (or directly via Open SQL).

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11, 2017 at 07:30 PM
    -2

    Refer to the table in CDS View with <Schema_Name>.<Table_NAME>

    eg: "SAPDATA".VBAP

    Add comment
    10|10000 characters needed characters exceeded