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

567082836
567082836 used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
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
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
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Author

Commented:
I meant InfoSet
Commented:
Maybe use BAPIs
BAPI_SALESORDER_GETLIST
BAPI_SALESORDER_GETSTATUS
BAPI_BILLINGDOC_GETDETAIL
Mike McCrackenSenior Consultant
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial