Can we enable trigger on T000 table ?

[Former Member]

Hi,

Can we enable trigger on T000 table as client entries are being deleted from the system,and clients are production clients

[Former Member · Accepted solution]

Trigger means email alert whenever the entry changes or something else ?

Thanks

[Former Member · Accepted solution]

Yes, Something like that but here we don't need any email alert on change of entry, but we want that table entry should not be deleted by any means. We have enabled such triggers on some of the custom tables but we are not sure about whether this SQL trigger will work on standard system table.

Pls guide in this regard.

[former_member184473 · Accepted solution]

Hello,

Check note [105047|http://service.sap.com/sap/support/notes/105047]:

85. Trigger
o  Can be used as part of the SAP standard (for example, BW tigger /BI0/05* in accordance with Note 449891, incremental conversion ICNV)
o  Logon Trigger can be used in accordance with Note 712777.
o  Implicit use as part of Oracle features permitted (for example, online reorganisation, materialized views, GridControl/Enterprise Manager)
o  Otherwise, it cannot be used
o  Using trigger-based real-time replication is permitted in connection with an SAP HANA implementation only.

Regards,

Eduardo Rezende

[Former Member · Accepted solution]

You should not use triggers for this.

You should prevent access to transaction SCC4 for unauthorized users and also disable SE16 / SE16N and SM30 and also debugging authorization on production client.

You could activate table logging (rec/client parameter) to monitor changes but i don't recommend this, because a lot of other tables will be monitored too. But this is the official way to do it.

Cheers Michael

[Former Member · Accepted solution]

But as per your solution we tried everything that can be done to prevent access to SCC4 for all users except Basis Team members. Still a kind of incident happened that client got deleted from production.

Here we can't prevent access to SE16, SM30 like transactions to selected users and neither we can enable logging due to space problems.

Just wanted to confirm about that can we enable trigger on any table in SAP standard.

Thanks for your support I got the answer in previous post that we can enable trigger on any table.