Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

problem in grid report

Former Member
0 Likes
471

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

1 ACCEPTED SOLUTION
Read only

Kiran_Valluru
Active Contributor
0 Likes
438

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

2 REPLIES 2
Read only

Kiran_Valluru
Active Contributor
0 Likes
439

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

Read only

Former Member
0 Likes
438

problem is solved