Technical Articles
How to find CDS Views by just knowing the Field name in SAP ECC and SAP S/4 HANA?
Introduction
We are slowly moving to the new era of SAP S/4 HANA CDS view which is becoming very important. It is very important for all the SAP Consultant to know the available CDS view which they can use for Reporting. This blog will show how to find CDS Views based on a Field.
Solution
Create a ABAP Query with the following Join Condition
Below is the Layout for the ABAP Query
Below is the Selection screen of the ABAP Query
Now suppose we wish to get the CDS View related to field KUNNR
Here is the below result
Conclusion
This blog you can use very effectively to find all CDS View.
For video version check below Link.
Hi, how do you get the “get CDs” screen? What’s the navigation/tcode?
Thanks for sharing these vvi info bytes.
Really enjoying your posts.
Regards,
Manish
This is transaction SQVI.
You can use SE11--> Enter the CDS View in the View portion. Some of them shows in SE16 also. Still trying to crack why some does not show in SE16 probably a difference in CDS View creation,
Try SE16N - some of them carry parameters that cannot be filled through SE16.
Please consider searching for the existing posts before creating a new one and looking for the ways to contribute something additional vs repeating. It's nice to share but the repetitive content doesn't really benefit the readers.
Previous blogs on this subject, the first one looks almost the same:
https://blogs.sap.com/2019/09/03/identifying-cds-views-based-on-fields-in-s4-hana/
https://blogs.sap.com/2019/10/29/part7.-how-to-search-for-sap-standard-cds-views/
Will do Jelena Perfiljeva never saw this sorry
Haha, I had just quickly written a blog with a report that scans the DDL sources for a given table, when I saw the link to this blog, and your comment. So, quickly deleted again.
Crisis averted, phew! 🙂