Course Outline

Introduction

  • Overview of CDS views
  • Using ABAP Development Tools (ADT)
  • Using and analyzing a CDS view

Basic SQL Features

  • Defining a CDS view
  • Creating a CDS view with projection, selection, and inner join
  • Using ABAP annotations

More SQL Features

  • Using SQL expressions
  • Using built-in SQL functions
  • Nested views
  • Using aggregations
  • Using additional join types and UNION

Advanced Concepts

  • Using input parameters to define CDS views
  • Using associations to build CDS views
  • Enhancing a CDS view
  • Using authorization rules to link a CDS view

Database-Specific Features of ABAP CDS

  • Understanding and using CDS table functions

Consumption of CDS Views

  • Using a CDS view as a data source for ALV IDA
  • Using CDS Views as replacement objects
  • Generating OData services from CDS views
  • Consumption of CDS views in SAP Fiori
  • Analytics based on CDS views
  • Using virtual data models with CDS views

Summary and Next Steps

Requirements

  • ABAP Workbench Foundations (BC400) or Introduction to ABAP Programming on SAP S/4HANA (S4D400)
  • ABAP Dictionary (BC430)

Audience

  • Developers
  • Development consultants
 21 Hours

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from €6840 online delivery, based on a group of 2 delegates, €2160 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Testimonials (2)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories