Two Quantities summation for different Document Number related to Material

[Former Member]

Hi,

I have a material number for which there are 20 document numbers. For those 20 document numbers there are two different quantities .

Eg:

Material Qty1 Qty2 Doc No.

100000 5 6 097876

4 6 097547

9 9 999999

etc

In the report, we have a requirement to display the material and quantities with showing diff document numbers and has to sum up all the quantities related to material and the output should look like following:

Material Qty1 Qty2

100000 18 21

How do I go about doing this???

[Former Member · Accepted solution]

Hi Ganesh,

What i understand is that...If the material number is same but it has different document no.'s. And if u have to create Query like as below:

Material Qty1 Qty2

100000 18 21

Then where are u getting the problem, coz if u have to show only the material number and quantity's and if ur not drilling the information by document number it will automatically sum-up the qty for same material code, isn't it ??

Correct me if i have understood u wrong .

Thanks

Dipika

[Former Member · Accepted solution]

Hi,

You have understood my question correctly.

But I was just wondering that if I dont include the doc no. then it would display the quatities separately or sum up everything.

However, you hhave answered my question...would get back incase I have any issues reg this.

Assigning you points...