topic Re: Custom table update should trigger in Application Development and Automation Discussions

Custom table update should trigger

former_member199670 — Tue, 15 Nov 2016 13:46:46 GMT

Hi,

I have a custom table, this table will be updated manually through SM30 or from any custom program using modify or update statements.

I have called a proxy in 'ON SAVE' TMG event of custom table. The proxy is called correctly when user try to save in SM30 but it fails to call when I try to save using modify statements in custom program.

I can understand that TMG events will not be called when updating table not from SM30. Since this custom table is updated from various program I don't want to write logic to call proxy in all the programs. Can anyone say a simple way to trigger the proxy when the custom table is updated in any form.

Thanks in advance.

Re: Custom table update should trigger

RaymondGiuseppi — Tue, 15 Nov 2016 14:39:38 GMT

TMG evenement are managed only in the generated dialog, and won't be triggered by any Open-SQL statement, if you want such events to be triggered, build some FM to wrap the update and raise the event in it, and no longer use any Open-SQL statement on this table. (As for SAP standard tables -The Update Process)

In recent version, you can CREATE some TRIGGER to execute when a database table is updated -Database Triggers.
In oldest version, if database change log is activated, you could create some background job to process DBTABLOG records.

Regards,

Raymond