topic Find out which program/FM changes a table.. in Application Development and Automation Discussions

Find out which program/FM changes a table..

Former Member — Wed, 18 Mar 2009 12:58:37 GMT

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 — Wed, 18 Mar 2009 13:17:18 GMT

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 — Wed, 18 Mar 2009 13:36:39 GMT

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 — Wed, 18 Mar 2009 13:52:14 GMT

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

Former Member — Thu, 19 Mar 2009 11:55:33 GMT

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