Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
dmitry_kuznetsov1
Active Participant
3,039
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
Labels in this area