Thursday, 16 July 2020

How many types of DB trigger in SAP LT Replication

In this blog, we will see How many types of trigger available SLT in the source system. In SAP LT Replication server DB trigger play an important role. 
We know that DB trigger read from source table load changes and information in the logging table. 

There are four types of DB triggers

we have specific DB triggers for inserts, updates, and deletes. 

The naming convention is as follows:

 /1LT/nnnnnnnnINS, /1LT/nnnnnnnnUPD1 and /1LT/nnnnnnnnDEL  -->  delta triggers (recording triggers); 

/1LT/nnnnnnnnFRI, /1LT/nnnnnnnnFRU, /1LT/nnnnnnnnFRD  ---> freeze trigger

we can check DB trigger by two method 

1: The easiest way is to use program IUUC_LIST_TRIGGERS to get the name of the trigger(s) for certain tables. Depending on the database system, up to four triggers are created for a table per data replication scenario of SAP Landscape Transformation.
2: we can check DB trigger by running statement in SQL which is given below 

SELECT SUBJECT_TABLE_NAME, trigger_name FROM PUBLIC.TRIGGERS WHERE IS_VALID = 'TRUE' AND IS_ENABLED = 'TRUE' AND SUBJECT_TABLE_NAME = 'DAY_HA_HOURS'





Thanks