Professional training – SAP

CDS Views and ABAP SQL

Hands-on CDS Views and ABAP SQL course: you work on Data definitions and associations, Annotations for UI, analytics and access and Parameters, cases and aggregations and take away knowledge you can apply right away.

Duration
6 hours, one session
Level
Intermediate
Format
Online or on-site
Language
German or English
Certificate
Certificate of attendance

Overview

In “CDS Views and ABAP SQL” we combine fundamentals and practice: you get to know Data definitions and associations, Annotations for UI, analytics and access and Parameters, cases and aggregations, apply what you learn in exercises and receive templates and checklists for your own use.

SAP is the backbone of finance, procurement, sales, production and HR in many companies, and the demands differ by role. Clerks need confident navigation and clean posting processes, key users must understand master data and customizing, developers work with ABAP, CDS and the Business Technology Platform. Our courses cover CDS Views and ABAP SQL through typical business transactions. You work in a practice environment, solve realistic tasks and take home checklists and working patterns you can apply straight away in daily operations or in your project. Delivered online or on site, at a fixed price per participant.

The course is delivered live – either online in a virtual classroom or on-site in our training rooms in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run it exclusively for your team.

Focus areas of the course

Data definitions and associationsAnnotations for UI, analytics and accessParameters, cases and aggregationsAccess control with DCLTable functions and performanceConsumption views and OData publishing

Who is this course for?

  • Clerks and business users in finance, procurement, sales, logistics and HR
  • Key users and process owners in SAP implementation and rollout projects
  • Consultants, analysts and project managers working with SAP systems
  • Developers and administrators who extend or operate SAP systems

What you will be able to do

  • You know the key topics of CDS Views and ABAP SQL – Data definitions and associations, Annotations for UI, analytics and access, Parameters, cases and aggregations, Access control with DCL, Table functions and performance and Consumption views and OData publishing – and can apply them in practice.
  • You move confidently in CDS Views and ABAP SQL and run the key transactions on your own.
  • You understand how master data, documents and reports relate to each other.
  • You recognize typical sources of error and can narrow down disruptions.
  • You apply what you learned to your own system landscape and processes.

Course outline

Module 1 Orientation and navigation for CDS Views and ABAP SQL
  • Where CDS Views and ABAP SQL sits in the SAP landscape and the business process
  • Key terms, organizational structures and master data
  • Navigation, transactions, favorites and search in the system
  • Roles and authorizations relevant to daily work
Module 2 Focus areas: CDS Views and ABAP SQL
  • Data definitions and associations
  • Annotations for UI, analytics and access
  • Parameters, cases and aggregations
  • Access control with DCL
  • Table functions and performance
  • Consumption views and OData publishing
Module 3 Core processes in CDS Views and ABAP SQL
  • Walking through typical business transactions step by step
  • Following documents, statuses and document flow
  • Recognizing and avoiding common entry errors
  • Reconciling with adjacent modules and interfaces
Module 4 Reporting, adjustment and quality
  • Using standard reports, lists and analyses
  • Basics of customizing, variants and configuration
  • Checking data quality and clarifying deviations
  • Documentation and handover to business or support teams
Module 5 Practice project and transfer
  • End-to-end exercise with a realistic CDS Views and ABAP SQL scenario
  • Troubleshooting prepared problem cases
  • Best practices from implementation and operations projects
  • Personal action plan for applying it in your own company
Module 6 Transfer to your daily work
  • Exercise based on a realistic case
  • Typical mistakes and how to avoid them
  • Checklist and templates to take away
  • Open questions, outlook and resources for further learning

Prerequisites

Depending on the course, basic knowledge of business administration or IT is enough. For levels 2 and 3, SAP experience or the preceding course is helpful. Basic knowledge of the topic is helpful.

Technical requirements

Laptop with a current browser; access to the practice environment is provided by us.

Dates & locations

For every location we suggest a date roughly four weeks ahead. Your preferred date is always possible.

  • Munich Mon, 14 December 2026 6 hrs Request
  • Salzburg Thu, 10 December 2026 6 hrs Request
  • Berlin Thu, 10 December 2026 6 hrs Request
  • Augsburg Wed, 16 December 2026 6 hrs Request
  • Hanover Fri, 11 December 2026 6 hrs Request
  • Bremen Tue, 15 December 2026 6 hrs Request
  • Stuttgart Thu, 10 December 2026 6 hrs Request
  • Kaiserslautern Thu, 10 December 2026 6 hrs Request
  • Online Thu, 10 December 2026 6 hrs Request

Frequently asked questions

Who is the CDS Views and ABAP SQL course for?

The course is for business users, key users, consultants and developers who use CDS Views and ABAP SQL in daily work or in a project. The course level shows whether it targets beginners or experienced participants. If you are unsure, we advise you beforehand on the right level.

Which system do I work with in CDS Views and ABAP SQL?

You work in a practice environment we provide, with sample data. On request we adapt scenarios to your industry. You do not need your own production system, so you can experiment without risk and trace errors in a targeted way.

How much does “CDS Views and ABAP SQL” cost?

The course costs a flat €949 plus VAT per participant – whether online or on-site. This includes 6 hours of live training with a trainer, course materials, a lab environment and a certificate of attendance.

Can I suggest my own date?

Yes. For every location we suggest a date roughly four weeks ahead. In the request form you can always describe your preferred date or period in free text – we check availability and get back to you within one working day.

Is the course online or on-site?

Both are possible: live online in a virtual classroom or on-site in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run the course exclusively for your team.

Can the course be tailored to our team?

Yes. Tailor-made courses cost approx. €4,500 more, depending on the topic and by arrangement. We agree content, examples and exercises with you in advance.

More courses in SAP

All 28 courses in SAP