topic Re: Trigger event for custome table without using TMG in Application Development and Automation Discussions

Trigger event for custome table without using TMG

Former Member — Tue, 16 Apr 2019 14:35:34 GMT

We have come up with requirement as below,

Consider there are two custom table A and table B. If one entry is created in table A, then table B should be updated with related data.

We have implemented the code for table maintenance generator. But in other case if user is not updating using TMG still it should update the table B.

How can we implement the above logic?

Thanks in advance.

Re: Trigger event for custome table without using TMG

matt — Tue, 16 Apr 2019 14:50:39 GMT

How is the user updating table A, if not via TMG?

Re: Trigger event for custome table without using TMG

DoanManhQuynh — Wed, 17 Apr 2019 02:59:42 GMT

maybe view cluster could do the trick:

https://wiki.scn.sap.com/wiki/display/TechTSG/View+Clusters-Creation+and+its+Benefits

Re: Trigger event for custome table without using TMG

RaymondGiuseppi — Wed, 17 Apr 2019 06:17:43 GMT

How did the 'user' updates the table if not in the TMG, did you really expect any SQL statement to trigger your code

Either look at trigger defined in database (from there no longer an Abap development subject...)
Or insure that your code is always executed by developping some update task FM and make sure every developper uses your FM

Re: Trigger event for custome table without using TMG

Former Member — Wed, 17 Apr 2019 06:20:57 GMT

In any case if table will get update from abap code like modify. It should trigger event which will update other table.

Re: Trigger event for custome table without using TMG

matt — Wed, 17 Apr 2019 06:53:07 GMT

Then you have to program the update to happen after the modify. As Raymond said

"insure that your code is always executed by developing some update task FM and make sure every developer uses your FM"

Re: Trigger event for custome table without using TMG

Former Member — Wed, 17 Apr 2019 07:13:12 GMT

Yes I thought of this solution. But what if in future any developer will add code for Modifying table.
Is there any way to trigger event if the table in updated with new entry other than TMG events? Like from SWED or SWEC configuration?

Re: Trigger event for custome table without using TMG

RaymondGiuseppi — Thu, 18 Apr 2019 06:25:23 GMT

You 'like from SWED', but SWED use change documents that are programmatically generated and executed by update task FM, so if some customer, or some sap on site ☺, uses some open sql statements they would not be triggered.