Skip to Content

Find a cds view containing a specific table

Hi there

I'm pretty new to sap hana/CDS views

I've isolated a specfic table PA0002 from which i need data.

I can create my own CDS view, but i would prefer to use a standard SAP CDS view, but how do i find a CDS View that contains this data.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jun 30 at 01:01 PM

    From SE11 transaction

    Click in "where used list"

    select "Views" & continue => this give the SQL view name used in CDS view

    Double click on SQL View => in the view definition screen "DDL source" is the CDS view name

    Note: If the table is used in lots of view, where used list returns lengthy list.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 30 at 11:21 PM

    Hi Steen,

    You can use table DDLDEPENDENCY to search by specific key words.

    Also below reports might be useful.

    https://blogs.sap.com/2016/06/28/core-data-services-standard-utilities-reports/

    BR,

    Tanmay

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.