Find a cds view containing a specific table

[former_member677854]

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.

[TanmayVerma]

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

[pruthvi_r]

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.