asked on

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

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.

Mike McCracken

Which reporting tool are you using?

Which SAP tool for the database?

mlmcc

567082836

ASKER

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 McCracken

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

567082836

ASKER

I meant InfoSet

ASKER CERTIFIED SOLUTION

Bucka

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike McCracken

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

mlmcc

567082836

ASKER

Thanks! Will look into it.

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

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