topic Re: Transparent table logs in Application Development and Automation Discussions

Transparent table logs

Former Member — Fri, 28 Aug 2009 05:22:09 GMT

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

Re: Transparent table logs

Former Member — Fri, 28 Aug 2009 05:37:17 GMT

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

Re: Transparent table logs

Former Member — Fri, 28 Aug 2009 08:47:53 GMT

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

Re: Transparent table logs

Former Member — Fri, 28 Aug 2009 11:36:21 GMT

Hi,

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

under technical settings -> log data changes

- Sujatha

Re: Transparent table logs

Former Member — Sat, 05 Sep 2009 10:50:55 GMT

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

Re: Transparent table logs

Former Member — Thu, 11 Mar 2010 08:22:12 GMT

thanks