sum from table

[Former Member]

hallow

i have data base table with fields with hours and i wont to sum them into <b>one</b> field how i do that?

the table is z_hours

and fields are a1,a2,a3,ak,at.

Thankes

[Former Member]

Hi,,

if you want to sum up then

*data: begin of itab occurs 0,

*field type i,

*field1 type i,

*field2 type i,

*end of itab.

*

*data: wa like itab.

*data: m type i.

*

*itab-field = '10'.

*

*itab-field1 = '20'.

*

*itab-field2 = '30'.

*

*append itab.

*

*clear: itab.

*

*loop at itab .

*write:/ itab-field, itab-field1, itab-field2.

*wa-field = itab-field + itab-field1+ itab-field2.

*wa-field = wa-field + itab-field1.

*wa-field = wa-field + itab-field2.

*append wa to itab1. ( declarare a new table with those field in wa )

*write:/ wa-field, wa-field1, wa-field2.

*

*exit.

*endloop.

thanks & regards,

Venkatesh

[Former Member]

hi

i need to do this sum from table like select select

Regards

[Former Member]

GO THROUGH THIS LINK

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/collect.htm

here is sample code

DATA: BEGIN OF seats,

carrid TYPE sflight-carrid,

connid TYPE sflight-connid,

seatsocc TYPE sflight-seatsocc,

END OF seats.

DATA seats_tab LIKE HASHED TABLE OF seats

WITH UNIQUE KEY carrid connid.

SELECT carrid connid seatsocc

FROM sflight

INTO seats.

COLLECT seats INTO seats_tab.

ENDSELECT.

Please reward the helpful entries.

Regards,

Raman.