_The conference for ABAP Full Stack Developers_ [Submit your session: call for speakers](https://docs.google.com/forms/d/e/1FAIpQLSdSFBeYjR7aVzeowNJkwwquVC_kykTpP1GTisdbUSkBq2JGpA/viewform) --------------------------------------------------------------------------------------------------------
Read moreThe 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 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 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 ![](https://cms.brandeis.de/uploads/EN_2_Auflage_3
Read moreThe 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
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 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
