topic what's wrong PLS in Application Development and Automation Discussions

what's wrong PLS

Former Member — Thu, 22 Mar 2007 13:38:30 GMT

SELECT SUM( mseg_{menge ) sum( mseg}dmbtr )

INTO (<out>-z101 , <out>-zbuy_clac )

FROM ( mseg

INNER JOIN mkpf

ON mkpf_{mblnr = mseg}mblnr

AND mkpf_{mjahr = mseg}mjahr )

WHERE mseg~matnr = <out>-matnr

AND mseg~werks = '1000'

AND mseg~bwart IN ('101','123','162')

AND mkpf~budat BETWEEN zdate AND zdate1.

Re: what's wrong PLS

Former Member — Thu, 22 Mar 2007 13:47:30 GMT

Hi,

SELECT mseg_{mblnr mseg}zeile mseg_{menge mseg}dmbtr

INTO table ITAB FROM ( mseg

INNER JOIN mkpf

ON mkpf_{mblnr = mseg}mblnr

AND mkpf_{mjahr = mseg}mjahr )

for all entries in <out>

WHERE mseg~matnr = <out>-matnr

AND mseg~werks = '1000'

AND mseg~bwart IN ('101','123','162')

AND mkpf~budat BETWEEN zdate AND zdate1.

sort ITAB by mblnr zeile,

loop at ITAB.

at end of <field>

do sum of qty and amount.

endat

endloop.

regards,

Anji

Message was edited by:

Anji Reddy Vangala

Re: what's wrong PLS

rahulnavandar — Thu, 22 Mar 2007 14:49:13 GMT

In above loop statement u can use collect statement also