• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • Last Modified:

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.
0
567082836
Asked:
567082836
  • 3
  • 3
1 Solution
 
mlmccCommented:
Which reporting tool are you using?

Which SAP tool for the database?

mlmcc
0
 
567082836Author 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?
0
 
mlmccCommented:
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
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
567082836Author Commented:
I meant InfoSet
0
 
BuckaCommented:
Maybe use BAPIs
BAPI_SALESORDER_GETLIST
BAPI_SALESORDER_GETSTATUS
BAPI_BILLINGDOC_GETDETAIL
0
 
mlmccCommented:
Could be.  I don't know that tool or the database.

mlmcc
0
 
567082836Author Commented:
Thanks!  Will look into it.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now