SAP Knowledge Base Article - Preview

2751675 - Why do HANA Database systems use 4 or 5 (/1LT/* or /1DH/*) triggers? - SLT / ABAP CDC Engine

Symptom

  • Why do HANA Database systems use 4 or 5 (/1LT/* or /1DH/*) triggers?
  • Why are there 4 or 5 triggers rather than 3 triggers for each source table?
  • Why is there an UPD1 and UPD2 trigger (and UPD3 trigger)?
  • Why does an update to a keyfield result in two logging table records (1 record for delete and 1 record for insert)?
  • Why can a single update or upsert to a record result in multiple update triggers firing?


Read more...

Environment

  • SAP Landscape Transformation Replication Server (/1LT/* or /1DH/* triggers)
    AND/OR
  • ABAP CDC engine (/1DH/* triggers).

Product

SAP Landscape Transformation replication server 1.0 ; SAP Landscape Transformation replication server 2.0 ; SAP Landscape Transformation replication server 3.0

Keywords

SLT, HANA, Trigger, Database Trigger, key field, key-field, keyfield, /1LT/*, /1DH/* , KBA , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , CA-LTR-GEN , Use CA-LT-SLT instead , CA-LTR-DB , Use CA-LT-SLT instead , CA-LTR-BW , Use CA-LT-SLT instead , HAN-DP-LTR , Use CA-LT-SLT instead , BC-DB-CDC , ABAP CDC Engine (Change Data Capture) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.