From which table can I display PGI (material and quantity)for a spesific cu

[Former Member]

Dear gurus,

From which table can I display PGI (material and quantity)for a spesific customer order?

Thanks in advance

[Former Member · Accepted solution]

HI

PGI and material quantity can be available in MSEG table

for this enter the sales order number in KDAUF or* MAT_KDAUF* fields in MSEG table

Also try with LIPS delivery item table and LIKP table

regards

SAP SD

Edited by: sapkpit_sd on Jul 22, 2010 8:14 AM

[samjalees2000]

First of all pgi is a material document which means it does not have a dedicated table such as for sales order and delivery.But here are its details

MKPF is the header of pgi documnet.

MSEG is the item level detail of pgi document

LIKP is connected with MKPF Table from refrence field

[Former Member]

Hi,

There are various tables that you can look at.

a. LIPS - Delivery item table which will give you the pgi quantity. You can use the precedig document number in LIPS to get the relevant delivery number and item number and also the PGI quantity.

b. VBFA - For a particular sales order put in 'Preceding Document' number will give you the PGI quantity

Hope this helps

Thanks

Mukund S