on 01-30-2008 11:56 PM
Dear All
How can I retrieve the OPEN Sales Order from the System? I mean from the SAP Database Tables.
I knew there is one Table VBUK which helps me.
The corresponding field is GBSTK.
But in this VBUK table for GBSTK field I can see 4 entries.
NOT RELEVANT
NOT YET PROCESSED
PARTIALLY PROCESSED
COMPLETELY PROCESSED
What Should I Pick for retrieving OPEN sales orders and also let me know whether my approach is correct or not.
Please respond.
Thanks
Sonali.
Take only "NOT YET PROCESSED and PARTIALLY PROCESSED" but one tcode VA05 which is also used to see list of open orders but only for a single customer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi sonali,
not sure if i understood your question, i see two things in it.
1) A sales order can be open without reference to GBSTK( goods movement). As long as there is a delivery for the sales order its complete whatever might be the status of GBSTK.
2) But if you want to find out whether goods movement has been completely done or not ie GBSTK status then you can check all orders where the VBUK_GBSTK status is not equal to C- completely processed.
regards,
Sadhu Kishore
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
VBUK is the status table for all the sales related documents include order, delivery , and invoice
if you want to take only sales order ( VBAK)
then create a SQVI or ABAP query
linking the VBAK and VBUK table
if you want only open the you can select not equal C status
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To get open orders, use both 'A' and 'B'
By this way, you wont list 'rejected' orders in the list.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
if VBUK-GBSTK is A (Not yet processed) - order has status "OPEN"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
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.