Skip to content

Look Up SQL Names of CDS Views

This article shows how to look up the SQL name of CDS Views in the ABAP Dictionary (SAP GUI). The SQL name is required to look up and extract data from a CDS View with Xtract for Alteryx.

Transaction SE11

To lookup the SQL name of a CDS View:

  1. Go to SAP transaction SE11.
  2. Select View.
    lookup-cds-view-name
  3. Enter the CDS View name, e.g., C_WBSELEMENTWITHVERSION.
  4. Click [ Display]. The "Display Data Definition" opens.
  5. The SQL name is displayed in the @AbapCatalog.sqlViewName annotation, e.g., CWBSWITHVERS.
    data-definition-view
  6. Use the SQL name to look up the CDS View in Xtract for Alteryx.
    xtract-lookup

You can now extract data from the CDS View.

Note

If SE11 does not show the SQL name, use transaction SE16H on table DDLSQLVIEW. DDLSQLVIEW maps CDS View names (DDL name) to SQL View names (DDIC View name). Filter the SQLVIEWNAME column to find the corresponding CDS View.

Last update: November 28, 2025
Written by: Valerie Schipka