Cheat Sheet SAP RAP Basics
Der ultimative Spickzettel für die schnelle Erstellung eines RAP Objektes. Alles, was man zum Einstieg wissen muss und noch ein bisschen mehr.
Read more
CDS View Entities vs. DDIC-Based CDS Views
Introduction
The CDS View Entities are currently celebrating their 5th birthday. On September 2, 2020 I found the first blog post [A new generation of CDS Views: CDS view entities](https://community.sap.com/t5/application-development-and-automation-blog-posts/a-new-generation-of-cds-views-cd
Read more
ABAPConf 2025
The conference for ABAP Full Stack Developers
Submit your session: call for speakers
Read more
Review 10. HANA Tech Night & SAP CodeJam
The cover picture of the article symbolises the day: HANA Tech Night is celebrating its 10th birthday. And as with every HTN, there will be pizza and beer. But not only...
A brief look back at SAP CodeJam and the 10th HANA Tech Night, both held on 3 June in Mannheim. It was a really suc
Read more
Cheat Sheet - Modern ABAP
Cheat Sheet Modern ABAP
This poster is the perfect complement to the training courses
by Brandeis Consulting
The ABAP language has evolved t
AMDP Coding Guidelines
These AMDP programming guidelines are a proposal for ABAP and SAP BW projects. They were originally written for the use case of AMDP transformation routines in SAP BW/4HANA. Feel free to copy, modify and use them in your own projects as long as this article is linked as the source.
Call by Re
Read more
GUID and UUID in SAP HANA
You will often encounter GUID and UUID in SAP HANA and in S/4HANA as key fields. As long as these do not have to be interpreted or converted, this is not a problem for SAP HANA. The prerequisite for this is a uniform data type. But there are different formats for UUID.
Read more
AMDP debugging in transformation routines
_With AMDP debugging in transformation routines on BW/4HANA, errors can be easily found. An excerpt from my book ["SQLScript for SAP HANA"](http://Debug-Modus%20vs.%20optimierter%20Modus%20Damit%20Prozeduren%20mit%20dem%20AMDP-Debugger%20analysiert%20werden%20k%C3%B6nnen,%20werden%20diese%20im%20sog
Read more
HANA SQLScript Transformation Routines in BW/4HANA - an example
In this blog post, I would like to share a small example of an AMDP [aka. HANA Script or AMDP Script ((Actually there is no HANA Script or AMDP Script. These terms can only be found in the SAP BW environment in the Transformations. This neologism is a mixture of the te
Read more
AMDP procedures
_With AMDP procedures, ABAP can easily and elegantly outsource more complex requirements in the SAP HANA database. An excerpt from the 2nd edition of my book "[SQLScript for SAP HANA](http://debug-modus%20vs.%20optimierter%20modus%20damit%20prozeduren%20mit%20dem%20amdp-debugger%20analysiert%20werde
Read more
The AMDP Framework
_The AMDP framework provides an easy way to use database procedures in SQLScript, in ABAP programs and in BW transformation routines. An excerpt from the 2nd edition of my book "SQLScript for SAP HANA", published by [Rheinwerkverlag, SAP Press](htt
Read more
Embedded Analytics with CDS Queries - with Query Template
What are CDS Queries?
CDS queries can only read data from CDS InfoProviders
Reporting directly in the transactional ERP system (e.g. S/4HANA) using CDS Views is called Embedded Analytics. Here, the CDS Q
Read more
CDS InfoProvider - The solid basis for Embedded Analytics in S/4HANA
The CDS InfoProvider Views form a modeling layer that serves as the starting point for Embedded Analytics in S/4HANA with CDS queries. However, the CDS InfoProviders can also be used directly as a source for queries in the Query Builder of the SAP BW M
Read more
The different CDS View types
Unfortunately, in the official SAP documentation there is no clear definition of designations to the CDS View types concerning their specific tasks and roles in the different frameworks . The articles and books in this area sometimes use different definitions here. For example, consumption v
Read more
Cheat Sheet CDS ABAP
Cheat Sheet CDS ABAP
The perfect complement to Brandeis Consulting's training courses
This cheat sheet contains a comprehensive overview of syntax, examples and descriptions o
The 2nd edition of SQLScript for SAP HANA is now available.
Officially, the 2nd edition of SQLScript for SAP HANA, the English edition of my book, has been available since mid-August. Today I received my author copies from SAP PRESS and for the first time I am holding a bound copy in my hand. The format has become slightly large
Read more
The HANA Web Console from Brandeis Consulting
The HANA Web-Console (HWC) from Brandeis Consulting is the quick entry into SQLScript programming on the SAP HANA database. For trainings and also for the daily work with SQLScript it is very practical, if you don't have to start the SAP
Read more
The 2nd edition of SQLScript for SAP HANA will be published in August
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.
New topics
The ABAPVARCHARMODE: Blanks and Empty Strings in ABAP and SQLScript
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
HANA Express images deleted in the cloud
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
Read more
SQL Expressions in BW/4HANA Composite Provider (HCPR)
With the SPS04 for BW / 4HANA 2.0, SAP has built some useful features into t
Read moreCheat Sheet - The SAP HANA SQLScript Overview
Cheat Sheet - The SAP HANA SQLScript Overview
This SQLScript Overview is the perfect complement to the training of Brandeis Consulting
Syntax, examples and descriptions, matchin
AMDP (ABAP Managed Database Procedures)
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
Read more
Reusing Business Logic in AMDP Transformation Routines
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
Read more
Treat unallowed characters in SAP BW/4HANA with SQLScript
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.
Read more
Why are scalar UDFs so slow?
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:
- Add and remove leading zeros
- Case distinctions
- Remove spaces at the beginning or end
- Co
Neo environment will be switched off
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
SQLScript Unit Tests, the End-User Test Framework
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
Read more
User Defined Libraries (UDL) in SQLScript
SAP HANA 2.0 SPS03 introduced the concept of User Defined Libraries (UDL) in SQLScript. It enables us as developers to bundle several functions, procedures and variables in one object. All components of a UDL are defined in one piece of source code and only one metada
Read more
Anonymous Functions in SQLScript
With SAP HANA 2.0 SPS04, another feature has been added to the SQLScript language: The embedded functions. These enable the use of imperative SQLScript code within a SELECT query. These functions are created and executed only for exactly this one query. This r
Recursive procedure calls in SQLScript
Up to SAP HANA 2.0 SPS03 recursive calls in SQLScript were not allowed. This means that a procedure may not call itself either directly or indirectly via other procedures. This restriction was removed with SPS04. However, the call depth is limited to 32 and procedures
Read more
Optimal Package Size for DTPs in BW/4HANA
With BW/4HANA 2.0 I observed that the packet size of the DTPs is dynamically suggested by the system. Figure 1 shows, for example, a suggested size of 1,311,000 data records. In this way, the system dares to go into an order of scale, that is better than the former fixed standard value of 100,000 ro
Read more
BW/4HANA Cockpit - Where is the Administration in the SAP GUI?
BW/4HANA 2.0 no longer supports the administration of InfoProviders and requests in the SAP GUI. Instead, a browser window with the SAP BW/4HANA cockpit opens when we click on the administration of the ADSOs or start a DTP and the DTP monitor opens. You can find the SAP documentation for the B
Read more
Uploading Transport Requests to an SAP CAL System
In the SAP Cloud Appliance Library (CAL), you can use SAP's latest systems in the cloud with little effort. Some of the systems are free for certain purposes, and are great for learning new technologies. Especially the DEV systems can be used well for this purpose.
If you
Read more