Skip to Content
0

Custom table update should trigger

Nov 15, 2016 at 01:46 PM

76

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raymond Giuseppi
Nov 15, 2016 at 02:39 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded