How to see table delete/modify log

[Former Member]

Hi,

We are updating records in table . We dont know some one is deleting and modifying . how to find who is deleting my table records . Is there a log i can go and look.

- Kristene

[suresh_datti]

You can see the Table log history in SCU3 if the Table is logged for changes..> Technical settings-->Log data changes.

Regards,

Suresh Datti

[Former Member]

Hi

SU03/SU02/SU01 T-codes might help you to view the same

Regards,

Santosh

[former_member181966]

Also see the progs

RSDBLOGCONV40 Conversion of the database log table from 3.X to 4.0

RSLDARCH01 Archiving Program for Database Logs

RSLDARCH02 Delete Program for Database Log Archiving

RSLDARCH03 Read Program for Database Log Archive

RSLDARCH04 Reload Program for Database Log Archive

RSLD_FORMS Definition of Form Routines for Log Archiving

RSTBCOUNT Number of Table Change Logs (System-Wide)

RSTBHIST Table History

RSTBNAME Choose Object Name

RSTBPDEL Table Log Database Management: Delete logs

RSTBSUNA Choose Object Name

RSTBZAHL Count Table Change Logs

RSVTPROT Evaluation of change logs

TAB_INTO_AUTH_GRP Choose a Table

Hope this’ll give you idea!!

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

[abdul_hakim]

hi jyo,

all the change documents related to tables can be easily found in the tables CDHDR and CDPOS.

Cheers,

Abdul Hakim

Mark all useful answers..

[Former Member]

Hi,

run the Program <b>RDDTDDAT</b> .

also check this..

Regards

vijay

[Former Member]

Suresh,

When i went to SCU3 , system pops up me "the table loggin is not active your system" . How to active it.

Also how to find table authorization group logs.

- Kristene

[Former Member]

I'm not entirely familiar with table logging. It's turned off in our system as well. I believe this is because there are performance issues when this is turned on. If you only need to do this for a single custom table, I'd leave it. You can always turn off 'table maintenance allowed'.

Rob

[Former Member]

Hello Vijay,

After executing RDDTDDAT then where to see deleted auth group log.

-Cheers

[Former Member]

Hi,

after running the Program RDDTDDAT , give the Table name <b>TBKKAUTGRP</b>, and see is there any log for it.

Regards

vijay

[Former Member]

Hi,

Inorder to overcome your problem, create a lock object for your table. Then use the function ENQUEUE_ and lock the table, now update/insert/modify/delete your table. So that no one can do any operations until you finish your process.

Regs,

Venkat Ramanan