Underlying Views and Tables for Consumption CDS Views

[Salil_V]

Hi all,

Is there a way (Report, Function Module, Class/Method) to get list of all the underlying CDS Views and DB Tables for a given Consumption View.

Regards, Salil

[BiberM · Accepted solution]

Hi, 

Please have a look at the database tables DDDDL*. But you will have to read it recursively. 

For a pure view there is the hierarchy view in ADT (Eclipse).

Best Regards

Michael

[Salil_V · Accepted solution]

Hi Michael, Thanks for your response but when i checked the tables with DDDDL*, i did not see list of all the underlying views/tables for the consumption view i was looking for. Any other suggestion?

[BiberM · Accepted solution]

Hi. That is correct. You only see the directly underlying views or tables. To get the whole list you have to read recursively. If you are on a more recent S/4HANA System you could define a parent child dependency in a custom CDS view. This could be used to read all leaves of the tree. In the worst case you have circle dependencies.

Best regards

Michael

[Salil_V · Accepted solution]

Hi Michael, after further analysis i see that i can use DDL Source field in table DDDDLSRC and then as you mentioned, i have to keep doing this recursively until i get to the base tables