topic Re: Track Table Changes in Application Development and Automation Discussions

Track Table Changes

Former Member — Tue, 07 Aug 2007 01:47:27 GMT

Hi,

May I know how to track changes to a table,

eg. what data has been added/updated/deleted by who and when?

i have set rec/client parameter in the profile.

and using SE13, i have tick the log data changes flag of the table.

when using scu3, logging display status, i can see logging is active

and the table logging status is active too.

when using scu3, list of change docs, the page shows

"Analysis without archived log data

No logs found for the selected period"

When clicking on compare, current and history is the same.

We have made a few updates, additions of rows to the tables.

May I know how to view these changes, made by who and when.

What other setting do i have to set?

Thanks.

Re: Track Table Changes

Former Member — Tue, 07 Aug 2007 05:51:28 GMT

Try going to SA38 and execute RSTBHIST.

Regards

Ashley

Re: Track Table Changes

Former Member — Tue, 07 Aug 2007 08:56:43 GMT

Hi,

Probably you may have a look at following tables:

<b>DBTABLOG</b> --- Table of log records for table tupel chang

<b>DBTABPRT </b> --- Table of log records for table tupel chang

Regards,

Santosh

Re: Track Table Changes

Former Member — Thu, 30 Aug 2007 13:46:04 GMT

Hi,

do table DBTABLOG and DBTABPRT report changes for every table anyway or they need particular settings? Are those tables updated even if changed by an ABAP report?

Thanks in advance,

Message was edited by:

Lovejoy

Re: Track Table Changes

Former Member — Thu, 30 Aug 2007 14:02:47 GMT

Hello Lovejoy,

Unfortunetly, the SDN search is not working today for some reason (no sarcasm intended... - ).

When it is back up again, search for the term rec/client. There are also SAP notes on it.

Cheers,

Julius