_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
Read moreYou will often encounter GUID and UUID in [SAP HANA](/en/blog/category/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_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 moreIn this blog post, I would like to share a small example of an [AMDP](/en/blog/category/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_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 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](/blog/die-2-auflage-von-sqlscript-fuer-sap-hana/)", published by [Rheinwerkverlag, SAP Press](htt
Read moreOfficially, 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](https://www.sap-press.com/) and for the first time I am holding a bound copy in my hand. The format has become slightly large
Read moreThe HANA Web-Console (HWC) from Brandeis Consulting is the quick entry into SQLScript programming on the [SAP HANA database](/en/blog/category/sap-hana/). For trainings and also for the daily work with [SQLScript](http://categorey/sqlscript) it is very practical, if you don't have to start the SAP H
Read moreThe 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  and [SQLScript](/en/blog/category/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
Read more[](https://youtu.be/Bz6DfAsVrng) With the [SPS04 for BW / 4HANA](https://help.sap.com/viewer/b3701cd3826440618ef938d74dc93c51/2.0.6/de-DE/d8b12ec099e04e6aa77a312be687db63.html) 2.0, SAP has built some useful features int
Read more# Cheat Sheet - The SAP HANA SQLScript Overview <div class="outer-columns cs-sqlscript"> <div class="inner-columns"> <div class="column"> <div class="cs-tile"> ### This SQLScript Overview is the perfect complement to the training of Brandeis Consulting Syntax, examples and descriptions, matchin
Read moreLast week I read [Lars Breddemann's](https://www.lbreddemann.org/separate-business-logic-from-tables-and-avoid-dynamic-sql/) great article about separating business logic from the underlying database tables **without** using dynamic [SQLScript.](/en/blog/category/sqlscript/) This is a problem that a
Read more_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](/blog/das-amdp-framework/) transformation routines to clean up the data._
Read moreWhen 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
Read moreWith 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](/en/blog/category/sqlscript/) Unit tests in the form of [User Defined Libraries (UDL).](/en/blog/user-defined-libraries-udl-in-sqlscript
Read moreSAP HANA 2.0 SPS03 introduced the concept of User Defined Libraries (UDL) in [SQLScript](/en/blog/category/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 moreWith SAP HANA 2.0 SPS04, another feature has been added to the [SQLScript](/en/blog/category/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
Read moreUp to SAP HANA 2.0 SPS03 recursive calls in [SQLScript](/en/blog/category/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
