topic Re: select Query addition subraction in Application Development and Automation Discussions

select Query addition subraction

Former Member — Wed, 02 Sep 2009 12:21:56 GMT

hi all ...

Fetch total invoice cost as VBRK-NETWR+VBRK-MWSBK ..

now can i write it one select select querry ??

select ( netwr + mwsbk ) as abc from vbrk . ??

can this be done??

please help ..

former_member404244 — Wed, 02 Sep 2009 12:27:47 GMT

Hi,

This is not possible....Get the data into an internal table and then loop it and modify the record..

Regards,

Nagaraj

Former Member — Wed, 02 Sep 2009 12:27:50 GMT

hi,

you can try this way..


select sum(netwr) sum(mwsbk) from vbrk into ( w_netwr , w_mwsbk)
where <condition>.
if sy-subrc = 0.
w_total = w_netwr + w_mwsbk.
endif.

regards,

Prabhudas

Former Member — Wed, 02 Sep 2009 12:29:40 GMT

Hi,

Thats not possible in a single select statement in ABAP. You cannot sum multiple fields of the same table in a single select query.

Only this is possible.


SELECT SUM ( netwr ) SUM (mwsbk ) 
into ( v_netwr, v_mwsbk )
from vbrk.

Regards,

Vikranth

Former Member — Wed, 02 Sep 2009 12:32:41 GMT

thanks all!!