Current news about SAP, ABAP, S/4HANA, BTP and more. Practical knowledge, insights and tips from our experts, compact and clearly prepared.
_A question as old as ABAP programming itself[^1]: Which is better? LOOP .. INTO, LOOP .. ASSIGNING, or LOOP ... REFERENCE INTO[^2]? Runtime often plays a big role in this discussion. But people frequently forget that the loop also has a loop body, which is executed on every single iteration.
The ABAP language has evolved t
Because of Corona, we have held all open training courses online since 2020. That is now over! We are looking forward to being able to offer all open training courses on-site in Mannheim again starting in April. We are convinced that this is the best way of learning and training.
This document describes the required steps to import the Transport A4HK990094 which contains the demo data model for the training “SQLScript for BW-Consultants” and a report for generating some data. Some screenshots in this document may refer to a different transport number. But A4HK990094
This page is intended for participants and prospective attendees of the open training SQLScript for BW Consultants. If you have any questions, please feel free to contact us at info@brandeis.de.
Registration is usually done via our website. Here we a
A common problem in SQL (and therefore also in CDS ABAP) is looking up individual data from another table (referred to here as the lookup table) without the data being multiplied out. As long as there is a :1 relationship, the solution with a normal join is trivial. But if several records qualify,
These AMDP programming guidelines are a proposal for ABAP and SAP BW projects. They were originally written for the use case of AMDP transformation routines in SAP BW/4HANA. Feel free to copy, modify and use them in your own projects as long as this article is linked as the source.
The 6th HANA Tech Night on May 23, 2022 was a great event. Especially because it took place live and on site with us at the Mafinex. Many interesting talks and also many interesting attendees. I really enjoyed the event.
I have prepared the slides for my talk a bit and make them available here:
<i
On April 26, 2022, we completely rebuilt the Brandeis Consulting website. The content should largely stay the same, but in the backend everything has changed completely. We switched from Wordpress (WP), the most widely used CMS worldwide with a 65% market share, to GatsbyJs. And for good reasons.
Or: If you want help, you should motivate the helpers positively.
When you post a technical question in a forum and want an answer to it, there are many things you can do wrong. But also many things you can do right. Well-described problems with sufficient information and relevance are usually answ
Note: The event will be held in German
Agenda
You will often encounter GUID and UUID in SAP HANA and in S/4HANA as key fields. As long as these do not have to be interpreted or converted, this is not a problem for SAP HANA. The prerequisite for this is a uniform data type. But there are different formats for UUID.
In this blog post, I would like to share a small example of an AMDP [aka. HANA Script or AMDP Script ((Actually there is no HANA Script or AMDP Script. These terms can only be found in the SAP BW environment in the Transformations. This neologism is a mixture of the te
_With AMDP debugging in transformation routines on BW/4HANA, errors can be easily found. An excerpt from my book ["SQLScript for SAP HANA"](http://Debug-Modus%20vs.%20optimierter%20Modus%20Damit%20Prozeduren%20mit%20dem%20AMDP-Debugger%20analysiert%20werden%20k%C3%B6nnen,%20werden%20diese%20im%20sog
_The AMDP framework provides an easy way to use database procedures in SQLScript, in ABAP programs and in BW transformation routines. An excerpt from the 2nd edition of my book "SQLScript for SAP HANA", published by [Rheinwerkverlag, SAP Press](htt
_With AMDP procedures, ABAP can easily and elegantly outsource more complex requirements in the SAP HANA database. An excerpt from the 2nd edition of my book "[SQLScript for SAP HANA](http://debug-modus%20vs.%20optimierter%20modus%20damit%20prozeduren%20mit%20dem%20amdp-debugger%20analysiert%20werde
CDS queries can only read data from CDS InfoProviders
Reporting directly in the transactional ERP system (e.g. S/4HANA) using CDS Views is called Embedded Analytics. Here, the CDS Q
The CDS InfoProvider Views form a modeling layer that serves as the starting point for Embedded Analytics in S/4HANA with CDS queries. However, the CDS InfoProviders can also be used directly as a source for queries in the Query Builder of the SAP BW M
Unfortunately, in the official SAP documentation there is no clear definition of designations to the CDS View types concerning their specific tasks and roles in the different frameworks . The articles and books in this area sometimes use different definitions here. For example, consumption v
ABAP Master
What is a SAP ABAP master? And why are we not looking for a "SAP ABAP developer", "SAP ABAP senior consultant" or "SAP ABAP trainer" in this job posting? Well, we are looking for that too, but it's not just about whether you can write ABAP programs. What matters
This cheat sheet contains a comprehensive overview of syntax, examples and descriptions o
This article is being published two months late. That's because there's almost always something more important to do than write an article about our new offices. But now I've finally found the time. Our old office simply became too small, and here at the [MAFINEX Technology Center](https://mafinex.n
Here are the slides from my talk on ADT at the ABAPConf 2021.
Note on the slides: This is not a recommendatio
Over the past few weeks, we have been working hard on our free HANA SQL beginner course. In doing so, we built a few useful new features into our HANA Web Console, making the begin
Brandeis Consulting GmbH is a small training and consulting company with 4 employees. Our focus is on SAP's software solutions, in particular the SAP HANA database and the SAP BW/4HANA data warehouse. A look at our homepage gives a good overview
In our office hours, we solve concrete problems brought by the participants together
We now have regular office hours in our program again. Now even weekly (with a few exceptions) every Monday at 5:15 PM. These
Our new, free HANA SQL course for beginners was published today on our e-learning site www.brandeis-training.de. The course is ideal for newcomers or as a refresher of basic SQL skills. For the exercises and examples, we use our self-developed [HANA Web Console](https://hwc.brandeis.de/console/?view
Officially, 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 and for the first time I am holding a bound copy in my hand. The format has become slightly large
We are very pleased that the DSAG has accepted our membership application. In the past, during my time as an employee at zetVisions AG, I frequently and gladly attended the meetings of the Development and UI working groups. There is no substitute
The HANA Web-Console (HWC) from Brandeis Consulting is the quick entry into SQLScript programming on the SAP HANA database. For trainings and also for the daily work with SQLScript it is very practical, if you don't have to start the SAP
