I had a requirement given by the business which was a bit difficult. The data was to be pulled from FI and MM module and combined in one report.
The report had to have 5 sections
- For section 1 the data needs to be pulled from FI
- For section 2 the data needs to be pulled from MM
- For section 3 the data needs to be pulled from FI
- Sub total
- Grand total
I decided to explore all this by using the AMDP method. Given below is a screen shot of my procedure for the first 2 points.
I added one column called color in the structure which i will be using in the ABAP coding. I am also using the select from dummy to add a heading row.
Finally i do a union all and assign it in the out parameter of the procedure.
This is for retrieving the data
This is for the subtotal
In the ABAP Code
For coloring the line just add the line highlighted in the layout
The final out put
I Hope this helps the fans of code push down.