Here I occasionally publish updates on SQLScript, SAP BW/4HANA or other news from the SAP World or my training program.
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 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