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

Custom table update should trigger

former_member199670
Participant
0 Likes
1,482

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.

1 REPLY 1
Read only

RaymondGiuseppi
Active Contributor
0 Likes
779

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