on 04-16-2009 2:10 PM
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
Have you checked MC+Q ??
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.