Find out which program/FM changes a table..

Former Member · ‎2009 Mar 18

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 · ‎2009 Mar 18

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 · ‎2009 Mar 18

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 · ‎2009 Mar 18

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

Former Member · ‎2009 Mar 19

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