Material query

[Former Member]

Hello,

I have a question about a query which I want to create. Besides other information I would like like to see

the number of goods of a particular material that have been issued during a given period. For this information I use table S031. However this tabel gives a new line for every period (month). Therefore the result of the query are many lines.

In the selection screen I would like enter a periode (for example 01.01.2009 - 31.03.2009) and then I would like to see the total amount of goods that have been issued during that period in one line. Do I need some special code in my query or are there other tables which I have to use?

Thanks in advance,

Ivo

[Lakshmipathi]

Have you checked MC+Q ??

thanks

G. Lakshmipathi

[Former Member]

Do the following....Sort the the column for date in ascending order... Total the Qty column.. Subtotal the column for date again...

The result will be as u have expected...

karthick