topic Re: is there a table that logs changes? in Application Development and Automation Discussions

is there a table that logs changes?

Former Member — Thu, 28 Sep 2006 11:45:06 GMT

hi, guys, got a question here:(

is there any table can note all the changes made by users through foregound operation?

e.g. it logs that which field value of which table was changed, what time is the changing, who changed it, who originally created it?

or could anyone help me find a field describes the time of last change for a certain record in TABLE EORD(source list) and EQUK,EQUP(quota arrangement)?

thanks in advance guys, u really helped me a lot.

Re: is there a table that logs changes?

Former Member — Thu, 28 Sep 2006 11:46:52 GMT

Check the tables CDHDR,CDPOS

Re: is there a table that logs changes?

Former Member — Thu, 28 Sep 2006 11:55:45 GMT

Hello,

CHECK the table CDHDR,CDPOS.

If useful reward.

Vasanth

Re: is there a table that logs changes?

Former Member — Thu, 28 Sep 2006 12:03:44 GMT

Check CDHDR & CDPOS tables.

Regards,

Santosh

Re: is there a table that logs changes?

Former Member — Thu, 28 Sep 2006 12:19:41 GMT

Hi Yuan,

"CHANGE DOCUMENTS" in SAP Terminology

1. THIS WILL ALSO DETECT WHICH FILEDS HAVE CHANGED.

IT CAN ALSO GIVE, The Old Value, And The New Value.

2. This Mechanism is called CHANGE DOCUMENTS in

SAP Terminology

3. 2 Fuction Modules are Required.

(They will fetch necessary data from CDHDR,CDPOS)

CHANGEDOCUMENT_READ_HEADERS

CHANGEDOCUMENT_READ_POSITIONS

4. The First FM gives list of all

records ( with change no) which have changed.

5. Loop at the above and the second FM will

provide the details (old-val, new-val) for

each record.

6. While using 1st Fm, i used docclass as 'MATERIAL'.

BCOS

the concept of change documents is applicable

to other type of documents also (depends upon

customization)

regards,

amit m.

Re: is there a table that logs changes?

guillaume-hrc — Thu, 28 Sep 2006 12:34:31 GMT

Hi,

Try table DBTABLOG but the tables need to be traced.

Try a search in the forum on DBTABLOG, this subject has already been discussed.

Best regards,

Guillaume