topic Re: about report program in Application Development and Automation Discussions

about report program

Former Member — Sun, 12 Feb 2006 12:21:17 GMT

select sum(money) from table group by rate.

this is query for sum gropu by rate.

how to write this query for internal table

Re: about report program

athavanraja — Sun, 12 Feb 2006 12:27:57 GMT

data: begin of itab occurs 0 ,

rate

money

end of itab .

sort itab by rate money .

loop at itab .

at end of rate .

sum .

endat .

endloop .

Regards

Raja

Re: about report program

athavanraja — Sun, 12 Feb 2006 12:43:10 GMT

here is the code sample.

data: begin of itab occurs 0 ,
      rate(1) ,
      money(16) type p decimals 2 ,
      end of itab .

move: '1' to itab-rate ,
      '10' to itab-money .
append itab .
clear itab .

move: '1' to itab-rate ,
      '20' to itab-money .
append itab .
clear itab .

move: '1' to itab-rate ,
      '30' to itab-money .
append itab .
clear itab .

move: '2' to itab-rate ,
      '20' to itab-money .
append itab .
clear itab .


move: '2' to itab-rate ,
      '40' to itab-money .
append itab .
clear itab .


move: '2' to itab-rate ,
      '50' to itab-money .
append itab .
clear itab .

sort itab by rate money .

loop at itab .

at end of rate .
sum .
write:/ itab-rate ,
        itab-money .
endat .

endloop .

Regards

Raja

Reward the helpful answers by clicking the radiobutton

Re: about report program

Former Member — Sun, 12 Feb 2006 15:46:25 GMT

or if you are filling the internal table in a loop, you can also use the COLLECT statement.