Current news about SAP, ABAP, S/4HANA, BTP and more. Practical knowledge, insights and tips from our experts, compact and clearly prepared.
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
February is just around the corner. On the evening before the DSAG Technologietage 2020, the 4th HANA Tech Night will take place here in Mannheim. We were able to secure three sessions with very interesting topics for this event:
"In software engineering and computer science, a call stack (also known as procedure stack) is a specially used stack that holds the state of the subroutines currently being called during the runtime of a program." (Wikipedia)
Sometimes it is important to know the context from which a method
With version 2.0 of the SAP HANA database, another useful operator was added to SQLScript for declarative code: MAP_MERGE. It solves the occasional problem where a table function needs to be executed for all N rows of a table. The N result tables should then be combined
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
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
With SAP HANA 2.0 SPS04, another feature has been added to the SQLScript language: embedded functions. These allow the use of imperative SQLScript code within a SELECT query. Such functions are created for exactly this one query and are executed only there. Since t
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
After freelancers complained that they can never take advantage of the team discount for my SQLScript training courses, I have decided to offer a Christmas discount of 30%. - Freelancers only. December only.
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
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
With BW/4HANA 2.0, the administration of InfoProviders and requests in the SAP GUI is no longer intended. Instead, a browser window opens with the SAP BW/4HANA Cockpit when we click on the administration of the ADSOs or start a DTP and the DTP monitor is supposed to open. You can find SAP's docu
Subsequent recording of the webinar fr
Are you already using SAP BW on HANA or SAP BW/4HANA? And are you also making full use of the potential of the SAP HANA database, or do you still rely on ABAP transformation routines? In this free
The final round of my SQLScript for BW consultants training on August 1 & 2, 2019 took place online. This allowed the participants to attend from their office or from home, without the hassle and costs of traveling here to Mannheim. Thanks to modern conferencing software (we tried both Zoom and GoTo
On 9/13/2019 at 2:00 PM, this free webinar will introduce you to the benefits of HANA execution and ABAP Managed Database Procedures (AMDP) in BW transformations.
Click here for the event details
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
At the 2nd HANA Tech Night, I gave a talk about processing hierarchies with SQLScript. Here are the slides:
Download Handle-Hierarchies-with-SQLScript
[
](/Handle-Hierarchies-with-SQL
My book was published in English at the end of March. Since May 21, it has also been available in Germany, e.g. directly through Rheinwerk Publishing.
At the 2nd HANA Tech Night Mannheim, I will give a short talk about processing hierarchies in SQLScript. Highlights include the SAP HANA hierarchy functions and the concept of nested sets for storing hierarchies.
You can find the details here:
[https://www.meetup.com/de-DE/HANA-Developers-Mannhe
With the SELECT statement, we can request data from the tables of the database. The result of the SELECT statement is also a table, i.e. it consists of columns and rows. At first, you can think of it like an Excel spreadsheet. The simplest form of the SELECT statement looks
On February 19th, the first HANA Tech Night Mannheim will take place. I will be giving a short talk there titled "SQL Developers Think Differently".
Registration is handled via the Meetup portal:
[https://www.meetup.com/de-DE/HANA-Developers-Mannheim/events/258187456/](https://www.meetup.com/de-
The translation is scheduled to be finished by January 11. After that, I still have to deliver the translated listings and screenshots or figures. This will keep me busy throughout the Christmas season.
The copyediting will then take place until January 25, and afterwards I will receive the galley
I'm currently in contact with the American branch of Rheinwerk Publishing about a translation of my book. At first I was asked whether I might be able to do it myself, but unfortunately I had to decline. I simply don't have the time for that. Nor the necessary language skills.
A few new parameters have crept into the interface of AMDP routines for BW transformations. This is generally to be welcomed, since the "old" ABAP world provided considerably more information within the routines. However, the new parameters are still only of limited use.
So far I haven't bee
As of SAP BW 7.50, it is possible to implement query variables using a SAP HANA exit in SQLScript. This allows the variable to be prefilled or calculated without involving the ABAP stack. I have not yet described this approach in the current edition of my book "SQLScript for SAP HANA", whi
To learn the SQLScript language, the SQL console of the various development environments (IDEs) is the ideal tool. In this post I would like to briefly explain why the SQL console is not just a tool for nerds. When it comes to learning SQLScript, it is even considerably superior to the other interfa
On 28 September 2018, the first edition of my book SQLScript for SAP HANA was published.
SAP Fiori Elements is a framework that lets you develop standardized applications with little frontend code. Instead of programming user interface
