Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

table logging for SRGBTBREL

Former Member
0 Likes
1,572

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

2 REPLIES 2
Read only

Sandra_Rossi
Active Contributor
0 Likes
977

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?

Read only

Former Member
0 Likes
977

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