01-10-2007 11:24 AM
Hi All,
I have requirement to create a trigger on a table A. Any insert or update on this table will create an entry into table B.
In our systems, I have to create the script i.e. write oracle code to create trigger and send it to Basis person. He then uploads and trigger gets created. If any error occurs he emails us with error occured.
I need to know here, is there any way I can compile the this code to create a trigger in SAP editor.
Any tool which will help me to compile this and be independent of basis person.
Thanks in advance.
Regards,
Shahu
01-10-2007 11:43 AM
Hi Shahu ,
i have some suggestions:
i) if you are talking about Ztables, i supose that the tables update are made with zprograms, so in the zprograms you can ensure that when 1 table is updated the other also is (with own coding).
ii) you can have an background program (Job) that is always running, i does the comparasion bettewn the tables and updates if necessary.
iii) who can use SAP workflow to do this. It'can control any action above an object(in this case a table) an perform an action (updates an other table)
Regards,
01-12-2007 1:31 PM
Got the issue resolved by changing the Trigger script and modify the oracle level code