_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 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 two SAP programming languages [ABAP](/en/blog/category/abap/) 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 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 moreWith 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 moreBW/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
