Got his first Commodore 64 at the age of eight and started programming in Basic. An enthusiastic ABAP and .NET programmer, BW developer – with a pragmatic mindset. Read more about Oliver, or see his other posts

Script debugging in Lumira Designer

Developers need some basic tools to do their job properly and effectively, these are: a development environment with auto-complete a decent espresso-machine a debugger Unfortunately, while the choice of espresso (, pour-over, or any other form of coffee you prefer) basically depends on your budget, taste and skills, debugging in Lumira Designer is pretty limited……

Can you solve this ABAP riddle?

Do you know what this ABAP code line does? It replaces three variable definitions, a loop, two value assignments and a table append in a single line of code. The corresponding “traditional” code could look something like this: Semantically speaking: it will copy the contents of table lt_s into table lt_t for each column that exists…

Lossless rounding in SQL – part II

In a previous blog post I presented a ‘common sense approach’ to distribute a value onto detail records without a rounding error. Remember, we were distributing 100 EUR – which is 10.000 cents – to 6 records. 10000/6=1666, the remainder is 4, so 4 of the 6 records get one plus cent. The benefit of this…

Lossless rounding in SQL – part I

When developing planning applications with SAP BW IP or BPC, you will almost certainly face the need to distribute a total value onto detail records. If this shall happen during data entry in an input-ready query you can use the disaggregation option in QueryDesigner or BW Modeling Tools – the system will take care of…