Note : Deleting a trigger might have a significant impact on the related project. Therefore use this option in exceptional situations only and inform the project team if you delete a trigger.
There are different possibilities on how to delete a trigger in the system:
1. using functionalities from SAP Landscape Transformation (requires authorization delivered with role SAP_IUUC_USER / FF/SAP_ALL)
2. using database specific SQL commands (requires access to database console)
When we can go for the triggers deletion in SAP SLT landscape, below are the few issues
- Inconsistent triggers
- Message no. CNV_IUUC_REPLICATION057
- Restarted replication but triggers were not recreated
- Trigger missing for table <table name> (mass transfer ID ###); replication suspended
- How to delete the existing SLT triggers
then first step we will display triggers against this table
To display the existing SLT triggers, follow the below steps on the source system:
- Execute transaction IUUC_REMOTE
- On the Display Functions tab, click the List Triggers button
- The system displays a screen that contains the following default selection parameters. Enter the table name in the below field:
- Click the Execute button to display the list of SLT triggers.
Once we identify triggers against respective table then we can go for the deletion. there will be me multiple triggers against singe table. ( I explain same in different blog you can refer that )
To delete the existing SLT triggers, follow the below steps on the source system ( S4 or ERP):
- Execute transaction IUUC_REMOTE ( Note : you might need FF or SAP ALL access temporary to perform these steps as its production system)
- Click on the Expert Functions tab
- Click on the Delete Triggers button
- The system displays a screen that contains the following default selection parameters. Enter the table name in the below field:
- Note: If executing the program using these default selection parameters, without specifying any table name, all the SLT triggers will be dropped.
- Click the Execute button to delete the list of SLT triggers.
- The system will ask to confirm the deletion of triggers.
Additional information:
program: IUUC_LIST_TRIGGERS ( to list triggers)
Database Microsoft SQL Server : A separate delta trigger is created for inserts, updates and deletes.
A trigger can be deleted on database level with the following SQL command refer this SAP note
https://me.sap.com/notes/1620618