This article started with my blog post Suggestions for better object oriented design . After I have published it on LinkedIn, @ennowulff started a friendly discussion about composition vs inheritance; and sent me a GitHub repo containing his design ...
Today, I would like to demonstrate a very simple but effective programming habit that I use in ABAP development: "TODO based coding".
The idea is to plant TODO comments into the code (typically among multiple programs / classes) before actually star...
ABAP CDS Views are great and all; however, they don't support subqueries at this time. In this post, I would like to share a workaround which functions similar to "NOT EXISTS".
The requirement was to exclude material document items (MSEG) which were...
In this post, I will share a general purpose class covering the multiton design pattern. By implementing a simple interface, you can add multiton functionality to your existing classes.
What is multiton, anyway?
Multiton is a performance oriented d...
As many of you already know, ABAP supports the UNION command now. UNION is an SQL command to combine the results of two separate queries into one dataset.
Here is a sample dataset from the imaginary database table Z1:
ID
TEXT
001
One
00...
In terms of performance, "For all entries" is usually evil.If you are on Hana, try this instead: SELECT
FROM gt_vbrk AS _vbrk
INNER JOIN ZDIGI_OOWARD_H as _z ON _z~ACCVOUCHERNO = _vbrk~vbeln
FIELDS _z~ACCVOUCHERNO, _z~EWBNUMBER
INTO TA...
For handling such complex aggregate functions, I highly suggest utilizing AMDP (ABAP Managed Database Procedures). In the initial query, construct 'billing_month' and gather other relevant fields into your ITAB1. In the subsequent query, execute a "S...
I encountered the same error last week. It appears that the CDS engine reads excessive data during the execution of Join conditions. Fortunately, I was able to resolve the issue using SqlScript (AMDP).Within my CDS, I had four tables - let's refer to...
sun_light here is a sample link: https://keremkoseoglu.wordpress.com/2020/03/16/how-to-steal-data-from-standard-sap-reports/ . You have to replace the EXPORT TO MEMORY part with a temporary table though.
You can try enhancing rkcfile7. Add a hidden parameter to the selection screen, let's call it P_SECRET.Pick a strategic spot where the output is prepared but not yet printed. If P_SECRET = 'X', write the data to a temporary table and leave the progra...