How to Replicate table from ABAP to ABAP Multiple Clients

[former_member10620]

Hi community,

With DMIS 2011_1_731 SP11 there is a requirement to replicate tables from ABAP to ABAP system, one source client to multiple target clients.

For HANA database as a target, it is noticed that DMIS 2011_1_731 SP11 supports N:1 and 1:N scenario. Is it possible for ABAP to ABAP scenario to reconcile selective table scenario?

[ian_kirkman · Accepted solution]

Hi Suresh,

By default, SLT will replicate the MANDT (client) value as stored on the source table. If you want to replicate to multiple clients, you will need to specify a rule for the tables in each configuration to change the MANDT value to the target MANDT value required.

For example, if you are replicating from client 010 and want all the records to replicated to client 100 on another system, the rule would be on MANDT field with the line E_MANDT = ‘100’. You may also need to specify MANDT in ‘Import Parameter 1’. Alternatively, the rule can be specified like" IF I_MANDT_1 = ‘010’. E_MANDT = ‘100’. ENDIF. " without the quotation marks. This can be seen in the screenshot below (taken from an SAP internal system for demonstration purposes):

To set a rule to automatically be applied for every table in a configuration, this can be done in LTRS -> More -> Goto -> Template Maintenance. The rule can be specified as above, before assigning the template to the configuration. There doesn’t need to be anything set in the ‘patterns’ section of the template maintenance for this.

For each client you want to replicate the data to the target system you will need to create a separate configuration. For this a different connection to the source system needs to be used to prevent an error (see 2751211 - 1 to n scenario ERROR: Source System is already used to replicate into the corresponding Target Schema – SLT).

Note that with DMIS 2011 SP11, up to 4 configurations can be created that use the same source system. This is changed in later versions, but the limit of 4 configurations using the same set of triggers remains (see 2796027 - How many times can a table be replicated using SLT?)

As an aside DMIS 2011 SP11 is an old version of SLT, where currently it is recommended to have all DMIS systems on at least DMIS 2011 SP16 / DMIS 2018 SP01.

Regards,

Ian

SAP Product Support