Trigger event for custome table without using TMG

[Former Member]

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.

[matt]

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

[DoanManhQuynh]

maybe view cluster could do the trick:

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

[RaymondGiuseppi]

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

[Former Member]

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

[matt]

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"

[Former Member]

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?

[RaymondGiuseppi]

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.