Transparent table logs

[Former Member]

Dear all,

If I update any transparent table through program or any transaction , from where can I know when these changes were done by whom ( any transaction or program name ) and what were the previous entries ?

Thanks

[Former Member]

Hi,

All system data changes are logged in CDHDR (header) and CDPOS (item) tables. you can query these tables to get the info.

Regards

Sajimon Chandran

[Former Member]

Hii,

DBTABPRT-->Table of log records for table tupel changes

DB2CCDL_OUTTS->History of output table

DBTABLOG-->Table Logs

Use report RSTBHIST or RSVTPROT or RDDPRCHK for reading the table

also check this link,[log details|http://help.sap.com/saphelp_470/helpdata/en/7e/c81ec852c511d182c50000e829fbfe/content.htm]

regards,

Archana

[Former Member]

Hi,

I think a check box needs to be checked to log the changes for any table.

under technical settings -> log data changes

- Sujatha

[Former Member]

Hello,

There is a general misunderstaning between change documents and table logging.

SAP does NOT record change documents for all tables.

Change documents are only recorded for the objects/tables that are defined in transaction SCDO.

When you want extra change documents for a specific Z-table for example you need to create a change document object in transaction SCDO.

Afterwards SAP will also create change document for your Z-tables.

Table logging works completely different.

More help can be found in :

[Table logging|http://help.sap.com/saphelp_nw04/Helpdata/EN/7e/c81ebb52c511d182c50000e829fbfe/content.htm]

Pay attention when you activate the parameter from the link, because all tables that are flagged with the Table logging checkbox in the technical settings will be logged and this can overflow your DBTABLOG table that contains the table changes once the parameters is activated.

I hope this helps.

Wim Van den Wyngaert

[Former Member]

thanks