topic Re: Sum fields in a sql query in Application Development and Automation Discussions

Sum fields in a sql query

roberto_falk — Tue, 19 Dec 2006 17:02:33 GMT

Hi,

somebody knows how to sum two columns of a table as a result of an abap sql query. I know that is possible to do it in a native sql like


select f.seatmax max, f.seatfree free, f.seatmax - f.seatfree seatoccu from flights

Tks

Roberto Falk

Re: Sum fields in a sql query

Former Member — Wed, 20 Dec 2006 03:21:26 GMT

Hi Roberto,

You can not do this in Open sql.

Re: Sum fields in a sql query

Former Member — Wed, 20 Dec 2006 03:30:01 GMT

Hi Roberto ,

Here is a sample code which does some thing similar

Data : v_LABST type LABST ,
       v_umlme type umlme.

start-of-selection.

       select sum( labst ) sum( umlme )
         into (v_labst , v_umlme)
         from mard.

write:/ v_labst , v_umlme.

Regards

Arun

Re: Sum fields in a sql query

jayanthi_jayaraman — Wed, 20 Dec 2006 03:37:55 GMT

Hi,

It's not possible.

But alternatively,you need to write select statement fro the two fields (sa y A and B) and then loop the internal table to get (A + B).

Re: Sum fields in a sql query

roberto_falk — Wed, 20 Dec 2006 11:10:36 GMT

This is the problem... I don't want to interate the internal table after the select.

Tks all.

Roberto

Re: Sum fields in a sql query

jayanthi_jayaraman — Wed, 20 Dec 2006 11:17:09 GMT

Hi,

select sum( A ) from db into v1.

select sum( B ) from db into v2.

v = v1 + v2.

write v.

Message was edited by:

Jayanthi Jayaraman

Re: Sum fields in a sql query

roberto_falk — Wed, 20 Dec 2006 11:23:05 GMT

No, this is not my idea.... I wanna the sum of each column... not the total sum of the table...


select a, b, a+b from dual

Tks

Roberto Falk

Re: Sum fields in a sql query

jayanthi_jayaraman — Wed, 20 Dec 2006 11:29:46 GMT

Hi,

select A B from db into corresponding fields of wa.

wa-c = a + b.

append wa to itab.

endselect.

I don't think there is some way other than iteration.