LTRS Settings for multiple tables in one go in SLT

Hello Guys,

This is my first blog !!

Coming straight to the point,

In SLT, it is quite cumbersome to add extra fields to tables or to do performance settings specially for large number of tables.

    <— To add or delete fields from replication                                                                                                     settings of a table

    <—- To assign rule to added fields to the table

In LTRS t-code we can change settings for particular tables to enhance the replication and these settings can be exported to a ZIP file and can be imported. By analyzing the format of these files and the strings of data inside I have developed a MACRO which will be helpful to add below mentioned three fields to desired tables with just few clicks and a simple import of the generated ZIP file.

YH_HANAUPDDATE  — SY-DATUM

YH_HANAUPDTSTAMP — SY-UZEIT

YH_HANAUPDTIME — CONCATENATE SY-DATUM SY-UZEIT

HOW it works:

Step 1: You need to put the table names and the number of columns to be replicated  in the column               “C” and “D” respectively of the file LTRS_Automation (Which can be changed of-course if you              wish to!)

Step 2: Click on the button named “Generate Data” which will generate the required  semi-colon                     separated data strings for the desired changes.

Step 3: Click on the Button labeled “Generate csv Files” which will copy all the  data generated in                   Step 2 to respective csv files (For this you will have to  change the source code for this button             and provide some appropriate path) Please note that these files needs to be created (Without               any data) with the mentioned names  beforehand.

Step 4: Save the file with the MACRO code and click on the button labeled  “Generate ZIP file”.
A zip file will be generated as per the edited path in the macro code.This zip file can be                        imported to any desired configuration to apply the changes.

The mechanism and logic is pretty simple, so you can also tweak it as per yourrequirements and note that with similar logic even performance settings and other settings under the LTRS can also be done for which you will need to create additional files with appropriate data and ZIP them all.

I am providing the link to the file with the MACRO code “LTRS_Automation” and all other settings files in which the data will be copied and saved to be ZIPED later. Download all these files to any location and change the file locations in the MACRO code accordingly wherever required( which can be done with developer mode in EXCEL)and feel free to post your queries if any doubts and suggest improvements if any.

Link to the files : https://drive.google.com/open?id=0B1TakIvgRauBZmllY09WbGIwemc

https://drive.google.com/open?id=0B1TakIvgRauBZmllY09WbGIwemc

ENJOY !