Where used functionality for ABAP CDS views?

[eddy_declercq]

Hi,

Is there a way to have a where used functionality for ABAP CDS views, eg in which other CDS views, ABAP programs, classes, ... is a certain ABAP CDS view reused?

This in order to find out what the impact will be if a certain change is done in a ABAP CDS.

Cheers

Eddy

[Sathya_Gunasekaran]

Right click on the view name ( the one after the define view statement) and choose get where used list...

[eddy_declercq]

Hi,

I've already tried that, but I'm getting the message "Where-used is not supported at this position. Select a supported object and perform the search again".

Cheers

Eddy

[nabhish_saxena]

Hi Eddy,

In t-code SDDLAR (CDS Analysis and Repair Tools) in backend ABAP system, you can find other ABAP CDS views consuming the current view based on name.

Choose option 'Display DDL Source' and click on 'Analyze' button.
In the 'Regular Expression (partial match)' section, provide the name of ABAP CDS for which you want to do where used and check the 'Ignore Case' flag.
Click Execute.

It will scan through the other ABAP CDS views to find the name of the searched view in their code.
Since this is a code scan of the ABAP CDS, it might also return some additional results based on usage of name as regular expression.

-Nabhish

[former_member233171]

thomasfiedler Is there anything planned for the future? I'm still missing that feature (where-used list for DDL Sources/CDS Views) in the latest S/4HANA Release and the latest ADT Version.

Best regards, Thomas

[Sandra_Rossi]

Thanks! Screenshots of SDDLAR to help people (S/4HANA 2023 ABAP 7.58).

F8

F8 (wait for a few minutes, a long list may be displayed)

[Mehh]

Is there a cloud equivalent of this transaction? This solution won't work when transactions are no longer available.

[Bogdan7]

Although CDS views themselves are very powerful feature then lack of 'where-used' functionality in Eclipse makes my life more difficult :-(. Hopefully it will be implemented in the new upcoming versions. Best regards Bogdan

[PH]

Hello,

I found out that it worked for me, if i right-click on the CDS view in the outline view and select "Get Where-used List".

Regards,

Philipp

[vivekbhusari]

Thanks Philipp it works for me as well!

[former_member706809]

This worked! Thanks Philipp!

[Dmitry_Kuznetsov]

Eddy, you need to right-click on a CDS View definition in the code editor, not the DDL source file in Project Explorer! I still bounce into the same thing after 3 years myself 😉

Cheers,

Dmitry Kuznetsov

BI Consulting

[Sandra_Rossi]

It doesn't work i.e. it doesn't find the CDS views which use a given CDS view (that was the question). Test done in S/4HANA 2023, ABAP 7.58.

Example with I_TextObjectPlainLongText, it doesn't find A_EquipmentLongText and many other CDS views:

[mchrista]

@Sandra_Rossi : Did you find a solution on this? I can even see less entries than you. It looks to me, that eclipse filters the object types that are displayed. But I don't know how to enhance this. 

[Sandra_Rossi]

Do you mean the solution provided here by an SAP employee doesn't work for you? What did you try? What is your issue? Please post a question (here, it was just a discussion).

[mchrista]

Put a question here, would appreciate your help.

https://community.sap.com/t5/technology-q-a/eclipse-where-used-functionality-for-abap-cds-views-not-...

[shanthi_bhaskar]

please verify this blog . https://blogs.sap.com/2020/04/28/abap-cds-view-object-flow-program/

[former_member261348]

Where used list is working when right click the CDS entity name in definition. But it doesn't show the roles / access controls for that CDS view. How can i find the role / access control for any CDS view?

[Sandra_Rossi]

Almost good, but it doesn't work well:

It doesn't seem to extract all CDS views, e.g. S/4HANA 2023, running with "Object Flow Up" and CDS View I_TEXTOBJECTPLAINLONGTEXT, it doesn't find A_EQUIPMENTLONGTEXT.

By running the transaction code SDDLAR, I get the correct result. See more in this post: Re: Where used functionality for ABAP CDS views? - SAP Community.

[g_horn]

Table DDDDLSRC holds all the source code of your CDS views. We commonly use TVARVC variables and before we make changes to these variables (because multiple programs and/or CDS views may use the same variables) we scan our ABAP and our CDS views.

• Transaction CODE_SCANNER or program RS_ABAP_SOURCE_SCAN to search code
• Table DDDDLSRC to scan CDS view source code. The below SQL will find all the custom CDS views that contain the string 'ZWF_INV_ICON_AGENT'

select ddlname
from ddddlsrc
where ddlname like 'Z%'
and source like '%ZWF_INV_ICON_AGENT%'