Skip to Content
avatar image
Former Member

Can SLT data replication invoke triggers defined in HANA DB?

Hi All,

Can SLT data replication invoke insert/update triggers defined on HANA tables?

Eg: I want to implement some logic inside a  data base trigger in HANA.

If I define insert and update triggers on a HANA table, will these be invoked if the the table is getting loaded though SLT ?

(In my case data is getting loaded from ECC to standalone HANA DB using SLT)

Thanks,

Goutham

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 23, 2015 at 10:06 AM

    Hi Goutham,


    A Hana DB is supported as a source system of a SLT. It behaves as any other databases (viewed from SLT).


    Technically, you can create a connection in SLT from your Hana DB to itself which will duplicate VBAP on the database.


    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2015 at 02:45 AM

    Hi Goutham,

    SLT replication will load/Replicate data from any source system to HANA.

    It does not recognize the changes what you do in HANA tables but the changes which happen in the source system are take care and exact same copy is produced in SAP HANA.

    Suppose you have 100 records in your MARA table i SAP ecc and tomorrow either they change to 120 or 80 the same number of records can be found in MARA table in  HANA, if you have set to replication.

    It can also detect the changes in existing records where few columns get changed.

    If you write some insert statement manually for MARA table in HANA(Which i doubt you can achieve), even if you achive, slt will not be able to recognize it.

    Thanks & Regards,
    Vijay

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Goutham,

      I don't think the exact thing you are looking for exists.

      Just as an idea - you can add an additional calculated column in SLT, transaction LTRS, fill it with the timestamp and create a HANA vew on top of VBAP using that field for your filtering.

      You can check out the intro to Transformations in this video by SAP Technology.

      Dmitry