topic Select statment Query in Application Development and Automation Discussions

Select statment Query

Former Member — Tue, 13 Oct 2009 14:49:39 GMT

Hi,

I am devloping Query with the table DBERCHZ1

it having two fields

V_ ABRMENGE value 456

N_ ABRMENGE value 0.67899

Here i want to print as 456.67899 with one select statment.

is any way to sum in select statment.

Thanks

Re: Select statment Query

Former Member — Tue, 13 Oct 2009 14:53:04 GMT

My select statment as

select e_{belnr, h}tariftyp, c_{sparte, c}vertrag, c_{vkont, m}belzart, c_{begabrpe, c}endabrpe, sum (m_{v_abrmenge, m}n_abrmenge), e~budat

from erchc as e

join dberchz1 as m

on e_{belnr = m}belnr

join erch as c

on m_{belnr = c}belnr

join ever as r

on c_{vertrag = r}vertrag

join eanlh as h

on h_{anlage = r}anlage

where h~tariftyp in @p1@

and c~erchc_v = 'X'

and c~simulation = space

and c~tobreleasd = space

and e~budat in @p2@

and e~simulated = space

and e~tobreleasd = space

and m~belzart in @p3@

and m~belnr in @p4@

Re: Select statment Query

Former Member — Tue, 13 Oct 2009 14:53:29 GMT

its getting syntax error

Re: Select statment Query

Former Member — Tue, 13 Oct 2009 15:03:23 GMT

Hi,

I have just given a code snippet similar to your requirement.

DATA: average TYPE p DECIMALS 2,

sum TYPE p DECIMALS 2.

SELECT AVG( luggweight ) SUM( luggweight )

INTO (average, sum)

FROM sbook.

WRITE: / 'Average:', average,

/ 'Sum :', sum.

Just replace with your variables and let me know if it works.

Thanks,

Harini

Re: Select statment Query

Former Member — Tue, 13 Oct 2009 15:31:19 GMT

in select statment sum two fields and show as one field

select x y x from table

here i want to sum y z

Thanks

Re: Select statment Query

Former Member — Tue, 13 Oct 2009 15:35:47 GMT

You may be able to do this with native SQL, but I don't see how it can be done in open SQL.

Rob