Skip to Content
0
Former Member
Apr 14, 2007 at 04:21 AM

check select syntax

18 Views

hi,

may i know if the syntax is correct.

thanks

select avbeln aposnr amatnr sum( akwmeng ) sum( b~rfmng )

into corresponding fields of table it_qty

from vbap as a inner join vbfa as b

on avbeln = bvbelv and

aposnr = bposnv and

b~vbtyp_n = 'J'

for all entries in it_delivery

where a~vbeln = it_delivery-vgbel

group by avbeln aposnr a~matnr

order by avbeln aposnr a~matnr.