We were new on our journey to clean core and were struggeling with the access to the well known tables.
How can we get the date fron the CDS views, if we do not know the name of the CDS view name?
We developers an all consultants are very familiar with the names of database tables and fields, as we do it since decades. But how to find the matching CDS view field?
You have some possibilities:
Use the Cloudification Repository Viewer
for the GitHub Repository for S/4HANA Cloud – Released objects for ATC Check (Cloudification Repository)
Do the ATC check with the Cloudification Repository and hope that a successor object is displayed
(Not well maintained and still to grow)Have a look at the VDM and hope that you get a glimpse. You must know the technical description for the business object, so it’s getting complicated.
Example you have to know, that the corresponding BO for the db table QMSM is named “Quality Notification Task” and you can find the CDS I_QltyNotificationTask
But you don’t find all and everything….
So I decided to build my own tool.
This consists of two parts
First – Analyse
Analyse once a great amount of CDS views, selected by name and put the results into a database table. An index.
Second – Search and Display
Have a report (old fashioned) which can select for any given CDS view field all database fields or vica versa in a very short time.
————————————————————————————————————————
The Analyser – the heart of it all
Select all the CDS views, which you are interested in. I.e. all Views beginnig with I_ and R_ and P_ or so on.
Let it run in the background and wait some, but not much time.
————————————————————————————————————————
Search and Display
Just find all the interesting stuff
Find the coding of both programs in github
We were new on our journey to clean core and were struggeling with the access to the well known tables.How can we get the date fron the CDS views, if we do not know the name of the CDS view name?We developers an all consultants are very familiar with the names of database tables and fields, as we do it since decades. But how to find the matching CDS view field?You have some possibilities:Use the Cloudification Repository Viewer for the GitHub Repository for S/4HANA Cloud – Released objects for ATC Check (Cloudification Repository) Do the ATC check with the Cloudification Repository and hope that a successor object is displayed(Not well maintained and still to grow)Have a look at the VDM and hope that you get a glimpse. You must know the technical description for the business object, so it’s getting complicated.Example you have to know, that the corresponding BO for the db table QMSM is named “Quality Notification Task” and you can find the CDS I_QltyNotificationTaskBut you don’t find all and everything….So I decided to build my own tool.This consists of two partsFirst – AnalyseAnalyse once a great amount of CDS views, selected by name and put the results into a database table. An index.Second – Search and DisplayHave a report (old fashioned) which can select for any given CDS view field all database fields or vica versa in a very short time.————————————————————————————————————————The Analyser – the heart of it allSelect all the CDS views, which you are interested in. I.e. all Views beginnig with I_ and R_ and P_ or so on.Let it run in the background and wait some, but not much time.————————————————————————————————————————Search and DisplayJust find all the interesting stuff Find the coding of both programs in github Read More Technology Blogs by Members articles
#SAP
#SAPTechnologyblog
