Blog

News about SQLScript, BW/4HANA and Everything

Here I occasionally publish updates on SQLScript, SAP BW/4HANA or other news from the SAP World or my training program. 

Cloud System nicht mehr verfügbar

HANA Express images deleted in the cloud

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

More >>

SQL Expressions in BW/4HANA Composite Provider (HCPR)

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

More >>

Cheat Sheet SAP HANA SQLScript

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

More >>
Wiederverwendung von AMDP Transformationsroutinen

Reusing Business Logic in AMDP Transformation Routines

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

More >>
Quellcode

AMDP (ABAP Managed Database Procedures)

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

More >>
Schwareze Schaafe

Treat unallowed characters in SAP BW/4HANA with SQLScript

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.

More >>

Request more information

This post is also available in: Deutsch

Wollen Sie mehr Informationen?

Unverbindliche Anfrage

Do you want more information?

Inquiry