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 (5)
I liked the approach of the teacher from the very beginning. The fact that he/she tailored the teaching to our needs, and when we encountered problems, he helped us with great interest.
flavia - ASOCIAŢIA PENTRU VIITORII PROFESIONIŞTI ÎN TEHNOLOGIA INFORMAŢIEI
Course - SAP Financial Accounting and Controlling (FICO) for Consultants
I liked the fact that the trainer was very flexible and offered information about subjects that were not included in the initial material. I liked his experience in other projects and the tips and tricks resulted from this experience. The training was interactive and even though the exercises were predefined, we could take the exercise in another direction than previously defined.
Maria-Cristina Socol - NTT DATA Romania S.A.
Course - SAP S/4 Hana (S/4Hana)
Keeps me updated & knowledge refresh on ABAP area.
George Puscu - Molson Coors
Course - SAP ABAP for Developers
The trainer was very good, he knew the subject well and know how to explain to us any questions we had and that helped us a lot.
Dirman Ionut - HELLA Ghiroda
Course - SAP PM Fundamentals to Advanced
I was very impressed with the trainers preparation. As he went along he kept going back over the subjects that he had covered