Skip to Content
1

Getting list of CDS views using a specific table

Aug 31, 2017 at 09:31 AM

1.4k

avatar image
Former Member

Hi,

When I open a CDS view (in eclipse) I can see where it gets its data (other cds views and tables).

I am actually more interested to know in what views a table is used? The Where-Used function seems perfectly suited for this, but it doesn't list any of the CDS views.

The SYS views could offer a solution, maybe. But I haven't find the appropriate view yet.

Can anyone help me here?

Thx

Tijl

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Sep 04, 2017 at 10:42 AM
0

Hi Tijl,

Generally to get the View list built on a table you can use the below query:

SELECT BASE_SCHEMA_NAME, BASE_OBJECT_NAME,

DEPENDENT_SCHEMA_NAME,DEPENDENT_OBJECT_NAME,

DEPENDENT_OBJECT_TYPE

FROM "SYS"."OBJECT_DEPENDENCIES"

WHERE BASE_SCHEMA_NAME = '*********(Schema name)'

AND BASE_OBJECT_NAME = '**********(table name)'

Thanks,

Vinod

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Sep 22, 2017 at 07:59 AM
0

Hi,

you can check it in transaction SE11 -> Where Used List

Best Regards

Thorsten


se11-1.png (55.3 kB)
se11-2.png (40.6 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

On my system I do have to check views instead of DDL sources.

But it works!

0
Former Member

Thank you both!!

I also mistakenly searched for the artifact's name: define view <Artifact>

I should've looked for the @AbapCatalog.sqlViewName

I still would like to retrieve the artifact's name, as that is the one visible/accessible in Eclipse...

0
Former Member

SE11 DDL search doesn`t show SAP standard CDS views , only shows custom created CDS views . For standard views we should also search views (which as a result will show linked SAP Standard views SQL View name)

Is there a way to search which CDS is used in which CDS views including all available CDS views in the system ?

0