Goals

  • This course will prepare you to:
    • Analyze and define views in Core Data Services ABAP (CDS ABAP)
    • Understand how CDS Views surpass ordinary database views
    • Leverage the available SQL features in CDS Views
    • Use CDS specific concepts like input parameters, associations, enhancements, implicit authorization checks and table functions
    • Know the most common use cases for CDS Views

Audience

  • Developer
  • Developer Consultant

Prerequisites

Essential

Recommended

Course based on software release

  • SAP S/4HANA 1610
  • AS ABAP 7.51

Content

  • Introduction
    • Motivating CDS Views and Understanding the Background
    • Working with ABAP Development Tools (ADT)
    • Analyzing and Using A CDS View
  • Basic SQL Features in CDS Views
    • Define a Simple CDS View
    • Creating a CDS View with Inner Join, Projection and Selection
    • Using ABAP Annotations in CDS Views
  • More SQL Features in CDS Views
    • Using SQL Expressions in CDS Views
    • Using Built-in SQL Functions in CDS Views
    • Understanding Nested Views
    • Using Aggregations in CDS Views
    • Using Additional Join Types and UNION (ALL)
  • Advanced Concepts
    • Defining CDS Views with Input Parameters
    • Building CDS Views with Associations
    • Enhancing a CDS Views
    • Linking a CDS View with Authorization Rules
  • Database Specific Features of ABAP CDS
    • Understanding CDS Table Functions
  • Consumption of CDS Views (Outlook)
    • Using a CDS View as Data Source for ALV IDA
    • Using CDS Views as Replacement Objects
    • Generating OData Services from CDS Views
    • Understanding the Consumption of CDS Views in SAP Fiori
    • Understanding Analytics Based on CDS Views
    • Understanding Virtual Data Models with CDS Views

Notes

  • This course is suitable for all ABAP developers who work on an Application Server with release 7.40 SP05 or higher. The content is not restricted to developers of S/4HANA applications. It is not even necessary to work with SAP HANA as your database. Apart from the topic ‘CDS table functions’, the entire course content is database-agnostic.