topic Re: Table values in Application Development and Automation Discussions

Table values

Former Member — Tue, 28 Nov 2006 16:01:29 GMT

Hi ,

I need to bring the total of all the data of a field of a Database table .How do I do it?Any one please give me the syntax.

Thanks

Re: Table values

Former Member — Tue, 28 Nov 2006 16:04:45 GMT

UPDATE ZTABLE set total = v_total  where field1 = v_field1.

in the where condition give all the key fields

Re: Table values

anversha_s — Tue, 28 Nov 2006 16:05:03 GMT

hi bharat,

use COLLECT statement.

rgds

Anver

Re: Table values

Former Member — Tue, 28 Nov 2006 16:05:36 GMT

Hi Bharat,

Use SUM( database-field) to get the sum of the data field.

SELECT SUM( DBFIELD )

INTO V_SUM

FROM DB_TABLE.

Thanks,

Vinay

Re: Table values

Former Member — Tue, 28 Nov 2006 16:06:00 GMT

hi Bharat,

Bring the data on to an Internal Table and use <b>Collect</b> or Sum statement ..

Regards,

Santosh

Re: Table values

Former Member — Tue, 28 Nov 2006 16:06:04 GMT

take the data into internal table

and then use<b> COLLECT</b>

Re: Table values

Former Member — Tue, 28 Nov 2006 16:08:47 GMT

Hi,

Use SUM instead of Collect statement .

Cheers.

Re: Table values

Former Member — Tue, 28 Nov 2006 16:09:10 GMT

Hi there. You can use SUM to accomplish this. Here's some example code:

DATA: itab_wa LIKE LINE OF itab.

LOOP AT itab INTO itab_wa.

AT LAST.

SUM.

WRITE: / 'Sum', itab_wa-numfield.

ENDAT.

ENDLOOP.

The SUM statement will put the sum of the numeric fields for your internal table (itab) into the itab_wa record. Hope this helps.

- April King