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

[arghadipkar3013]

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.

https://youtu.be/-AxCDysiMiE

[former_member508984]

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

[arghadipkar3013]

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,

[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/

[arghadipkar3013]

Will do jelena.perfiljeva  never saw this sorry

[natali_huralna]

This is transaction SQVI.

[vonglan]

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.

[Jelena_Perfiljeva]

Crisis averted, phew! 🙂

[former_member131745]

Try SE16N - some of them carry parameters that cannot be filled through SE16.