‎2008 Oct 22 8:54 AM
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.
‎2008 Oct 22 8:58 AM
Maybe you can use the EKBE table, which contains Purchase order history information
regards,
Hans
‎2008 Oct 22 9:04 AM
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
‎2008 Oct 22 9:33 AM
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
‎2008 Oct 22 9:16 AM
‎2008 Oct 22 9:38 AM
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
‎2008 Oct 22 10:02 AM
hi ,
If the Feilds in "BAPIEKBE" Structure meets your Data Requirements , you can use BAPI_PO_GETDETAIL.
Br ,
Dilum
‎2008 Oct 22 11:28 AM
Hi Yohan,
May i know what details you want other than in cdpos and cdhdr tables?
Thanks and Regards,
kamalapriya
‎2008 Oct 23 7:40 AM
Hi Yohan,
you can find your changed PO only in table CDHDR & CDPOS.
what other details you are searching in these tables?
‎2008 Oct 23 8:13 AM
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...
‎2008 Oct 23 8:19 AM
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.
‎2008 Oct 23 8:28 AM
Hi
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
‎2008 Oct 23 7:46 AM
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
‎2008 Oct 23 8:17 AM
hi
try this FM.
CHANGEDOCUMENT_READ_HEADERS
CHANGEDOCUMENT_READ_POSITIONS
‎2008 Oct 23 8:26 AM
Dear Arun,
Thanks a lot.
I checked the FMs you sent. They are working and giving the exact results I wanted.
Thanks...