How to check SAP SLT - Trigger State in SLT System or Source system ?

 Error: 

• CNV_IUUC_REPLICATION057
• System Landscape Transformation (SLT) triggers are in an inconsistent state. 
• The missing trigger for table XXXXX for MT_ID XXX. Replication Suspended.”
• You recently upgraded the HANA DB of the source system.

Upon encountering the above error. The first step is to check the Trogger State. We have two options to check triggers.

Option A: On Source System
Option B: On the SLT Server

A: Source System

1. Log in to the Source system of SLT configuration.
2. Go to Transaction SE11
3. In the Database table section type in the table name
4. Click Display
5. Click Utilities (M) in the ribbon at the top.
6. Click on Database Object
7. Click Display
8. Scroll to the bottom and triggers are there.

Note : SLT triggers follow the notion: /1LT/<IDENT><OP> where <IDENT> is a 8 digit number Identifier and <OP>  represents the operations INS, DEL, UPD1 or UPD2

B: the SLT Server

• Log into LTRC
• Type in Mass Transfer ID or click on MT_ID
• Click on the Expert Function Tab
• Click on ‘View Trigger Source Code’ (This works for both SAP & Non-SAP data source)
• Confirm the 'Mass Transfer ID', type in the 'Table Name in Database' and click on the 'Active Code' radial button, and click execute (green check mark)

Note : SLT triggers follow the notion: /1LT/<IDENT><OP> where <IDENT> is a 8 digit number Identifier and <OP>  represents the operations INS, DEL, UPD1 or UPD2