Sub Total

[Former Member]

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

[Former Member]

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

[venkat_o]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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