Here I occasionally publish updates on SQLScript, SAP BW/4HANA or other news from the SAP World or my training program.
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
With SPS04 for BW/4HANA 2.0, SAP has added some useful features to the composite provider: New join types are possible: Full Outer, Referential, Right Outer Join The restrictions regarding the order of JOIN and UNION nodes no longer apply. The
The perfect complement to the training of Brandeis Consulting Syntax, examples and descriptions, matching the contents of the SQLScript basic training at Brandeis Consulting. This overview shows only the most important aspects. For details, please follow the links to the
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 also arises again and again in SAP BW/4HANA: the reuse of logic in AMDP
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
With SQLScript, errors can be avoided elegantly and performantly during loading due to the unallowed 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.
This post is also available in:
Deutsch
