Purchase order...

[Former Member]

Hi All,

1, How to get Pending purchase order details?

2, TableName - FieldName for below fields

Purchasing organization ---

Purchasing Group ---

Purchasing Document Number ---

Purchasing Document Date ---

item delivery date ---

Thanks in advance

Raj

[Former Member]

Hi

2)

for all these fields refer to the table EKKO

EKORG EKORG CHAR 4 0 Purchasing Organization

EKGRP BKGRP CHAR 3 0 Purchasing Group

BUKRS BUKRS CHAR 4 0 Company Code

BSTYP EBSTYP CHAR 1 0 Purchasing Document Category

BSART ESART CHAR 4 0 Purchasing Document Type

STATU ESTAK CHAR 1 0 Status of Purchasing Document

Regards

Preeti

<b><i>

*Reward if useful</i></b>

[Former Member]

Hi

2)

for all these fields refer to the table EKKO

EKORG EKORG CHAR 4 0 Purchasing Organization

EKGRP BKGRP CHAR 3 0 Purchasing Group

BUKRS BUKRS CHAR 4 0 Company Code

BSTYP EBSTYP CHAR 1 0 Purchasing Document Category

BSART ESART CHAR 4 0 Purchasing Document Type

STATU ESTAK CHAR 1 0 Status of Purchasing Document

Regards

Preeti

<b><i>

*Reward if useful</i></b>

[Former Member]

Hi raj,

1) For pending purchase orders you need to look at the table EKBE which shows the purchase order history.

For a particular purchase order and item this table shows all the goods receipts and invoices posted. The filed EKBE-VGABE shows the type of the posting ( goods receipt = 1, invoice = 2 etc) . Just subtract the already posted quantities for goods receipts and invoices( as per requirement) from the actual purchase order quantity to get the pending quantity for items.

Regards,

Yogesh