Oracle Database Trigger on SAP RESB table

[Former Member]

I have created a database trigger on the RESB table to fire after all INSERTS, DELETES and UPDATES. A record will be inserted into a Z table to help keep track of material changes that are creating MRP messages. If I create a production order (CO01) or change a production order (CO02), this trigger works great.

My problem comes in when I am running MRP (MD02) for a part. The program errors out when it performs the 'ALL_DELETE_MDSB' in the source code of LM61UF1M or the main program SAPLM61U. Here is the code:

DELETE FROM MDSB

WHERE RSNUM EQ RSNUM.

The table MDSB is a 'Generated Table for View MDSB'. The MDSB view contains the RESB table only. So it seems that when MRP runs and deletes records out of the MDSB table, the RESB trigger is firing for some reason and is causing the MRP to error out.

Can someone tell me how I can get this trigger to work all the time? Thanks.

Theresa

[stefan_koehler]

Hello Theresa,

please take a look at sapnote #105047 - subpoint 55:

      55. Trigger
Used implicitly by SAP in the BW environment (/BI0/05*, see Note 449891)
Logon Trigger can be used in accordance with Note 712777.
Otherwise, it cannot be used
You cannot use trigger-based real-time replication either.

Triggers are not supported for DMLs...

Regards

Stefan