SLT – Table Enhancement & Cluster Data Extraction

[satrajit_chatterjee]

What is SLT?

SLT stands for SAP Landscape Transformation Replication Server (SLT) running on the NetWeaver Platform. SLT is the ideal solution for all HANA customers who need real-time (and non-real-time) data replication sourcing from SAP ERP or non-SAP systems into HANA

Requirement

STXL table is available in ECC system. This is a BW object and having a cluster field. In HANA, we can not replicate the cluster field. To get those cluster data We have to enhance the STXL table with a new field / column and then populate the data with simple text format.

To Get Free HANA Clout system please have a look in this Vedio

Free SAP HANA Server Access in Cloud - YouTube

Step 1:

• Go to /LTRS transaction
• Go to Table Settings
• Add an new Table option
• Add STXL Table

Step 2:

• Add the name of the Table which you would like to add

Step 3:

• STXL will be added under Table settings folder
• Double click on the Table – A new window will be open as per the screen

Step 4:

• Go to Table Structure Tab
• You will find the current Table structure of STXL
• Last field ( line 9 ) is cluster field and data type is RAW.

Step 5:

• Select the last field / RAW field
• Remove That field by clicking the delete button at top

Step 6:

• Removed field will be added in right hand side(as shown in picture )

Step 7:

• Add new field with add button (as shown in picture ).

Step 8:

• Add other field as well (shown in picture ).

Step 9:

• Add other field as well (shown in picture ).
• Here We have added 3 more field as required

Step 10:

• Now you have to create the ABAP routine to Data conversion
• Go to SE38 to create a include program

Step 11:

• Please select Type as “Include Program”
• Status as “Client Production Program”
• Application is “Cross Component”
• Save the include program

Step 12:

• Open the include program is SE38
• Write the ABAP code
• One set of Code is attached. You  can take an reference

Step 13:

• Go to Rule assignment
• Right click and select ADD Table option
• Add the Table (STXL)
• It will display under rule assignment folder

Step 14:

• Please select STXL table
• Go to the Rule option at Top
• Select Event Based Rule and continue…

Step 15:

• Please select Begin of Record (BOR) option from the dropdown
• It means : The routine will trigger before the record replication

Step 16:

• New window will be open
• Please attached the “Include Program

Step 17:

• Insert Include name as shown in the picture
• Change Status field to “RELEASE”
• Save and activate

Step 18

• Go to LTRC T-Code to replicate the Field

Step 19

• Click on the Data Provisioning Button
• You will get Multiple option

Step 20

• Open  Data Provisioning window
• Select on start replication radio button
• Provide the Table name & Execute

Step 21

• Search for the Table in Replication window
• Check – whether it is schedule (as shown in the screen)

• Step 22

Open the Table from HANA Modeller perspective and check whether those field in the table is copied or not.

Please find the code attached here.

**&---------------------------------------------------------------------*

**&  Include          ZSLT_HANA_STXL_BOR_2

**&---------------------------------------------------------------------*

*--------------------------------------------------------------------*

* TR-DGWK900010 Created by - CSATRAJIT - 04-09-2015

*

*

*--------------------------------------------------------------------*

TYPES: BEGIN OF ty_stxl_raw,

         clustr TYPE stxl-clustr,

         clustd TYPE stxl-clustd,

       END OF ty_stxl_raw.

DATA: lt_stxl_raw TYPE STANDARD TABLE OF ty_stxl_raw,

      wa_stxl_raw TYPE ty_stxl_raw,

      lt_tline    TYPE STANDARD TABLE OF tline,

      wa_tline    TYPE tline,

      oref        TYPE REF TO cx_root.

**Filter out text records that we don't need

IF <wa_s_stxl>-tdobject = 'QMMA'

    AND <wa_s_stxl>-tdid = 'LTXT'

      AND <wa_s_stxl>-tdspras = 'E'

        AND <wa_s_stxl>-srtf2 = 0.

*          and <wa_s_stxl>-clustr < 5000.

** add check for deleted record

  IF <wa_s_stxl>-clustd IS NOT INITIAL.

** end change 05/13/2014

*Put Source fields into internal table for IMPORT statement to work on

    wa_stxl_raw-clustr = <wa_s_stxl>-clustr.

    wa_stxl_raw-clustd = <wa_s_stxl>-clustd.

    CLEAR lt_stxl_raw.

    APPEND wa_stxl_raw TO lt_stxl_raw.

    IF <wa_s_stxl>-clustr < 5000.

      TRY .

*        IMPORT tline = lt_tline FROM INTERNAL TABLE lt_stxl_raw.

          IMPORT tline = lt_tline

           FROM INTERNAL TABLE lt_stxl_raw

             ACCEPTING TRUNCATION

               IGNORING CONVERSION ERRORS.

          IF lt_tline IS NOT INITIAL.

*Only read first line of text

            READ TABLE lt_tline INTO wa_tline INDEX 1.

            IF sy-subrc = 0.

              <wa_r_stxl>-text = wa_tline-tdline.

              CLEAR: wa_tline.

              CLEAR: lt_tline.

            ENDIF.

          ENDIF.

        CATCH cx_root.

      ENDTRY.

    ENDIF.

  ENDIF.

* end change 05/13/2014

  <wa_r_stxl>-qmnum = <wa_s_stxl>-tdname+0(12).

  <wa_r_stxl>-fenum = <wa_s_stxl>-tdname+13(4).

ELSE.

  skip_record.

ENDIF.

Please let me know if you are facingany issue.