Sales order status

[Former Member]

Hi,

I want to display sales order status For the below input:

I/P

Order type

Status

Creation From Date

Creation To date

And also With in this below ip any one will come

Customer Po no

order no

Material

Po type

order ship

Op

order status

Order type

Order Number

Created Date

PO type

Customer Po Number

Please guide me, in which table i have to pass this value to get the o/p values or is ther any standard fuctional module for this.

Edited by: sentchan on Apr 8, 2010 5:37 AM

[GauthamV]

You can use VBAK,VBAP with VBUK,VBUP tables to get order status according to your requirement.

[Former Member]

Use VBAK & VBUK for Header status, VBAP & VBUP for Item Status

Or you can use the function Module "RV_DOCUMENT_STATUS". Pass Order Number, Line Item Number (pass 000000 as line item number for Header status) in the structure

Regards

Vinod

Edited by: Vinod Kumar on Apr 8, 2010 9:52 AM

[Former Member]

Thanks,

But in this table order status value is not there. How to get order status.

[Former Member]

VBUK-GBSTK Stores the overall status of the order. ' ' - Not relevant, 'A' - Not yet processed, 'B' - Partially processed , 'C' - Completely Processed.

If you are looking the status based on Object status, then use the function module "STATUS_SHOW_CHANGE_DOCUMENTS"

Regards

Vinod

Edited by: Vinod Kumar on Apr 8, 2010 1:47 PM

[Former Member]

Many thanks,

In which table drop ship details will store, How to get that value based on vbeln.

[Former Member]

I didn't understand, what is drop ship details ?

Regards

Vinod

[Former Member]

Drop ship means direct shipment and its one of the item catagory.