‎2011 Jul 02 8:30 AM
hi
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
<removed by moderator>
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
‎2011 Jul 02 10:11 AM
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
‎2011 Jul 02 10:11 AM
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
‎2011 Jul 12 5:22 AM