topic Re: check select syntax in Application Development and Automation Discussions

check select syntax

Former Member — Sat, 14 Apr 2007 04:21:46 GMT

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.

Re: check select syntax

Former Member — Sat, 14 Apr 2007 04:27:36 GMT

HI..,

there is no problem in your syntax!!

what is your problem with that ??

regards,

sai ramesh

Re: check select syntax

Former Member — Sat, 14 Apr 2007 04:29:25 GMT

Hi,

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

Thanks,

Naren

Re: check select syntax

Former Member — Sat, 14 Apr 2007 04:41:19 GMT

Hi,

I cant find any prob with that select stmt

Re: check select syntax

Former Member — Sat, 14 Apr 2007 04:51:13 GMT

hi naren,

both for all entries and aggregate cannot be together?

can have example?

thanks

points already given

Re: check select syntax

Former Member — Sat, 14 Apr 2007 05:12:40 GMT

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