Stack Overflow
Stack Overflow

Questions tagged [slt]

SLT - SAP Landscape Transformation is a realtime replication / data provisioning tool from SAP. It uses triggers to detect and transfers deltas from source to target.

SLT - SAP Landscape Transformation is a realtime replication / data provisioning tool from SAP. It uses triggers to detect and transfers deltas from source to target.

19 questions
2
votes
2 answers

SAP HANA Decimal to timestamp or seconddate SLT

I am using SLT to load tables into our Hana DB. SLT uses the ABAP dictionary and sends timestamps as decimal (15,0) to the HANA DB. Once in the HANA DB via a calculated column in a calculation view, I am trying to convert the decimals to…
CodeMonkey
  • 1,087
  • 2
  • 15
  • 24
1
vote
1 answer

SAP SLT into HANA not updating date field

I would like to SLT data into our HANA Data warehouse. That is the easy part, I can move data that is a one to one match (type 1 table). But I would like to make it type 2 and preserve history. I have the following code in the transform, and it…
CodeMonkey
  • 1,087
  • 2
  • 15
  • 24
1
vote
1 answer

SLT Replicate View - Error: SQL0601N The name of the object to be created is identical to the existing name

Situation: We wan to to real-time ETL using SLT (SAP Landscape Transformation) Replication Server. I learned that I have to define views in transaction LTRS. So I try to add a view to an existing Table like in the Screenshot. Unfortunately I get the…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
1
vote
2 answers

Data Replication from HANA to HANA

I need to replicate data from a source HANA database to other HANA database on real time basis (on trigger event like update/delete/insert). I have searched for the solution and found one i.e. SAP LT Replication Server. But I need custom…
lucky
  • 21
  • 4
0
votes
0 answers

SAP SLT - Restrict no of sessions to 5 for a particular subscription

I am working on POC to ingest data from SAP SLT. I will fire ingestion for a batch of tables(around 50) parallelly, but when I do so, it is increasing the load on the SLT end. I want to make sure only five ingestion sessions are active at one point…
dragonachu
  • 451
  • 1
  • 7
  • 20
0
votes
1 answer

SAP SLT to Kafka integration?

I need to capture CDC data for selected tables and columns from SAP ECC to Kafka topics. There is currently SAP SLT layer which sends data from SAP to non-SAP systems. Can we utilize SAP SLT to send data to Kafka Topics or do we need to utilize any…
VN-
  • 27
  • 6
0
votes
2 answers

Optimal way to transfer 4 Virtual SDA Tables in Hana DB

Problem: My team is currently undergoing an ERP migration from an ECC system to a new S/4 Hana System. As part of go-live, our team needs to replicate all of the tables out of the S/4 system and into our SLT schema which will host the data. A…
lildakota
  • 141
  • 3
  • 15
0
votes
1 answer

SAP HANA table partitioning

After table partitioning(Hash by partition 4) observed increased in total memory consumption on memory on disk. Earlier we did the partition (Hash by partition 12) observed decreased in total memory consumption on memory on disk. Both tables are SLT…
Mayankb024
  • 11
  • 2
0
votes
1 answer

Time dependent Master data via History tables in SAP HANA

I was looking for the best way to capture historical data in HANA for master data tables without the VALID_TO and VALID_FROM fields. From my understanding, we have 2 options here. Create a custom history table and run a stored procedure that…
Analytics1988
  • 13
  • 8
0
votes
1 answer

Filter rows in SLT

How to filter rows in SLT (SAP Landscape Transformation) The filter should be based on one column of the table. And only if a cell in this row has a specific content then the row should be replicated.
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
2 answers

How to create an INCLUDE program?

Working with SAP will eventually lead to use of includes (same as includes in PHP) When working e.g. with transformations (Transaction RSA1) you can use includes by using the include . You can create an INCLUDE with the same statement…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

SLT Can not activate configurations

In the SAP GUI, transaction LTRC: In SLT we have 3 configurations all are red / not activated. Activating all configurations does not change anything. Neither is it possible to activate a single configuration. Where can I get further information…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

How to detect / find out which SLT version is installed

In order to create another thread I would like to find out / verify which SLT (SAP Landscape Transformation Server) version is installed on our server. Can somebody describe the steps to find out the installed version? Thanks in advance.
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

SLT Transaction LTRS: Error: SQL0104N primary key

We try to create a replication with a view using SLT (SAP Landscape Transformation) Replication Server. Views need to be defined in LTRS !? When I try to make such a definition I get the error: SQL0104N An unexpected token ")" was found following…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

SLT Error: Replication not successfull: The migration object has been deleted and must be recreated

We try to build an SLT (SAP Landscape Transformation) Configuration which replicates one Table "new3_asdf" and one view on top of this table: new3_asdf_view_id. So in transaction LTRS I added the view to the table: In LTRC I added the table…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
1
2