Find out which program/FM changes a table..

[Former Member]

Hi guys,

a table is changed and i don't know the program/FM/job which causes this. Of course i looked

at the "where use list" but didn't find out. I know the exactly time (+/- 5 sec.) of change.

Is there a possibility to find out via SQL Trace? Or how to do that?

Thanks

[Former Member]

Hi,

'DBTABLOG' is a standard table which is used to "Log Records of Table Changes."

You can try by giving your table name , date & time as input and get Program Name, Transaction Code which has updated your table.

For this in your table's technical settings "Log data changes" has to be checked.

Regards

Balaji R

[Former Member]

Hi,

DBTABLOG is the table which holds the changes made to a table entries by a Program.

CDPOS and CDHDR will hold the information about who has changed the table entries.

Table should be logged for data changes in the technical attributes.

Best Regards,

Suresh

[Former Member]

Thanks for your help, did it with ST01, but will also look at your solution

[Former Member]

see this report run in your system so u get all details

http://www.geocities.com/mpioud/Z_ALV_SM37.html