Skip to content
IT Canvass
Menu
ServiceNow
SailPoint
SAP
TutorialsContact
SAP how-to guides · Lesson

Create CDS view

Quick answer

Use ADT in Eclipse (not classic SE80) for CDS.

Key takeaways

  • In ADT (Eclipse), create a new Data Definition (CDS) in your package.
  • Define the view: define view entity Z_... as select from <source> {... }.
  • Add fields, joins/associations and aggregation as needed.
  • Watch out: Following steps without understanding the concept.

Step by step

  • In ADT (Eclipse), create a new Data Definition (CDS) in your package.
  • Define the view: define view entity Z_... as select from <source> { ... }.
  • Add fields, joins/associations and aggregation as needed.
  • Add annotations (e.g. @OData.publish: true) to expose it as a service or shape UI/analytics.
  • Activate the view and test it (Data Preview), then consume it (Fiori/analytics/ABAP).

Notes and tips

Use ADT in Eclipse (not classic SE80) for CDS. Layer views, base views close to tables, composite views on top, for reuse. Annotations are what make CDS powerful (OData, analytics, UI). Push filters and aggregation down for performance, and follow naming conventions.

Common pitfalls

  • Following steps without understanding the concept.
  • Skipping testing in a non-production system.
  • Applying blindly to a different scenario.

Want to learn this properly?

Our live, instructor-led SAP Training covers this hands-on, with real projects and a certification path.

See the courseAsk a question

Check your understanding

  1. Which statement is true of Create CDS view?

    • A. An instance is a unit of an SAP system, a set of work processes and shared memory running on an application…
    • B. BAPIs (Business Application Programming Interfaces) are stable, released function modules for accessing SAP…
    • C. Layer views, base views close to tables, composite views on top, for reuse.
    Show answer

    C. Layer views, base views close to tables, composite views on top, for reuse.

    Covered in the “Notes and tips” section of this lesson.

  2. Which of these also applies to Create CDS view?

    • A. Menu-tree hunting instead of using TCodes.
    • B. Annotations are what make CDS powerful (OData, analytics, UI).
    • C. Menu-hunting instead of using codes.
    Show answer

    B. Annotations are what make CDS powerful (OData, analytics, UI).

    Covered in the “Notes and tips” section of this lesson.

  3. Which part of the Learn SAP curriculum covers Create CDS view?

    • A. SAP interview questions
    • B. SAP integration
    • C. SAP how-to guides
    Show answer

    C. SAP how-to guides

    This lesson sits in the SAP how-to guides section of the Learn SAP course.

Frequently asked questions

What does the term Create CDS view refer to in SAP?

CDS views are the modern SAP data-modeling layer, defined in ABAP and run on HANA. This guide outlines creating one in ABAP Development Tools (Eclipse).

Which transaction codes come up with Create CDS view?

Use ADT in Eclipse (not classic SE80) for CDS.

What is another point to note about Create CDS view?

In ADT (Eclipse), create a new Data Definition (CDS) in your package. Define the view: define view entity Z_... as select from <source> {... }. Add fields, joins/associations and aggregation as needed.

What tends to go wrong with Create CDS view?

Following steps without understanding the concept. Skipping testing in a non-production system. Applying blindly to a different scenario.
CallWhatsAppEnquire