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…