on 04-01-2011 4:31 PM
Hi SD Gurus,
I have a very strange query from client. I have to count the number of sales order created in a month for a z report. For example 30 in Jan, 25 in Feb etc. Could anyone suggest me How to count number of sales orders generated in a month in SAP SD.
Regards
Vinod Kumar
Hi,
Goto the T.Code "SE16" or "SE16n" or "SE11".
Enter the table name as VBAK
Enter the created on date as the starting date of the period and to date as the end date.
Enter.
Click on "Number of Entries".It will tell you the number of entries created in a particular period.
If you want a report,goto the T.Code "VA05n".
Regards,
Krishna.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vinod,
I am not sure if you can give authorization to client for SE16n. As far as I know it is not advisable to give authorization to client for that T.Code.
As suggested by Krishna, you can perhaps give VA05n report to the client and ask them to give from and to date. Then ask them to download it to excel and take a sum there. That is the only simple way I can think of.
It worked for me. I was asked the same question and I have proposed this solutoin which was accepted by the client.
Regards,
Rohan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Go to SE16, input VBAK table and execute. Maintain "Created on" date and on top, you can see a tab "Number of Entries". Click this so that system will show the number of sale orders created during that given period.
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.
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.