How to find CDS Views by just knowing the Field name in SAP ECC and SAP S/4 HANA?

Introduction

After we are slowly moving to the new era of SAP S/4 HANA CDS view 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.

Source: https://blogs.sap.com/2020/07/17/how-to-find-cds-views-by-just-knowing-the-field-name-in-sap-ecc-and-sap-s-4-hana/