topic Re: trigger on sap table in Application Development and Automation Discussions

trigger on sap table

Former Member — Thu, 11 Dec 2008 11:15:39 GMT

Hi All,

I have small requirement on triggering, when there is an insertion in specific table.

requirement is as follows.

There is z-table which has got two fields hno and hname.

when i insert a value into hno the trigger should run a program which does the insertion of hname for the respective hno.

please help me in finding the resolution as soon as possible.

Thanks in advance.

Regards,

Anil

Re: trigger on sap table

Former Member — Thu, 11 Dec 2008 11:21:00 GMT

Hi,

You need to create a TMG for that z-table and disable the hname for editing.

Now you need to create a modification event in the TMG for the table.

Goto ENVIRONMENT-> Modification -> Events.

select a suitable event create the Form and call whatever program you want to call from there.

Hope this helps,

Reg,

Rajat

Re: trigger on sap table

Former Member — Thu, 11 Dec 2008 11:42:27 GMT

This link may come handy in creating the events :

link:

Re: trigger on sap table

Former Member — Thu, 11 Dec 2008 11:50:54 GMT

And to trigger an event on record insert you should create a TMG for that and write the logic in events.

Otherwise while updating/inserting records to the table through ABAP you should calculate and supply the other field values before inserting into the database.

Regards

Karthik D