Hi All,
I have a requirement to create a generic extractor using a InfoSet query. The report that I have written has the internal table following format.
vkorg campyr_nr active_reps reinstated_reps removed_reps
111 201201 0 1 1111 201201 1 1 1
111 201202 1 1 0
111 201202 0 0 1
111 201203 0 0 0
The output should be:
vkorg campyr_nr active_reps reinstated_reps removed_reps
111 201201 1 2 2
111 201202 1 1 1
111 201203 0 0 0
As the values for these rep fields will be either 0 or 1, I tried the following logic but did not work.
loop at it1 into wa1
AT END OF campyr_nr.
SUM.
ENDAT.
Append wa1 to it_data.
Is there any other way to do it?
Early reply would be appreciated.
Thanks.