Saturday, March 1, 2025

Find SAP CDS Views

To find CDS (Core Data Services) views in SAP, you can use several methods depending on whether you're searching in SAP GUI or SAP S/4HANA's Eclipse-based ABAP Development Tools (ADT).


1. Using SAP GUI (SE11, SE16, SE80, ST05, or RSRT)

Method 1: Using SE11 (Data Dictionary)

  1. Open SE11 (ABAP Dictionary).
  2. Select View and enter the name of a known CDS view (e.g., I_BillingDocument).
  3. If you don't know the name, enter E* or I* and use F4 Help to get a list of available views.

Method 2: Using SE16 (Table Browser)

  1. Open SE16 or SE16N.
  2. Enter Table Name: DDLSOURCE.
  3. Execute (F8).
  4. Apply filters like DPC*, I_*, C_*, or Z* for custom CDS views.

Method 3: Using SE80 (Object Navigator)

  1. Open SE80.
  2. Select Repository BrowserDictionary Objects.
  3. Search for objects starting with DDL or CDS.

Method 4: Using ST05 (SQL Trace)

  1. Start ST05.
  2. Activate SQL Trace and execute an SAP Fiori app or query.
  3. Check the trace for CDS view names used in queries.

Method 5: Using RSRT (BW Query Analyzer)

If using embedded analytics:

  1. Open RSRT.
  2. Use F4 Help to find BW Queries built on top of CDS views.

2. Using ADT (Eclipse) in SAP S/4HANA

Method 6: Searching in ADT

  1. Open Eclipse with ADT.
  2. Navigate to ABAP Development Tools.
  3. Use Ctrl + H → Select ABAP Repository Search.
  4. Enter a pattern like I_*, C_*, or Z* (for custom views).
  5. Press Search.

Method 7: Using ADT Project Explorer

  1. Open ADT.
  2. Expand your Package (e.g., Z*, S4CORE).
  3. Navigate to DictionaryData Definitions.
  4. View CDS definitions directly.

3. Using Tables for CDS Metadata

Method 8: Query Metadata Tables

You can check CDS views stored in SAP tables:

  • DDLSOURCE → Stores all CDS views.
  • DDLDEPENDENCY → Shows dependent objects of CDS views.
  • TADIR → CDS views can be filtered with R3TR DDLS.

Example SQL Query (SE16, SE11, or ST05):

sql
SELECT * FROM DDLSOURCE WHERE NAME LIKE 'I_%' OR NAME LIKE 'Z_%'.

4. Using Fiori Apps (SAP S/4HANA)

Method 9: Using "View Browser" App

If using Fiori:

  1. Open Fiori Launchpad.
  2. Search for "View Browser".
  3. Use filters to find CDS views by application component.

5. Using Custom ABAP Report

If you want to list CDS views programmatically, you can write a simple ABAP report:

abap
SELECT name FROM ddlsource INTO TABLE @DATA(cds_views) WHERE name LIKE 'Z%'. LOOP AT cds_views INTO DATA(view). WRITE: / view. ENDLOOP.

Summary

MethodTool
SE11Check Data Dictionary
SE16Query DDLSOURCE table
SE80Browse Repository
ST05SQL Trace for CDS usage
RSRTFind embedded analytics views
Eclipse ADTSearch for CDS definitions
TADIR, DDLSOURCEQuery Metadata Tables
Fiori "View Browser"Find standard & custom views
Custom ABAPList CDS views via SQL

Would you like help identifying specific CDS views for your use ca

No comments:

Post a Comment

Fiori Development - Style

Okay, here is a rewritten version incorporating the detailed information about developing preformatted layout reports, including a Table of ...