SAP Knowledge Base Article - Preview

2751675 - Why do HANA Database systems use 4 or 5 triggers? - SAP Landscape Transformation Replication Server

Symptom

  • Why do HANA Database systems use 4 or 5 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

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 , 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 , 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.