2019 Jul 17 3:18 PM
have the following ALV report generated from the RFKSLD00
program:
I need to generate a report based on the above report like this one (as part of my work):
Any ideas how to do this? No need for a solution but at least some steps on how to achieve this
2019 Jul 17 3:42 PM
I'm pretty sure that the capturing of an ALV output has been covered here before. You could try searching. Never done it myself.
2019 Jul 17 3:44 PM
The as-is standard program has the data your to-be example describes. If the goal purely cosmetic, the user community needs training, not a program rewrite.
2019 Jul 18 1:49 AM
The final report is depend on what technical you would use: ALV, smartform, adobe form, excel... But first thing you have to export the output data of standard report by submit it in your own program.
2019 Jul 18 8:18 AM
if you are expecting the results of standard program to be reformatted in your own format, kindly explore SUBMIT <reportname> EXPORT LIST TO MEMORY AND RETURN.
post this statement you need to use FM LIST_FROM_MEMORY and LIST_TO_ASCII. Kindly explore this keyword.
2019 Jul 18 1:58 PM
Hi Muaz,
you can acheive above requirement through ALV
method 1. ole concept
method 2. by using class cl_gui_alv_grid.its having all the methods to acheive your format.
or use below xml interfaces IF_IXML_ELEMENT,if_ixml_attribute,if_ixml_ostream,if_ixml_stream_factory.
2019 Jul 18 3:54 PM
2019 Jul 23 5:47 PM
Your question "How to do that" is unclear, what is "that"? (getting the result of RFKSLD00, tracing lines, using a given technology, transferring the values into columns, etc.)
If it's about how to know to what month the totals of the ALV (first screenshot) correspond, then it's easy, 01 2003 means January, so put the Debit/Credit totals into January column. Run RFKSLD00 again for February, put the Debit/Credit totals into February column. And so on.