Track Table Changes

[Former Member]

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.

[Former Member]

Try going to SA38 and execute RSTBHIST.

Regards

Ashley

[Former Member]

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

[former_member1163517]

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,

M.

Message was edited by:

Lovejoy

[Former Member]

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