topic Re: sum from table in Application Development and Automation Discussions

sum from table

Former Member — Mon, 20 Aug 2007 06:39:59 GMT

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

Re: sum from table

Former Member — Mon, 20 Aug 2007 06:42:42 GMT

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

Re: sum from table

Former Member — Mon, 20 Aug 2007 06:46:49 GMT

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.

Re: sum from table

Former Member — Mon, 20 Aug 2007 07:14:14 GMT

i need to do this sum from table like select select

Regards