DB table entry log

[Former Member]

HI all,

i want to find out entry log for database table. i mean i have one ztable it contains some data, i want to know who and when entered that data. some programs are using this table. one of the programs are not working properply and populating wrong data to dbtable so i need to find that program.

is there any way to find out which program is populating wrong data and who has run that program

thanks.

[Former Member]

Hi,

First thing is that the Table Logging Option must be checked in your Table attributes.

If it is checked, you can check in the table: DBTABLOG

Regards,

Ravi Kanth Talagana

[Former Member]

where i need to check table logging option.

[Former Member]

Go to Technical Setting

and check checkbox Log Data Changes

Regards,

Anil

[Former Member]

Hi ,

Go to Se11 and give your table name and click display.

Click on the Technical settings button.

There will be a check box for "Log Data Changes".

It should be checked in order to find entries in DBTABLOG.

There will ne no use if you check it now, as it would not have recorded the changes till now. It will log the changes only from now onwards.

Regards,

Ravi Kanth Talagana

[Former Member]

No it is unchecked.

[Former Member]

In this case Log will not get created for your Ztable.

Regards,

Anil