what's wrong PLS

[Former Member]

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.

[Former Member]

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

[rahulnavandar]

In above loop statement u can use collect statement also