Course announcements

  • You are an ABAP developer and want to build your own views with ABAP CDS (Core Data Services)? During this course, you will learn the basic idea of Core Data Services and how SAP implemented this concept on the ABAP stack. In these three days, you will get a deep insight into the many features by which CDS Views surpass classical ABAP Dictionary views, and you will learn to leverage the full potential of CDS when defining your own views. Particular highlights will be the extended join possibilities, calculations on database level – including currency conversions –, nested views, associations and path expressions, input parameters, and the possibility to link CDS views to authorization checks. Finally, you will get an outlook on the different scenarios for CDS view consumption.

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.