Find ABAP CDS View Name using DDL Source Name on SAP
Let's assume ABAP developer has created a CDS View named "Z_SOM_CUST_V" in the ABAP dictionary using SAP HANA Studio. Any developer can use SE11 and search for the CDS view by typing the CDS View name. To open CDS view on SE11 ABAP Dictionary screen by only knowing the DDL Source name, programmer can use DDL Source name to query DDLDependency SAP table for CDS View name.
If ABAP programmer checks the attributes of the CDS View, DDL SQL View name and DDL Source name takes the attention.
If you double click on the DDL Source textbox, you can see the source code of the CDS view.
Using SE11 transaction code, it is not possible to display CDS view definition using the DDL Source name.
The ABAP user has to know the view name.
So for ABAP developers or SAP users who know the DDL Source name but don't know the corresponding CDS View name, it is difficult to find and display the view contents on SE11 ABAP Dictionary transaction.
So the question is that: How to display CDS view using its DDL Source name?
Or how can you display CDS view definition on SAP GUI using SE11 without view name?
To find the answer for these questions might take some time if you don't know where to look at.
SAP table DDLDEPENDENCY "DD: Objects in a DDL Source" stores object dependencies related with DDL sources.
DDLNAME field is used for the bame of a DDL Source
OBJECTNAME field is used for the name of the ABAP Dictionary object, or the CDS View name we are looking for.
If you query the database table DDLDEPENDENCY using the DDL Source name by filtering for it on DDLNAME column, as seen in below screenshot, the row with OBJECTTYPE is equal to VIEW returns the CDS View name in OBJECTNAME column.
Now the SAP user or the ABAP programmer can use this OBJECTNAME on SE11 transaction to find the ABAP Dictionary Object and display its details.
Following ABAP code can be also used to query