SAP ABAP CDS View: Where-Used Analysis
When working with SAP ABAP Core Data Services (CDS) Views, you may need to check where a CDS view is used in order to: ✅ Analyze dependencies ✅ Identify impacted objects before making changes ✅ Debug issues in reports, OData services, or other consuming objects
1. Finding Where a CDS View is Used in Eclipse (ADT)
🔹 Steps: 1️⃣ Open Eclipse (ABAP Development Tools - ADT) 2️⃣ Navigate to the CDS view in the Project Explorer 3️⃣ Right-click on the CDS view name 4️⃣ Click Find References → In Project 5️⃣ The Search Results pane will display all objects that reference the view
✅ Use Case: Find reports, OData services, or other CDS views that depend on a specific CDS view.
2. Using SE11 (Dictionary Search)
If the CDS view has a SQL View Name, you can search in SE11: 1️⃣ Go to Transaction SE11 2️⃣ Enter the SQL View Name of the CDS view 3️⃣ Click Where-Used List (Shift+F3) 4️⃣ Select Tables, Views, and Programs 5️⃣ Press Execute (F8)
✅ Use Case: Find classic ABAP reports, table joins, or function modules using the CDS SQL View.
3. Using Transaction Code ADT_TOOLS
SAP provides the ADT_TOOLS transaction to search where a CDS view is used. 1️⃣ Open SAP GUI 2️⃣ Run transaction ADT_TOOLS 3️⃣ Choose “Search for ABAP Repository Objects” 4️⃣ Enter the CDS View name and search
✅ Use Case: Find CDS consumption across Eclipse (ADT) and SAP GUI.
4. Using Custom SQL Query in SAP
You can run a query on table dependencies to find where a CDS view is used:
SELECT * FROM dddepend WHERE dependname = 'ZMY_CDS_VIEW'.🔹 This helps find dependent objects like other CDS views, reports, or function modules.
✅ Use Case: For advanced users who want to analyze CDS dependencies at the database level.
5. Checking OData Service Usage
If your CDS view is exposed via OData, check: 1️⃣ Transaction /IWFND/MAINT_SERVICE 2️⃣ Find the OData Service linked to your CDS View 3️⃣ Check the Entity Sets that reference your CDS
✅ Use Case: Identify Fiori apps or OData services consuming the CDS view.
Summary of Methods
| Method | Use Case |
|---|---|
| Eclipse (ADT) Find References | Best for CDS-to-CDS and class usage |
| SE11 (Where-Used on SQL View) | Finds dependencies in classic ABAP |
| ADT_TOOLS Transaction | Searches ABAP repository for dependencies |
| SQL Query on DDDEPEND | Finds dependencies at DB level |
| /IWFND/MAINT_SERVICE | Identifies OData usage |