on 01-23-2008 11:23 PM
Hi all
I am new to this role.
How can I know whether the Sales order is OPEN or CLOSED.
Which table has that information? Also what is the field name?
Actually i need to develop a report on that.
Please reply asap
Thanks
Sonali
Edited by: sonali on Jan 24, 2008 12:23 AM
Hi,
Tables VBUK and VBUP will have the status information.
Kind Regards
Chakradhar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Sonlai,
Go to VA03 give sales order no and click on document flow or press shift+F5, you will get to knwo the status of your Sales document
Vishal
vishal27580@gmail.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
goto your sales order (ex. run VA03)
goto Header -TAB Status
check this data for 2 different orders - one without delivery (should be OPEN) and another one with delivery (check with billing doc as well - COMPLETED)
run se11 and check VBUK, VBUP for your order
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please create 4 sales orders:
first - only sales order
second - order+delivery
third - orderdeliverGI
fourth - orderdeliverGI+billing doc
then goto to VBUK and check records for those 4 orders.
find the difference - field GBSTK for example (A for Open C for COMPLETED)
run VA03 for each order and check Document Flow (hit F5) - you will see which doc is OPEN, which COMPLETED (Overall process status)
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
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.