problem in grid report

Former Member — Sat, 02 Jul 2011 07:30:41 GMT

i developed one report with alv grid display in that my problem is to my purchase order i have three items .

so when i am displaying output it showing sum of ( total goods receipt,gr amount,invoice amount) for that pr, but i have to display individually item wise.

once see my output...

PRNO VENDOR ITEM MATERIAL PO QTY UNIT- PO TOTAL GR RECIPT GR AMOUNT INVOICE AMOUNT

PRICE VALUE

4500000115 GANESH 10 MRP99999 10.000 10.00 100.00 10.000 100.00 100.00

4500000116 GANESH 10 MRP99999 10.000 10.00 100.00 6.000 60.00 0.00

4500000116 GANESH 20 MRP99999 25.000 10.00 250.00 0.000 0.00 0.00

4500000117 GANESH 10 MRP99999 50.000 10.00 500.00 75.000 750.00 450.00

4500000117 GANESH 20 MRP99999 15.000 10.00 150.00 0.000 0.00 0.00

4500000117 GANESH 30 MRP99999 10.000 10.00 100.00 0.000 0.00 0.00

Thanks in advance

Moderator message: please post only relevant code parts, your post must be less than 5000 characters to preserve formatting.

Edited by: Thomas Zloch on Jul 2, 2011 7:28 PM

Re: problem in grid report

Kiran_Valluru — Sat, 02 Jul 2011 09:11:07 GMT

Hi.,

I am not able to read your code., If you want Item Wise Sum., use sort and at end of events.

sort itab by itemno.

loop at itab into wa.

move-corresponding wa to wa_fin.

sum = sum + amount.

append wa_fin to itab_fin.

at end of itemno.

wa_fin-sum = sum.

append wa_fin to itab_fin.

endat.

endloop.

hope this helps u.,

Thanks & Regards,

Kiran

Re: problem in grid report

Former Member — Tue, 12 Jul 2011 04:22:57 GMT

problem is solved

topic problem in grid report in Application Development and Automation Discussions

problem in grid report

Re: problem in grid report

Re: problem in grid report