topic Re: report help in Application Development and Automation Discussions

report help

Former Member — Fri, 03 Mar 2006 08:03:36 GMT

hello everybody.

I need help regarding one of my report for delivery.

in selection screen i have ranges for

1.date of delivery

2.delivery no

3.customer no

result what i am getting

MERCHANDISE CATEGORY 002

M-01 STORE CODE 3 STOCK NET VALUE

M-01 STORE CODE 5 STOCK NET VALUE

M-01 STORE CODE STOCK NET VALUE

here in out put i need not required to repeat this material no again and again rather i need to add the quantity that comes against a particular material no.

i cannot use collect since collect can be used only with key fields

that tables i am refering are likp and lips.

thanks in advance.

Re: report help

Former Member — Fri, 03 Mar 2006 08:12:40 GMT

use query ike this ...

select matnr sum(menge) from dbtab into itab

where cond...

group by matnr.

append itab.

endselect.

Message was edited by: kishan negi

Re: report help

Former Member — Fri, 03 Mar 2006 08:14:47 GMT

Hi,

SORT itab BY matnr.
LOOP AT itab INTO wa.
MOVE wa TO wa2.
AT NEW matnr.
 APPEND wa2 TO itab2.
 CONTINUE.
ENDAT.
LOOP AT itab2 WHERE matnr = wa-matnr.
itab2-quantity = itab2-quantity + itab-quantity.
MODIFY itab2 TRANSPORTING quantity.
ENDLOOP.
ENDLOOP.

Regards,

Wenceslaus.

Re: report help

hymavathi_oruganti — Fri, 03 Mar 2006 08:18:21 GMT

loop at itab.

AT NEW MATNR.

SUM. (THIS STATEMENTS SUMS THE NUMERIC)

ENDAT.

ENDLOOP.

Re: report help

Former Member — Fri, 03 Mar 2006 08:26:15 GMT

Hi,

In your select querry,

take SUM(QTY)and use GROUP BY clause for MATNR .

Hope this helps.

Regards,

Shashank