topic Re: SUM in Select Query in Application Development and Automation Discussions

SUM in Select Query

Former Member — Thu, 01 Jun 2006 07:41:30 GMT

Wanna select 5 fields (numeric) from a ztable based on date :

After selecting want to <b>add</b> them and move them to respective variable .

Say APP_SITES to gv_btr21,

SITE_CON to gv_btr22 etc.,

Query I wrote:

select APP_SITES SITE_CON LAND_COST TOTAL_CIP TOTAL_EXCL RES_NEED

from zreserve

into ( gv_btr21, gv_btr22, gv_btr24, gv_btr23, gv_btr26, gv_btr30 )

where erdat in s_pper.

Former Member — Thu, 01 Jun 2006 07:44:34 GMT

Hi Mohan,

You can use the SUM command in the select query ..

Just refer this link in SAP Library..

Also go through the program <b>demo_select_group_by</b>.

In that instead of MAX(carrid) , just type SUM(CARRID) and find out the results.

Hope you got me..

Regards,

SP.

Former Member — Thu, 01 Jun 2006 07:44:43 GMT

Hi,

select APP_SITES SITE_CON LAND_COST TOTAL_CIP TOTAL_EXCL RES_NEED

from zreserve

into ( gv_btr21, gv_btr22, gv_btr24, gv_btr23, gv_btr26, gv_btr30 )

where erdat in s_pper.

w_total = w_total + gv_btr21 + gv_btr22 ... + gv_btr30

endselect.

Or you can declare a internal table and then dump the data into the table and thnen loop at the table and do the sum.

Regards,

Ravi

Former Member — Thu, 01 Jun 2006 07:45:40 GMT

HI Mohan

You have to use Group By to obtain the sum for each fields seperately.

i.e seperate query for each fields.

regards

kishore

Bema — Thu, 01 Jun 2006 08:32:43 GMT

select sum( APP_SITES ) sum( SITE_CON ) sum( LAND_COST ) sum( TOTAL_CIP ) sum( TOTAL_EXCL ) sum( RES_NEED )

from zreserve

into (gv_btr21,gv_btr22,gv_btr24,gv_btr23, gv_btr26, gv_btr30)

where erdat in s_pper.