table and field name to find the PGI status of the Sales Order

[Former Member]

Hi All,

Can anyone post the table and field name to find the PGI status (Completed / Not Completed) for the Sales Orders...

Thanks in advance

Muthu

[Former Member · Accepted solution]

HI

U can find in delivery Table---LIPS and LIKP

These two are delivery related tables...

U can in se11 or se38...

Regards

Srinivas..

[Former Member]

Muthu,

Remember that one sales order item can be delivered using multiple deliveries and multiple sales orders can be delivered in a single delivery. Here's something that you can try:

Select VBELN and POSNN from VBFA where VBELV='Sales Order#' and POSNV='Sales Order Item #" and VBTYP_N='J'

This will give you all the delivery numbers and the delivery item numbers for the sales order item. This can be multiple records or a single record. For each of these delivery numbers and items

Select WBSTA from VBUP where VBELN='Delivery#' and POSNR='Del Item#'

WBSTA can have 4 values

blank: Not Relevant for Delivery

A: Not yet processed

B: Partially Processed

C: Completely Processed

If WBSTA='C' then your sales order item is PGI'ed

Regards,

Chandan

[Former Member]

Hi

Use the follwoing tcode agsint delviery no for PGI status.

>Tcode LIKPUK

>Tcode VBAKUK for sales ordre status.

Thx

Edited by: DWARKESH THAKKAR on Oct 13, 2008 1:33 PM

[Former Member]

Hi Muthupandiyan,

You can get this details in Table VBUK in field WBSTK. This table is used for "Sales Document: Header Status and Administrative Data".

Regards,

Naveed Ansari.