Online Training: Window Functions in SQLScript

Online Seminar: Window Functions in SQLScript

This seminar will be held live, free of charge and in color on Friday, March 27th at 2:00 PM. If you register on the right, you will receive the access details in good time.

Content

This seminar covers the basics of window functions in SQLScript, the SQL dialect of the SAP HANA database. The so-called window functions are always helpful whenever we work with control level processing (group change) in ABAP, or when we want to remember the value from the previous loop iteration within a LOOP.

Required Prior Knowledge

You should bring basic SQL knowledge to this training. An understanding of aggregate functions such as SUM( ) or AVG( ) is helpful.

Procedure

The seminar will be conducted via ZOOM. Up to 100 participants can attend live. In addition to my slides and demos, exercises are also planned. These will be carried out in so-called breakout sessions as small groups of 2-3 participants. Each group needs access to the SQL console of an SAP HANA system, as well as the authorization to create tables on it.

Dealing with Level D Code in S/4HANA

SAP's Clean Core Level concept has now been around for about a year. It replaces the old 3-tier model and no longer rates existing Z-code in binary terms as "clean" or "not clean," but on four levels from A to D. At the very bottom is Level D: things SAP actively advises against — using "noAPI" obje

New!

Authorizations in CDS and RAP — An Overview

July 26, 2026

Marcel Hermanns

Authorizations in CDS and RAP — An Overview

In customer projects, we keep noticing that authorizations are often a rather unpopular topic. Not infrequently, the authorization concept is reduced to assigning the authorization object S_START (OData V4) or S_SERVICE (OData V2) to the user role –