topic Re: Aggregate Function in Application Development and Automation Discussions

Aggregate Function

Former Member — Fri, 04 Apr 2008 09:56:54 GMT

I want to sum up 3 different fields from a table using aggregate function "sum". But in a single select stmt.

e.g In table PLPO i want to sum up 3 different quantity fields i.e.

vgw01 vgw02 vgw03 in a single select stmt and not 3 select stmts.

e.g.

for summing up one column.......................

select sum( vgw01 ) from plpo

into corresponding fields of table t_assem_cal

where plnnr = itab-plnnr.

can i sum up all above column in one select stmt.

Former Member — Fri, 04 Apr 2008 10:05:48 GMT

Hi,

Please use COLLECT STATMENT will achive ur requirement...

Regards,

Sreenivasa sarma k.

Former Member — Fri, 04 Apr 2008 11:09:30 GMT

Try this code ho[pe it will help.....

select sum( vgw01 )

sum( vgw02 )

sum( vgw03 )

plnnr

into corresponding fields of table t_assem_cal

from plpo

where plnnr = itab-plnnr

group by plnnr.

Reward if helpful

-Sudhanshu

Former Member — Fri, 04 Apr 2008 11:20:00 GMT

Thank you so much.