Building Views in ABAP Core Data Services (S4D430)

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

Audience

• Developers
• Development consultants

The ABAP Core Data Services (ABAP CDS) is a framework used to define data models in SAP HANA. Building Views in ABAP Core Data Services (S4D430) is a training course that provides a basic idea of CDS and how the CDS concept is implemented by SAP on the ABAP stack.

This instructor-led, live training (online or onsite) is aimed at developers and development consultants who wish to learn and leverage the features and potentials of CDS when establishing database views.

By the end of this training, participants will be able to:

• Analyze and establish views in ABAP CDS.
• Understand the difference between CDS views and ordinary database views.
• Learn and leverage the SQL features in CDS views.
• Utilize CDS-specific concepts and understand the common use cases for CDS views.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

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