select sum

[Former Member]

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

[Former Member]

Remove the keyword SINGLE from the select statement.

-Kiran

[Former Member]

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

[Former Member]

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