topic Re: select sum in Application Development and Automation Discussions

select sum

Former Member — Tue, 04 Jul 2006 11:23:46 GMT

what is wrong

select single sum( mzubb )

sum( wzubb )

into (z_mzubb , z_wzubb )

from s033

where werks = <ls_mard>-werks

and lgort = <ls_mard>-lgort

and matnr = <ls_mard>-matnr

Re: select sum

Former Member — Tue, 04 Jul 2006 11:25:14 GMT

Remove the keyword SINGLE from the select statement.

-Kiran

Re: select sum

Former Member — Tue, 04 Jul 2006 11:26:37 GMT

Hi Rani,

Use GROUP BY statement for the fields which you will use claues.

select single sum( mzubb )

sum( wzubb )

into (z_mzubb , z_wzubb )

from s033

where werks = <ls_mard>-werks

and lgort = <ls_mard>-lgort

and matnr = <ls_mard>-matnr

<b>GROUP BY MZUBB WZUBB.</b>

Thanks,

Vinay

Re: select sum

Former Member — Tue, 04 Jul 2006 11:28:58 GMT

Hello Rani,

Add order by mzubb or group by mzubb.

and also check the field symbols are having values and the select stmt.

It is useful for u rewardthe points

Regards,

Vasanth