topic Re: Sub Total in Application Development and Automation Discussions

Sub Total

Former Member — Fri, 10 Jul 2009 10:47:31 GMT

Hai All,

I have an internal table with following fields

vbeln TYPE vbrk-vbeln,

kbetr TYPE konv-kbetr,

kawrt TYPE konv-kawrt,

agentcomm TYPE konv-kwert,

i want to find the sub total of KAWRT and agentcomm at change of vbeln and kbetr

Regards

Nausal

Re: Sub Total

venkat_o — Fri, 10 Jul 2009 10:57:11 GMT

Hi,

Try this way


DATA: BEGIN OF it_data OCCURS 0,
        vbeln TYPE vbrk-vbeln,
        kbetr TYPE konv-kbetr,
        kawrt TYPE konv-kawrt,
        agentcomm TYPE konv-kwert,
      END OF it_data.

*Get the data from tables
*sort it_data by vbeln kbetr
SORT it_data BY vbeln kbetr.

LOOP AT it_data.
  AT END OF vbeln.
    SUM." You will get sum here. Check it_data-kawrt
  ENDAT.
  AT END OF kbetr.
    SUM." You will get sum here. Check it_data-kawrt
  ENDAT.
ENDLOOP.

Thanks

Venkat.O

Re: Sub Total

Former Member — Fri, 10 Jul 2009 11:00:55 GMT

Hope this may help you

 
sort i_itab by vbeln kbetr.
loop at i_itab into wa_itab.

ws_subtotal_kawrt = ws_subtotal_kawrt + wa_itab-kawrt.
ws_subtotal_agcom = ws_subtotal_agcom + wa_itab-agcom.

at end of kbetr
   write: ws_subtotal_kawrt ws_subtotal_agcom.
   clear ws_subtotal_kawrt ws_subtotal_agcom.
endat

endloop.

Thanks,

Muthu

Re: Sub Total

Former Member — Fri, 10 Jul 2009 11:12:02 GMT

HI,

YOU MAY USE ON CHANGE OF ALSO,

sort itab by vbeln.

loop at ITAB into wa.

ON CHANGE OF VBELN

sum.

endon.

at end of vbeln

write kawrt.

endat.

endloop.

Re: Sub Total

Former Member — Thu, 01 Oct 2009 05:10:44 GMT

using internal ables to find sub total by using at end of