Overview
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.
Requirements
- ABAP Workbench Foundations (BC400) or Introduction to ABAP Programming on SAP S/4HANA (S4D400)
- ABAP Dictionary (BC430)
Audience
- Developers
- Development consultants
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