We help IT Professionals succeed at work.

SAP Table/Field Status of a Sales Order: What is status of order (line item): Released, Held, & Billed/Invoiced, etc.

567082836
567082836 asked
on
1,178 Views
Last Modified: 2015-01-29
SAP - Want to create a report to track orders: want to know what the status of the line item in the order process.  Is it held, released, billed etc... ?

I am using the following table to find what I am looking for: VBUK & VBUP:  
1) released order
2) held order
3) billed/invoiced order

I want to use the status codes in VBUK &/or VBUP to determine where this sales order is in the process?

If I am using the wrong table please let me know..

Thank you.
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Which reporting tool are you using?

Which SAP tool for the database?

mlmcc

Author

Commented:
Infoview.

I've been looking for the information in VBUK / VBUP.  There are status codes in there but I need the exact status codes for the processes: held, release, invoiced/billed, etc.. then from there I can create an accurate report.  I believe I need to know based on line item.. so VBUP.  

But also maybe there is another table?
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Infoview is a portal not a reporting or database query tool.

I don't know the database but there is most likely a table that is linked to VBUP that has the verbiage for the status codes.  To find it you need to look at a database structure diagram that shows how tables are joined.

mlmcc

Author

Commented:
I meant InfoSet
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Could be.  I don't know that tool or the database.

mlmcc

Author

Commented:
Thanks!  Will look into it.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.