SLT: Limitations for replicating views

[Former Member]

Hello SAP Community,

we successfully replicated a simple view (a view which presents the content of a table and a view which displays a subset of a table).

However we have not been able to replicate a more complex view. Even a view which displays only an additional column (copy of another column with a synonym) was not possible.

Does somebody know the limitations for views and if there exist some work-arounds? E.g. materialized view?

Thanks in advance

Thorsten

[former_member252769 · Accepted solution]

Hi Thorsten,

Replication of views should not be a problem, you can easily replicate database view which involves more than 1 tables.

Only thing which u need to remember is that first all the underlying tables need to be replicated before replicating a view.

Regards

BJ

[Former Member · Accepted solution]

Hello Again.

I just saw that I did not mention the system configuration. What we want to do is:

1. Replicate from DB2 10.5 to DB2 10.5

2. Replicate from DB2 10.5 to ODQ / BW

At the moment I am trying to to replicate a view from DB2 to DB2.

SLT Relase DMIS 2011_1_731 SP Level 10.

So I tried the solution you described:

1. Create Table on DB2 source

2. Replicated the source successfully

3. Created a simple view on DB2 source (select one column from src table)

4. Added the view in Transaction LTRS

    -> view did not appear in destination system (DB2 10.5)

Additionally I tried to replicate as described here:

1. Create table and view in source system

2. added view in LTRS (removed 1 column) Table: ID, DESC, View: DESC

3. Start replicating by adding the table name in transaction LTRC.

--> Result was that a table was created in the destination with only the ID column (as expected)

     Unfortunately no data appears in the destination.

     The status in transaction LTRC is Replication(initial load) - nothing happens after that.

What I noticed as strange when adding the view in LTRS is that the table structure is recognized correctly on the left side.

But the modified table structure is empty.

Then I tried to remove the column desc which resulted on the right side that DESC is marked as "remove".

Then clicking on the button "View Modivied Table Structure" resulst in an empty structure (as bevor - nothing changed here)

I would expect the changed table structure to contain only ID - not nothing.

[Former Member]

hello,

Can you share some screen shot for the error msg

Amar

[Former Member]

at the moment I cannot supply an error message since I cannot isolate the issue. I'll supply as soon as possible.

In the meantime I created some more threads with specific Problems.

Is there no Guide on how to Use SLT with views?