Replicate views

[Former Member]

Hi,

In the blog http://scn.sap.com/community/replication-server/blog/2014/05/14/realtime-replication-with-slt-into-d... there is demonstration that replicate view. We are in SP 6 and when trying to do so we get the message: table class view of table xxx is not supported for data provisioning.

What am I doing wrong?

Thanks,

Amir

[Former Member · Accepted solution]

I've found the answer to my question from the following document:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e00c4546-88c8-3110-4f9c-bc4e61327...

View-based SLT delta-transfer technology (with SP06):

Simple BW Extractors can be rebuilt with Views, if the following prerequisites are fulfilled:

 Views need to be built which need to contain all relevant tables

 the view relations as well as the primary key of the view need to be designed

 there must be a hierarchy with one main table

 only this main table is triggered/recorded (means the line item tables attached to the main table are not triggered)

 Target is 1 transparent table (there is no data split after SLT transfer e.g. into two or more tables)

The capability is shipped as a framework; content is not part of the shipment!

Benefits compared to standard BW Extractors:

- Can go across clients, reducing number of running processes and setup efforts for each client

- enhances tables with delta capabilities, thus streamlines the dataflow from full to delta for transferred data.

Thanks,

Amir