Skip to Content
Author's profile photo Former Member

Create multiple source systems in one Schema in SLT

By default, SLT lets you create a new schema for every source system connection. But if you are wondering how to connect multiple ECC source systems into one in SLT, you’re stuck because there isn’t much documentation on that. But how to do that?

Multi System Support

SAP let’s you create several different connection possibilities of creating a schema for SLT:

Multiple Systems Support - SLT.png

If you want to report over multiple source systems in one report you can solve that by using views across different schema’s, but that requires extra attention when you create a report. This is the reason why it is preferable to have one single schema in which there is only one uniform table, which gets it’s data replicated by from multiple source systems. Each table usually has LOGSYS field to filter records if necessary.

Add a System to a current Schema

If you want to add a source system to a schema, first make sure that system is not yet used a other schema. This sometimes requires you to delete a schema, when your SLT is setup like the top situation in the first picture.

To add the free source system to a current schema, go to your SLT system and logon. Then go to transaction LTR where you can see and maitain your schema’s. Click on “New” to start the wizard to create a new schema. But in stead of typing in a new schema name in the field “Configuration Name”, use the current schema name. In the “Description”-field you can type in any name as you like, but this also means that you may get confused because it will look like that it has two different schema’s. My advise therefore is to use the same description as the current schema.

Key in the Source System credentials and in the next screen of the wizard the Target System credentials. When this is complete, the system correctly identifies what you want to do effectively, that is to add a source system. In the pop-up select “yes” to add it to the current schema. Enter other specific wizard settings to complete the configuration.

Use Existing Schema in SLT.PNG

This will then lead to one schema with multiple source systems within the SAP HANA studio. In this table data is replicated from both systems.

SLT - Select source system.PNG

I hope this will be usefull for SCN members and adds to the existing SAP documentation.

Kind regards,

Bastiaan Lascaris

SAP BI consultant for CGI.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ronald Konijnenburg
      Ronald Konijnenburg

      Tx Bas! Keep sharing. I'm sure SCN is also very interested in the next steps: reporting in HANA Live!

      Author's profile photo Former Member
      Former Member

      Thnx Bas!

      But What would happen if we would like to replicate the same table for instance MARA from two source systems ?

      Thanks & regards,

      Jomy

      Author's profile photo Ronald Konijnenburg
      Ronald Konijnenburg

      Make sure you have a differentiator to determine the source system as part of your table and make sure you create unique master data sets (prefixed)