topic Re: Where used functionality for ABAP CDS views? in Application Development and Automation Discussions

Where used functionality for ABAP CDS views?

eddy_declercq — Wed, 28 Feb 2018 14:45:23 GMT

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

Re: Where used functionality for ABAP CDS views?

Sathya_Gunasekaran — Wed, 28 Feb 2018 15:39:57 GMT

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

Re: Where used functionality for ABAP CDS views?

eddy_declercq — Thu, 01 Mar 2018 09:41:10 GMT

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

Re: Where used functionality for ABAP CDS views?

nabhish_saxena — Tue, 20 Mar 2018 14:03:49 GMT

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

Re: Where used functionality for ABAP CDS views?

former_member233171 — Thu, 06 Sep 2018 08:25:49 GMT

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

Re: Where used functionality for ABAP CDS views?

Bogdan7 — Fri, 25 Jan 2019 12:35:27 GMT

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

Re: Where used functionality for ABAP CDS views?

PH — Fri, 16 Aug 2019 14:00:44 GMT

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

Re: Where used functionality for ABAP CDS views?

DmitryKuznetsov — Fri, 23 Aug 2019 12:42:52 GMT

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

Re: Where used functionality for ABAP CDS views?

vivekbhusari — Sun, 26 Apr 2020 11:00:57 GMT

Thanks Philipp it works for me as well!

Re: Where used functionality for ABAP CDS views?

shanthi_bhaskar — Mon, 25 May 2020 04:19:23 GMT

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

Re: Where used functionality for ABAP CDS views?

former_member261348 — Tue, 09 Jun 2020 20:34:50 GMT

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?

Re: Where used functionality for ABAP CDS views?

former_member706809 — Mon, 05 Jul 2021 12:37:13 GMT

This worked! Thanks Philipp!

Re: Where used functionality for ABAP CDS views?

g_horn — Thu, 16 Feb 2023 13:11:27 GMT

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%'

Re: Where used functionality for ABAP CDS views?

Sandra_Rossi — Fri, 02 Feb 2024 20:22:48 GMT

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

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

Re: Where used functionality for ABAP CDS views?

Sandra_Rossi — Fri, 02 Feb 2024 19:52:15 GMT

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:

Re: Where used functionality for ABAP CDS views?

Sandra_Rossi — Fri, 02 Feb 2024 20:24:59 GMT

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.

Re: Where used functionality for ABAP CDS views?

Mehh — Thu, 05 Sep 2024 15:27:54 GMT

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

Re: Where used functionality for ABAP CDS views?

mchrista — Tue, 03 Dec 2024 16:54:40 GMT

@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.

Re: Where used functionality for ABAP CDS views?

Sandra_Rossi — Tue, 03 Dec 2024 17:32:37 GMT

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).

Re: Where used functionality for ABAP CDS views?

mchrista — Wed, 04 Dec 2024 07:34:16 GMT

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-working/qaq-p/13955050