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
  21 Hours
 

Testimonials

Related Courses

SAP S/4 Hana (S/4Hana)

  21 hours

SAP ABAP for Developers

  21 hours

SAP ASE for Database Administrators

  28 hours

SAP Basis for Administrators

  35 hours

SAP Financial Accounting and Controlling (FICO) for Consultants

  28 hours

SAP Hana for Data Analysts

  21 hours

SAP Human Capital Management (HCM) for Consultants

  28 hours

SAP Hybris

  14 hours

SAP MM

  7 hours

SAP PM Fundamentals to Advanced

  21 hours

SAP Sales Order Processing and Supply Chain Management

  14 hours

SAP SD

  14 hours

SAP ERP Fundamentals

  28 hours

SAP EWM (Extended Warehouse Management)

  35 hours

SAP Automation with UIPath

  14 hours