Skip to Content
Author's profile photo Wolfgang Woehrle

Trouble Shooting for CDS Views

You can define the values of CDS annotations directly in the currently opened CDS view or inherit them from other CDS views, data sources, or data elements.

When editing data models, you therefore might want to check, for example, which dependencies your entity has to other data sources, what the current values of the annotations are, and where the values originated from.

To do this you can now use the following new views:

Active Annotations

The Active Annotations view relates to the CDS entity that is opened in the source code editor. It displays the annonations that are currently used/active for the annotated elements/parameters, their current value, and their origin.

This view is sorted in accordance to the sequence of the used CDS annotations. It lists the current values of the latter, translatable texts, and information about the sources from where the annotations are inherited from.

In case of using view hierarchies, the element annotation values are propagated from the underlying views to the view above.

You can also navigate to the listed entities by double-clicking them.

For more information, look here Active Annotations View

Dependency Analyzer

The tree and the graph tabs of the Dependency Analyzer view displays the SQL dependencies between ABAP Dictionary objects and CDS entities as follows:

  1. SQL Dependency Tree: Tabular structure to skim through the most relevant details quickly
  2. SQL Dependency Graph: Hierarchial semantic net to visualize the dependencies and relationships in general

In addition, you can gain aggregated information Ÿabout usages such as JOINs, SQL operations, and so on from the Complexity Metrics tab. The tab displays the most relevant statistics for your entity which you can use to optimize your data definition

Just skim through the sections and check if there are unusually high numbers.

What’s the use case? You  might run, for example, into performance issues when creating a data model. Consequently, you want to investigate the cause. Then this view comes in handy!

For more information, look here Dependency Analyzer

How to Open these Views?

You open them through the context menu from the source code editor as follows:

Just click then the relevant entry.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Matthias Beyer-Grandisch
      Matthias Beyer-Grandisch

      Hi Wolfgang,

      thank you for the great summary.

      I have a problem to open the dependencies analyzer on the new view entities.

      The error message is "Dependencies can only be calculated on CDS views".

      Could it be that view entities are not supported or do I something wrong?

      Best regards,

      Matthias

       

       

      Author's profile photo Wolfgang Woehrle
      Wolfgang Woehrle
      Blog Post Author

      Hi Matthias,

      thank you for your kind feedback.

      In on-premise, this feature should available as of backend version AS ABAP 7.57 (ABAP Platform 2022) that will  be shipped in some weeks.

      In SAP BTP, this feature is available as of 2111.

      I suppose you tested it using an on-premise system?

      Kind regards,

      Wolfgang