topic Need help in Application Development and Automation Discussions

Need help

Former Member — Tue, 26 Jun 2007 14:42:20 GMT

Hi all,

from below I want calculate the sum of quantity(lfimg).

REPORT YYEXAMPLE1 .

parameters : p_matnr like lips-matnr,

p_werks like lips-werks,

p_lgort like lips-lgort.

data : begin of it_lips occurs 0,

vbeln like lips-vbeln,

lfimg like lips-lfimg,

end of it_lips.

select vbeln lfimg into table it_lips

from lips

where matnr = p_matnr

and werks = p_werks

and lgort = p_lgort.

Loop at it_lips.

write:/ it_lips-vbeln , it_lips-lfimg.

endloop.

regards,

Ajay Ram

Re: Need help

Former Member — Tue, 26 Jun 2007 14:51:19 GMT

Hi Ajay,

REPORT YYEXAMPLE1 .


parameters : p_matnr like lips-matnr,
p_werks like lips-werks,
p_lgort like lips-lgort.

data : begin of it_lips occurs 0,
vbeln like lips-vbeln,
lfimg like lips-lfimg,
end of it_lips.

data : total type i.

select vbeln lfimg into table it_lips
from lips
where matnr = p_matnr
and werks = p_werks
and lgort = p_lgort.


Loop at it_lips.
total  = total + it_lips-lfimg 
write:/ it_lips-vbeln , total.
endloop.

Reward if useful

Regards

Aneesh.

Re: Need help

Former Member — Tue, 26 Jun 2007 14:51:31 GMT

i got the solution.

rgads,Ajay ram

Re: Need help

Former Member — Tue, 26 Jun 2007 14:52:20 GMT

Hi,

Please try this ...


...

select vbeln sum( lfimg ) into table it_lips
from lips
where matnr = p_matnr
and werks = p_werks
and lgort = p_lgort.

loop at it_lips.
  write:/ it_lips-vbeln , it_lips-lfimg.
endloop.

Regards,

Ferry Lianto