Skip to Content
avatar image
Former Member

SAP SLT - replicating one table twice within one configuration

Dear SAP & SLT experts,

We would like to replicate 1 table from 1 source system (so within 1 configuration) twice into the same HANA schema. The objective is to have the same table saved twice in the target schema with a different name and different data set (filters).

Example of what I mean, based on table BKPF:
1) One configuration, where the source is ERP system X, and the target HANA database schema Y.

2) We are drawing BKPF table from system X, but this table is being saved twice under the target schema Y - as BKPF_var1 and BKPF_var2. Each of the tables saved in target has a different field structure and filtering rules assigned.

Is this possible to achieve using SLT? Is there any other tool that can support this, i.e. SDI?
I appreciate your support!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Feb 08, 2017 at 05:58 AM

    Hi Piotr

    This is possible but does require custom coding in the SLT Transformation Rules.

    Would not be terribly difficult to implement

    Regards

    Arden

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Piotr

      You would still use the single trigger process.

      Within the MWB process, you need to manually add another Table (Your second table).

      Then you need to have an INCLUDE added, usually on the End of Record Event Processing.

      This include will have the code to populate Table 2.

      Regards

      Arden

  • Feb 01, 2017 at 10:34 AM
    -1

    Hello Piotr,

    While configuring SLT Step 2 (Specify Source System) - check "Allow Multiple Usage". This will allow 1:N replication in target system.

    Best Regards

    Murlli Maraati

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 31, 2017 at 06:42 PM

    Hi Piotr,

    I think we can bring the table in HANA and create two different views on this table. This will help you to achieve the result.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 01, 2017 at 10:44 AM

    Hi Mrityunjay,

    I appreciate your response! That would be our first choice, however, we are interested in a solution that does not require any development on HANA.

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 01, 2017 at 10:48 AM

    Hi Murlli,

    Yes, we are using that, but we want to avoid having 1:N for the same source system. The reason is that 1:N is limited to only 4 configurations per system (AFAIK), and is also an unnecessary duplication of resources.
    I am wondering whether there is any technical possibility to save the same source table twice in the target, under a different name with different filters/structure parameters, but from within one configuration.

    Add comment
    10|10000 characters needed characters exceeded