check select syntax

[Former Member]

hi,

may i know if the syntax is correct.

thanks

select a_{vbeln a}posnr a_{matnr sum( a}kwmeng ) sum( b~rfmng )

into corresponding fields of table it_qty

from vbap as a inner join vbfa as b

on a_{vbeln = b}vbelv and

a_{posnr = b}posnv and

b~vbtyp_n = 'J'

for all entries in it_delivery

where a~vbeln = it_delivery-vgbel

group by a_{vbeln a}posnr a~matnr

order by a_{vbeln a}posnr a~matnr.

[Former Member]

HI..,

there is no problem in your syntax!!

what is your problem with that ??

regards,

sai ramesh

[Former Member]

Hi,

If you have FOR ALL ENTRIES.. you cannot have aggregate functions..other than COUNT(*)

Thanks,

Naren

[Former Member]

hi naren,

both for all entries and aggregate cannot be together?

can have example?

thanks

points already given

[Former Member]

Hi,

I cant find any prob with that select stmt

[Former Member]

hi ..

here the problem is with aggregate functions..

If the list in the SELECT clause (excepting aggregate expressions) contains one or more field names, the field names must also be listed in the GROUP BY clause. The aggregate functions do not then apply to all of the selected lines, but to the individual groups of lines.

use the<b> ORDER BY</b> Clause in the select query.

also see the following link.

http://help.sap.com/saphelp_nw04s/helpdata/en/f1/0a564ce09411d2acb90000e829fbfe/frameset.htm

Reward points if useful...

Suresh......