topic Re: cumulative quantity for a material in Application Development and Automation Discussions

cumulative quantity for a material

Former Member — Mon, 04 May 2009 09:36:58 GMT

I am developing a report in which I have to calculate the cumulative quantity for a material purchased during particular period entered in the selection criterion and also for the month during that period.Both should be diplayed in the separate columns.The cumulative quantity for that period should be displayed in the last row for that material. And I am using ALV for the display.Please assist me.

Re: cumulative quantity for a material

Former Member — Mon, 04 May 2009 11:17:45 GMT

Hi,

Consider the internal table with the fields material, then date on which it is purchased. Now while processing the internal table, using the collect statement you can cumulate the quantity.

But for this all the records should have the same values with quantities in it.

i.e. Lets say for internal table will be having the rows with MATERIAL PERIOD (lets say we have picked only the month from the date purchased, So in this period, all the entries will have MONTH value unique) and then QUANTITY.

Now if you use collect, automatically for all the records with same MATERIAL and PERIOD combination, it will cumulate the quantity.

Regards,

Santhosh.

Re: cumulative quantity for a material

Former Member — Mon, 04 May 2009 11:31:47 GMT

Hi Venu,

You can ask specific question where u are facing problem

You can not expect ppl to post complete solution according to your specification.

If you want a person to do so you must serch for a freelancer.

Regards

Bikas