topic Re: PO tables in Application Development and Automation Discussions

PO tables

Former Member — Thu, 19 Apr 2007 20:21:32 GMT

I need to read a list of Open Purchase Orders(for which I/R's have not been done completely) created or changed in a particular date range. Can anyone let me know the relevant tables where I can read this data from.

Any help would be appreciated.

Thanks.

Alam.

Re: PO tables

Former Member — Thu, 19 Apr 2007 20:28:11 GMT

Open po related tables r....

EKKO, EKPO, LFA1, EKET, EINE and condition for open PO's is...

if EKPO-ELIKZ = ' ' then all the po's r open.

if u find it helpful mark the points

~~Guduri

Re: PO tables

ferry_lianto — Thu, 19 Apr 2007 20:29:00 GMT

Hi,

Please check table EKKO and field FRGZU with values as 'X' or ' '.

Regards,

Ferry Lianto

Re: PO tables

Former Member — Thu, 19 Apr 2007 20:31:06 GMT

Hi,

You can achieve this with the help of tables EKKO ( PO header data ), EKPO (PO line item data) EKBE ( History of PO doc ), RBKP (Document Header: Invoice Receipt), RSEG (Document Item: Incoming Invoice).

The field EKPO-EREKZ is final invoice indicator. When the value of this field is set to 'X', it means that the line item has been fully invoiced. Keep in mind that this indicator is at line item level. You can not concur based on only one line item that PO is open or not. You have to check all line items.

You can also use FM ME_READ_HISTORY to read PO history.

Let me know if you need any other information.

Regards,

Re: PO tables

Former Member — Thu, 19 Apr 2007 23:35:18 GMT

Hello RS,

How do we find if any change has been made to the PO at the header level?

Thanks,

Alam.

Re: PO tables

Former Member — Fri, 20 Apr 2007 01:36:57 GMT

Hi,

To find the changes to PO ( or any other documents ) you have to use tables CDHDR and CDPOS.

This how it works.

[1]. Read table CDHDR with

OBJECTCLAS = EINKBELEG

OBJECTID = "Purchase Order no".

[2]. If you find any records from CDHDR, that means that PO has been changed. Now take the change document number from CDHDR (CHANGENR) and read table CDPOS with

OBJECTCLAS = EINKBELEG

OBJECTID = "Purchase Order no"

CHANGENR = CHHDR-CHANGENR.

You can also use the the standard function modules CHANGEDOCUMENT_READ_HEADERS ( to read CDHDR data) and CHANGEDOCUMENT_READ_POSITIONS ( to read CDPOS data ) to read document changes.

The header level changes are those where field CDPOS-TABNAME = 'EKKO'.

Let me know if you need any other information.

Regards,