Skip to Content

Custom table update should trigger

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 15, 2016 at 02:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded