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
Testimonials
Her way of talking and knowledge of whole ground of system. Her character is very nice and easy to ask questions.
- Glanbia Nutritionals
I found NobleProg very easy to work with, considering the timezone challenges and our difficulty with trainees requiring support in Japanese. Overall, working with you on this training was satisfactory and I would have no hesitation recommending your organisation. If a training need occurs for us in the ASPAC region again, I will be in touch with NobleProg.
Siobhán Bowe - Glanbia Nutritionals
Lectures with exercises included on top of the knowledge.
Mohammed Alqahtani - Saudi Railways Organization
I was very impressed with the trainers preparation. As he went along he kept going back over the subjects that he had covered