topic Re: Problem in sum a field through select command in Application Development and Automation Discussions

Problem in sum a field through select command

Former Member — Fri, 17 Aug 2007 12:12:04 GMT

Dear Sir(s),

I want to sum kbetr (no. of packing) for same knumv(invoice no.) in table konv.

e.g.

invoice no. no. of packing

(knumv) (kbetr)

001 2

001 3

002 4

002 5

result should be -

invoice no no. of packing

001 5

002 9

code-

select knumv kschl sum(distinct kbetr)

from konv

into table it_konv

for all entries in it_vbrk

where kschl = 'ZFQT'

and knumv = it_vbrk-knumv

group by knumv kbetr.

error showing - unkown col. sum(distinct field list.

Please help me immediately.

thanks,

R.Kapoor

Re: Problem in sum a field through select command

FredericGirod — Fri, 17 Aug 2007 12:16:49 GMT

select knumv sum( kbetr )

into table it_konv

from ...

group by knumv.

Re: Problem in sum a field through select command

Former Member — Fri, 17 Aug 2007 12:16:51 GMT

u can use at end of statement inside loop statement

loop at it.

write:/ it-field1,it-field2,

at end of kumnv

sum.

endat.

endloop.

reward points if this is useful

Re: Problem in sum a field through select command

varma_narayana — Fri, 17 Aug 2007 12:16:58 GMT

Hi..

Change ur Select statement as below .

select knumv sum(kbetr)

from konv

into table it_konv

for all entries in it_vbrk

where kschl = 'ZFQT'

and knumv = it_vbrk-knumv

group by knumv .

Here you need not to Retrieve the Field KSCHL since it is anyway given in the WHERE clause.

Let me know incase of any other issue.

Reward if Helpful.

Re: Problem in sum a field through select command

Former Member — Fri, 17 Aug 2007 12:18:05 GMT

Hi,

try this

select knumv kschl

from konv

into table it_konv

for all entries in it_vbrk

where kschl = 'ZFQT'

and knumv = it_vbrk-knumv

group by knumv kbetr.

sort it_know by knumv.

loop at it_knov.

at end of knumv.

sum.

write:/ it_knov-knumv, it_knov-kbetr.

endat.

endloop.

thanks & regards,

Venkatesh

Re: Problem in sum a field through select command

Former Member — Fri, 17 Aug 2007 12:18:45 GMT

u loop the internal table and then use

ON CHANGE OF in loop and do SUM.

Re: Problem in sum a field through select command

Former Member — Fri, 17 Aug 2007 12:22:45 GMT

data:

it_konv2 like table of it_konv with header line.

select knumv kschl kbetr

from konv

into table it_konv

for all entries in it_vbrk

where kschl = 'ZFQT'

and knumv = it_vbrk-knumv.

loop at it_konv.

it_konv2 = it_konv.

collect it_konv2.

endloop.

**So it_konv2 will have your desired data.

Reward points if useful.Get back in case of query...

Cheers!!!

Re: Problem in sum a field through select command

Former Member — Fri, 17 Aug 2007 12:26:31 GMT

Hi Rakesh,

Use collect statement.

Regards

Arun

Re: Problem in sum a field through select command

Former Member — Sat, 18 Aug 2007 09:41:01 GMT

Dear Sir,

Your solution is very helpful and now i overcome from the problem. hope in future also you will help me in solving problems.

thanks & regards,

Rakesh Kapoor

Re: Problem in sum a field through select command

Former Member — Sat, 18 Aug 2007 09:47:41 GMT

Dear Sir,

I am still facing problem in using sum agregate in select statement.

it showing error again, kindly check at your end and send by mail.

thanks & regards,

Rakesh Kapoor