Current news about SAP, ABAP, S/4HANA, BTP and more. Practical knowledge, insights and tips from our experts, compact and clearly prepared.
In this article, I want to demonstrate the different ways to store hierarchies in SAP HANA ((Of course, these are all general approaches that are possible in any database. However, in the evaluation at the end of the article, I will briefly touch on the hierarchy function
The 2nd edition of the English edition of SQLScript for SAP HANA is scheduled for release on August 26, 2021. The issue is updated and expanded with a few new topics. It thus largely corresponds to the current German edition.
I regularly use the article Cheat Sheet – The Big SQLScript Overview as a cheat sheet myself. That's why I had it printed as a SQLScript poster in DIN A1 format. After the course, all parti
By the scope of a training course, we mean in this article how much time we take to convey a given set of content. The right amount depends on ma
The two SAP programming languages ABAP and SQLScript (aka. HANA SQL) behave differently when it comes to processing strings with blanks. This can lead to errors and confusion. It is therefore important to understand the ABAP VARCHAR mode o
In February, I held a webinar for the customers of Bitech AG in Leverkusen on the topic "SQLScript in SAP BW/4HANA - the alternative to ABAP".
SQLScript is the SQL dialect of the [SAP HANA database](/blog/category/sap-h
Now let's get more concrete. We will tackle the topics we saw in the previous article about the problems with BEx exit variables step by step. To do so, I would first like to introduce a few terms that I will use in the following.
At very short notice (July 29, 2024) I received a message that my server would be shut down on August 31, 2024. So this happens with exactly 1 month's notice and right in the middle of the summer holidays, when no one has time to deal wi
SAP has unfortunately decided to stop making its VM images of the free HANA Express , which were previously available in the cloud from hyperscalers, available. So far, I have been a fan of HANA Express systems in Google Cloud Platform (GCP
With the SPS04 for BW / 4HANA 2.0, SAP has built some useful features into t
The source code implementing the BAdI for customer exit variables is a disaster for quality-conscious developers, because it violates several Clean Code principles. And the BAdI concept in SAP BW/4HANA doesn't make things any easier here.
This article is part of a series on the topic "A design patt
In this series of articles, I address a topic that is relevant to every BW/4HANA project: the implementation of customer exit variables. There is a lot of uncontrolled growth here, and in most older BW systems things look pretty chaotic. This is true even when someone has developed
Syntax, examples and descriptions, matchin
Last week I read Lars Breddemann's great article about separating business logic from the underlying database tables without using dynamic SQLScript. This is a problem that a
With the ABAP Managed Database Procedures, or AMDP for short, SAP succeeds in making the performance of the SAP HANA database in ABAP developments easy to use. This is a framework that now includes not only SQLScript procedures, but also functions and also allows the
With SQLScript, errors can be avoided elegantly and performantly during loading due to the unallowed (i.e. invalid) characters in SAP BW. This article provides an overview of the problem and outlines the solutions in AMDP transformation routines to clean up the data.
When loading data from source systems, there are requirements in SAP BW that are often repeated at the field level. This includes, above all, logics for cleaning up and processing the data, such as:
Tonight I gave a short talk about creating e-learning courses as part of the SAP Online Track Munich and Vienna. Mike Meister drew a brilliant summary:
Until now, I had never given any thought to the compatibility between SAP HANA Cloud and HANA 2.0. The backward compatibility of ABAP is legendary; you could always rely on SAP in that regard. However, while running the [installation scripts for the demo data model](https://github.com/captainabap/SQ
This blog series is, for once, not about SQLScript, but primarily about ABAP. Transformation routines in SAP BW can be implemented in both programming languages. And there have always been, and still are, many customers who like to use ABAP for this. There are various reasons for this. One major str
The Neo environment of the SAP Cloud Platform will be switched off on November 14th! This also means that a popular opportunity to create a HANA instance with SQL console is disappearing...
Next week will be followed by a blog post on how to achieve this in the Cloud Foundry environment.
The e
Since the beginning of August, the first video course "SQLScript Basics" has been available on our site www.brandeis-training.de.
This video course is designed as full-fledged training and correspo
Anyone who runs a BW/4HANA developer system in the SAP Cloud Appliance Library knows the problem: if you forget to apply the license in time (SAP Note 1644792, [SAP documentation](https://help.sap.com/viewer/6b94445c94ae495
With the concept of DML[^1] table variables, SAP has usefully extended the previous concepts for modifying access to table variables in SQLScript. Index-based access and the change operators were cumbersome and required a lot of imperative source code to make changes in a table. This
With version 2.0 SPS04 of the SAP HANA database, the so-called "End-User Test Framework in SQLScript" was introduced. This makes it possible to create SQLScript Unit tests in the form of [User Defined Libraries (UDL).](/en/blog/user-defined-libraries-udl-in-sqlscript
For SAP consulting firms and freelance SAP consultants, the current crisis offers a great opportunity to bring their know-how up to speed. And at significantly lower costs than usual.
In recent years, thanks to the SAP HANA database and the associated new products S/4HANA and BW
Over the last few weeks I have run a number of online training courses. In doing so, I tried out various tools and formats. Because I don't just want to hold the proven in-house training courses online on a 1:1 basis. And of course I also diligently collected feedback from the participants so that I
On May 25, 2020, the 2nd, updated and expanded edition of the German version of my book SQLScript für SAP HANA published by Rheinwerk Verlag was released. When the first edition came out in September 2018, I never imagined that demand w
Due to the current situation, classroom training is unfortunately no longer possible. Online seminars are a good alternative. They are a great solution, both as a replacement for open training courses here in Mannheim and for i
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.
This seminar covers the basics of window functions in SQLScrip
