2010 Jul 14 4:45 PM
Hello,
I want to be able to log changes to table SRGBTBREL, the GOS relationship table.
We enabled the rec/client parameter and set the log changes flag on the SRGBTREL table.
This table now shows in the scu3 list as being logged.
But when I add an attachment or delete an attachment from a work order it does not show in the log.
I thought I might need the change docuemnt flag set on the data element so I set if for data element SIBFBORIID.
Still nothing shows in the log.
Does anybody have any idea what might be wrong ?
(ps. we want to be able to track changes (who, when,where, etc) for gos attachments in work orders, equipment, etc.)
Thanks
John
Hello,
I want to be able to log changes to table SRGBTBREL, the GOS relationship table.
We enabled the rec/client parameter and set the log changes flag on the SRGBTREL table.
This table now shows in the scu3 list as being logged.
But when I add an attachment or delete an attachment from a work order it does not show in the log.
I thought I might need the change docuemnt flag set on the data element so I set if for data element SIBFBORIID.
Still nothing shows in the log.
Does anybody have any idea what might be wrong ?
(ps. we want to be able to track changes (who, when,where, etc) for gos attachments in work orders, equipment, etc.)
Thanks
John
2010 Jul 14 10:10 PM
Table logging is only for customizing tables updated via SE16 or SM30.
In the same manner, Change Documents are generated only if the application takes it into account.
I think you want to see new attachments, so you can use SRGBTBREL-UTCTIME field. Are there some other cases you need to detect?
2010 Jul 15 1:08 PM
Thanks for the reply.
Actuially with table logging enabled for SRGBBTREL I do see table logs in DBTABLOG.
It does tell me user, date and time and whether it is a insert, delete.
But the piece I don't see is the link (e.g. attachment 'a' added to equipment 123 or
attachment 'b' deleted from work order 567).
I'll keep digging but if anyone has any ideas please reply.
Thanks
John