topic Re: syntax error saying SELECT SUM is unidentified, in Application Development and Automation Discussions

syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 07:36:32 GMT

Hii guyz...

Need lill help ..got some prob with the codes below..

LOOP AT i_delivery INTO w_delivery.

SELECT SINGLE knumv FROM vbak

INTO (w_delivery-knumv)

WHERE vbeln = w_delivery-vgbel.

MODIFY i_delivery FROM w_delivery.

ENDLOOP.

IF i_delivery[] IS NOT INITIAL.

REFRESH i_konv.

--->> SELECT knumv SUM ( kbetr ) INTO TABLE i_konv FROM konv

FOR ALL ENTRIES IN i_delivery

WHERE knumv = w_delivery-knumv

AND kposn = w_delivery-vgpos

AND kschl = c_condtype4.

GROUP BY knumv.

ENDIF.

In the 2nd SELECT statment , it gives a syntax error saying SUM is unidentified,

its the SUM as col , i dont know ..

the same code i hv written in other programs ,thats workin fine ..

please help

thanks ...Jahan

Re: syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 07:37:36 GMT

HI,

y cannt u move that sum(...) to some variable and specify the same here.

Re: syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 07:38:41 GMT

Hi Jahan,

SQL Statement syntax should look like this and it wored fine for me.

SELECT SUM( ANTPROZ ) INTO LV_PER1 from table.

Hope that helps.

Regards

Kapadia

Re: syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 07:38:49 GMT

Remove gaps after sum

SELECT knumv SUM( kbetr ) INTO TABLE i_konv FROM konv

FOR ALL ENTRIES IN i_delivery

WHERE knumv = w_delivery-knumv

AND kposn = w_delivery-vgpos

AND kschl = c_condtype4.

GROUP BY knumv.

Re: syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 07:40:09 GMT

You must select SUM only in variables.

And then apeend to your table.

Why do you need add sum into table?

Re: syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 07:54:56 GMT

Example to find the number of passengers, the total luggage weight, and the average weight of the luggage for all Lufthansa flights on 02/28/2001:

DATA: count TYPE I, sum TYPE P DECIMALS 2, avg TYPE F,

connid LIKE sbook-connid.

SELECT connid COUNT( * ) SUM( luggweight ) AVG( luggweight )

INTO (connid, count, sum, avg)

FROM sbook

WHERE

carrid = 'LH ' AND

fldate = '20010228'

GROUP BY connid.

WRITE: / connid, count, sum, avg.

ENDSELECT.

I think this code snipet will help

Regards,

Harsha

*Reward points if helpful...

Re: syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 08:19:17 GMT

Hey guyz look here ...

if i write code like this ..down here ..

*// Get VBELN from VBRP

CLEAR : l_knumv, l_vbeln.

SELECT SINGLE vbeln

INTO (l_vbeln)

FROM vbrp

WHERE vgbel = w_delivery-vbeln

AND vgpos = w_delivery-posnr.

IF sy-subrc = 0.
IF l_vbeln IS NOT INITIAL.

*// Get KNUMV from BVRK

CLEAR :a_knumv.

SELECT SINGLE knumv

INTO (a_knumv)

FROM vbrk

WHERE vbeln = l_vbeln.

w_delivery-knumv = a_knumv.

IF sy-subrc = 0.

SELECT SUM( kbetr ) FROM konv INTO w_delivery-frval

WHERE knumv = w_delivery-knumv

AND kposn = w_delivery-vgpos

AND kschl = c_condtype4.

IF sy-subrc = 0.

w_delivery-frval = l_kbetr.

pfrval = w_delivery-frval.

ENDIF.

ELSE.

See here i m putting the SUM into a variable ,

n i hv deletd the space in betwn ..

now it says ..SUM is not supported for fields of pooled or cluster table

where as my KONV is transprnt table ..

pleeeeZZ help ...

my A** is on the line ...

thnx..

jahan

Re: syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 08:23:49 GMT

Hi ,

here again u r using sum as:

SELECT SUM( kbetr ) FROM konv INTO w_delivery-frval

so try to move into some variable and try

Re: syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 08:24:36 GMT

KONV is indeed a cluster table. NOt a transparent table.

Re: syntax error saying SELECT SUM is unidentified,

Former Member — Thu, 01 Mar 2007 08:41:56 GMT

ohh ...yaa thanx ...

yes sir KONV is clustr table..

thank u very much Ravi..