Sum fields in a sql query

[roberto_falk]

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

[Former Member]

Hi Roberto,

You can not do this in Open sql.

[Former Member]

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

[jayanthi_jayaraman]

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).

[roberto_falk]

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

Tks all.

Roberto

[jayanthi_jayaraman]

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

[roberto_falk]

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

like

select a, b, a+b from dual

Tks

Roberto Falk

[jayanthi_jayaraman]

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.