topic Re: Purchase order... in Application Development and Automation Discussions

Purchase order...

Former Member — Thu, 09 Aug 2007 05:08:38 GMT

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

Re: Purchase order...

Former Member — Thu, 09 Aug 2007 05:27:22 GMT

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

*Reward if useful

Re: Purchase order...

Former Member — Thu, 09 Aug 2007 05:29:11 GMT

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

*Reward if useful

Re: Purchase order...

Former Member — Thu, 09 Aug 2007 05:36:15 GMT

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