Which CDS views do I have per application component?

I get asked quite frequently, “is there a list of all CDS Views” or, “how many views do we have in every area”. This happens both by colleagues on S/4HANA project and course participants (I sometimes get to teach S4H400, S4H410 and S4D430 for SAP). Everybody seems to want a “spreadsheet” or so 🙂

So, I decided to put together a few steps that will help you answer this question yourself based on S/4HANA system you got.

In short it is the following two steps: create a CDS view that reads metadata, consume it in reporting tools.

1. CDS view sample:

@AbapCatalog.sqlViewName: 'ZCVWBRWS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'ViewBrowser Cube'
@Analytics.dataCategory: #CUBE
define view Z_C_ViewBrowser
  as select from Cds_Views_Pkg_Appcomp
{
  DDLSourceName,
  ApplicationComponentName,
  @EndUserText.label: 'Application Component'
  replace(left(ApplicationComponentName, 3), '-', '') as ApplComp,
  @DefaultAggregation: #SUM
  1                                                   as Cnt
}

2. Use Transaction RSRT

Query is 2CZCVWBRWS/!2CZCVWBRWS

+ Drill down by “Appl Comp”

* Optionally, you can showcase it in Fiori

Need to adjust the host and port in the URL

https://<your_fiori_host>:<your_fiori_port>/sap/bc/ui5_ui5/ui2/ushell/shells/abap/FioriLaunchpad.html#AnalyticQuery-analyze?XQUERY=!2CZCVWBRWS

So, with this simple query you have an elegant way of looking at information about CDS Views, be that standard or your custom ones.

Cheers,

Dmitry Kuznetsov