SLT can perform a one-time data load of an application table in the source system. Alternatively, it can transfer a table as is, replicating all changes that are executed on records in this table.
Before an initial data load into SAP HANA starts, SLT creates the target table in SAP HANA. If the table already exists, the standard behavior is to drop the table in the target. Next, the reader modules are generated, and data is transferred from the source table to the target. Once all data is transferred, the initial load is complete.
If you stop the load of a table, even if it is already completed, SLT cleans up the generated function modules (reading modules). However, the table in the target system, and the data in it, remain.
In the transaction LTRC, open a configuration and choose Data Provisioning, which can be found on the Table Overview tab. Enter the table that you want to load, and select Start Load → Execute.
In transaction LTRC, on the Table Overview tab, the table is added with the current action: Load Table (No Replication). On the Data Transfer Monitor tab, if the Loaded checkbox is selected, then the data has been loaded completely to the target table.
Starting from DMIS2018 SP04 / DMIS2020 / S/4HANA 2020, the LTRC UI has been reworked (for all scenarios except BW PSA) as follows:
- The Administration Data tab has been redesigned.
- The Processing Steps tab has been removed. Respective functions were moved to the Expert Functions tab.
- The Table Overview and Data Transfer Monitor tabs have been merged into the Participating Objects tab.
- The Application Log tab has been redesigned.
- The Statistics tab has been redesigned. It now provides the initial load statistics (including history), the replication statistics, and the unprocessed logging table entries overview.
Overview
The LTRC UI has received several adaptions that improve the user experience. Various sections have been improved so that new and existing users can find information more quickly.
Minor Changes: The tab Processing Steps was removed and the functions from Processing Steps were moved to the tab Expert Functions. The tap Application Log was redesigned to provide a better user experience.
The tabs Table Overview and Data Transfer Monitor are now merged into the tab Participating Objects to connect related information and provide improved monitoring capabilities.
To start the load of a table on the reworked LTRC UI of our training landscape, follow the steps after the figure.
In the transaction LTRC , open a replication and choose Data Provisioning, which can be found at the top of the screen.
Enter the table that you want to load as Object Name. Select Analyze Actions. There are options to analyze, validate, schedule, or reset actions.
Then select Edit Action → Perform Initial Load → Confirm.
Check the info provided on the table that you want to load and select Validate Actions. Be sure that the listed objects are consistent.
Select Schedule Actions.
In transaction LTRC on the Participating Objects tab, the table is added with the current action: Initial Load (No Replication). Once the load is successfully executed, you can see the number of Initial Loaded objects increased by one unit.
In SAP HANA Studio, you can see that the target table was created with the same table structure as the source table.
The Data Preview shows the records that were transferred from the source table to the target.