topic Re: Tables that keeps PO changes... in Application Development and Automation Discussions

Tables that keeps PO changes...

yohan_weerasinghe — Wed, 22 Oct 2008 07:54:19 GMT

Hi,

I need to find out what are the tables that record all the changes done to POs by using the transaction code ME22N. I found two tables CDHDR & CDPOS, but those tables not contains Sufficient details.

If you guys know any other way to find it, please let me know.

Else, are there any Function modules which can be used to retrieve data from...

Thanks for your help,

Yohan.

Re: Tables that keeps PO changes...

h_senden2 — Wed, 22 Oct 2008 07:58:04 GMT

Maybe you can use the EKBE table, which contains Purchase order history information

regards,

Hans

Re: Tables that keeps PO changes...

yohan_weerasinghe — Wed, 22 Oct 2008 08:04:01 GMT

Dear Hans,

Data will goes into this table only if PO linked with a Sales Order (SO). Therefore I could not find any changes done to the relevant PO.

Please correct me if I am wrong.

Thanking you,

Yohan.

Edited by: Yohan Weerasinghe on Oct 22, 2008 10:04 AM

Re: Tables that keeps PO changes...

Former Member — Wed, 22 Oct 2008 08:16:08 GMT

Hello

Try to use FM 'ME_CHANGES_READ'

Re: Tables that keeps PO changes...

ThomasZloch — Wed, 22 Oct 2008 08:33:00 GMT

EKBE contains all PO item "events" like good receipt, invoice receipt etc., not only when linked to a sales order.

And CDHDR/CDPOS indeed contain the changes done to POs. What are you missing there?

Thomas

Re: Tables that keeps PO changes...

JoffyJohn — Wed, 22 Oct 2008 08:38:39 GMT

You will get all the PO changes done

from table CDHDR and CDPOS itself

CDHDR is the header table

Object value for PO is: EINKBELEG

and the old and new value is stored in table CBPOS

Re: Tables that keeps PO changes...

former_member451655 — Wed, 22 Oct 2008 09:02:14 GMT

hi ,

If the Feilds in "BAPIEKBE" Structure meets your Data Requirements , you can use BAPI_PO_GETDETAIL.

Br ,

Dilum

Re: Tables that keeps PO changes...

Former Member — Wed, 22 Oct 2008 10:28:51 GMT

Hi Yohan,

May i know what details you want other than in cdpos and cdhdr tables?

Thanks and Regards,

kamalapriya

Re: Tables that keeps PO changes...

SujeetMishra — Thu, 23 Oct 2008 06:40:36 GMT

Hi Yohan,

you can find your changed PO only in table CDHDR & CDPOS.

what other details you are searching in these tables?

Re: Tables that keeps PO changes...

Former Member — Thu, 23 Oct 2008 06:46:20 GMT

ME_READ_CHANGES_EINKBELEG

ME_CHANGES_READ

the above two Fm's read the changes made to the PO

the above two Fm's return these internal table

cdhdr

cdpos

cdshw

these will contain all information u need

Re: Tables that keeps PO changes...

yohan_weerasinghe — Thu, 23 Oct 2008 07:13:23 GMT

Dear Sujeet,

Thanks for your reply.

In those tables it does not give us the exact changes we have done. But it gives us the table name which have affected by those changes.

Therefore the information given in those two tables are not helpful for my job. That's why I am searching something more...

Re: Tables that keeps PO changes...

Former Member — Thu, 23 Oct 2008 07:17:36 GMT

try this FM.

CHANGEDOCUMENT_READ_HEADERS

CHANGEDOCUMENT_READ_POSITIONS

Re: Tables that keeps PO changes...

Former Member — Thu, 23 Oct 2008 07:19:29 GMT

well yohan the structure cdshw does conatin the previous and new values. but if u are looking for some other info. it wud help us to guide u if u specify what exactly are u looking for.

Re: Tables that keeps PO changes...

yohan_weerasinghe — Thu, 23 Oct 2008 07:26:25 GMT

Dear Arun,

Thanks a lot.

I checked the FMs you sent. They are working and giving the exact results I wanted.

Thanks...

Re: Tables that keeps PO changes...

asik_shameem — Thu, 23 Oct 2008 07:28:53 GMT

Use the FM CHANGEDOCUMENT_READ_WITHOUT_ED

CALL FUNCTION 'CHANGEDOCUMENT_READ_WITHOUT_ED'
    EXPORTING
      client            = sy-mandt
      objectclass       = 'EINKBELEG'    " Purchase Order
      date_of_change    = sy-datum
    TABLES
      icdhdr            = gt_cdhdr
      icdpos            = gt_cdpos.

In the table gt_cdpos, you will get details of changes.

To get Object Class: T-Code: SCDO