topic Re: need help in Application Development and Automation Discussions

need help

Former Member — Thu, 26 Jul 2007 11:52:44 GMT

Hi all,

I have data like this.

Type Quater1 Quater2

Tax Refund 1000 2000

Tax Refund 2000 3000

Tax Refund 2000 2000

Tax Refund 3000 1000

Tax Refund 5000. 1000

but in my final output I want to display

type Quater1 Quater2

Tax Refund 13000 9000.

How can i do that in ALV.

regards,

Ajay reddy

Re: need help

Former Member — Thu, 26 Jul 2007 11:54:59 GMT

Hello Ajay,

Use Collect itab instead of Append Itab

Vasanth

Re: need help

Former Member — Thu, 26 Jul 2007 11:55:42 GMT

Hi, you can collect tha dates.

If you collect you display the date how you want.

Re: need help

Former Member — Thu, 26 Jul 2007 11:56:22 GMT

put the data in ITAB

sort itab by first field

use at end of ..

do SUM.

and display the data.

sort itab by taxtype.

loop at itab.

at end of taxtype.

sum.

write:/ itab-taxtype, itab-amnt1, itab-amnt2.

endat.

endloop.

Reward points for useful Answers

Regards

Anji

Re: need help

Former Member — Thu, 26 Jul 2007 11:56:42 GMT

Use this code:

loop at itab1.
  collect itab1 into itab2.
endloop.

itab2 will have your desired output.

Please mark points if the solution was useful.

Regards,

Manoj

Re: need help

Former Member — Thu, 26 Jul 2007 11:57:33 GMT

Hi Ajay,

If you want to display only the TOTAL lines, then you can loop into your internal table and COLLECT the date into another internal table. Pass that to the function module.

LOOP AT ITAB1 into LS_ITAB1

LS_ITAB2 = LS_ITAB1.

COLLECT LS_ITAB2 to IT_ITAB2.

ENDLOOP.

Pass ITAB2 to your function module for ALV Grid.

If you want to display line items as well as SUM then while building Field Catalog use the property DO_SUM = X and pass it to the Function module.

Reward points for informatory answers.

Best Regards,

Ram.