How to find entities used in CDS View?

[Former Member]

Is there any table in which all the entities used in a CDS View maintained.

This is required to centrally control the creation of CDS Views to maximize reuse.

Also, how to monitor the static performance of CDS Views. Whether PERFORMACE_DB check in SCI sufficient?

[Sean_Zhang]

Hi,

If you want to know whether there is some table to store the CDS entity entry, there is some table: ddldependency, the field ddlname is the CDS name.

but be careful to use it, since it's underlying table, which might be changed in new version of Netweaver.

Regarding the static performance, it couldn't be regarded simply by using PERFORMACE_DB, it has to be done case by case.

in the meantime, there is a tool to analyze the static complexity of the CDS in ABAP in eclipse. right click the CDS->Open with-> Dependency Analyzer, where you could see the complexity metrics. normally the dependency and metric should be avoided to be more complex sometimes.

Best Regards,
Sean