Skip to Content
Author's profile photo Klaus Liu

SLT – Replicate view from Non-ABAP source

You want to replicate view in Oracle to HANA , while the view include two tables in different tablespace.


Table in oracle:

Table 1:  SLT_DEMO , SLT_DEMO is in tablespace TEST

Table 2 : SLT_DEMO1 , SLT_DEMO1 is in tablespace SLTORA






Go to SE16 -> Table “IUUC_DB_TAB_KEYS” -> add entry like below.

DBCON NAME:  input your db connection

DB SCHEMA: your DB schema

INT TABNAME: The View that you want to replicate

INT FIELDNAME: The key of the view


KEY POSITION : The position of the KEY


P.S. If you you have several keys, you could add severy entries one by one.



1. Go to transaction LTRS, then we need to define the advanced settings before we replicate the view.

  •    Transaction LTRS -> Choose your Mass Transfer ID -> Right click on “Table Settings” -> Add table -> Here we add the base table “SLT_DEMO”.
  •    In “Structure Template”, we input the view that we want to replicate
  •    In “Deviating Table Name” , here we can define the name that you want in your target system. If you want the name in target system the same as your source system. Here you can input “VIEW_TEST” the same name as the view in your source Oracle system.
  •    For “View for Initial Load” and “View for Replication”, we input the same as “Structure Template”
  •    Then click “Save” button to save the settings.


   Click on “Table Structure” tab, you will find that the structure has already been changed to the same as the view in Oracle.


   Right click on “Performance Options” -> Add table SLT_DEMO -> Change the “Reading Type” to “5 Sender Queue”. And click on “Save” button.


2. Go to transaction LTRC -> Table overview -> Data Provisioning -> Start replication of table “SLT_DEMO” .



And you will find that the view VIEW_TEST has aleady been replicated to HANA.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ertugrul Öztürk
      Ertugrul Öztürk

      Hello Klaus Liu,

      you used two different tablespaces in the source system in your scenario. Is there a possibility to connect to those tablespaces with SLT separetely?

      Kind Regards

      Author's profile photo Former Member
      Former Member

      Hi Klaus,

      I wonder if you would keep track of changes happening in each table with your test scenario. I mean, my understanding is that SLT will see you oracle view as a database table without keys, so you just define table keys in SLT. But how is SLT going to create triggers on that view? Could you maybe show us the triggers created in your database?


      Author's profile photo Bekmezci Burak
      Bekmezci Burak



      We have replicated a table which assigned a view from nonsap oracle source but we can not keep track changes. There is change of data on source system but it can not reflect to HANA side? Could you replicate these changes to HANA side?