Skip to Content
Technical Articles
Author's profile photo arghadip kar

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.

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Manish Thakur
      Manish Thakur

      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

      Author's profile photo Nataliya Huralna
      Nataliya Huralna

      This is transaction SQVI.

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      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,

      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      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/

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Will do Jelena Perfiljeva  never saw this sorry

      Author's profile photo Edo von Glan
      Edo von Glan

      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.

      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      Crisis averted, phew! 🙂