topic Re: Compile trigger scripts in SAP in Application Development and Automation Discussions

Compile trigger scripts in SAP

Former Member — Wed, 10 Jan 2007 11:24:30 GMT

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

Re: Compile trigger scripts in SAP

Former Member — Wed, 10 Jan 2007 11:43:53 GMT

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,

Re: Compile trigger scripts in SAP

Former Member — Fri, 12 Jan 2007 13:31:46 GMT

Got the issue resolved by changing the Trigger script and modify the oracle level code