Skip to Content

Hi All,

This document is all about SAP ECC and SAP HANA Integration using SLT  ( Data Provisioning Technique ).

In this document I am demonstrating the procedure to configure SLT and then testing the configuration by creating Purchase Order in SAP ECC and see its reflection in SAP HANA which is near real-time replication.

Addition to this I have covered procedural steps of some activity which we may have to carry out if in case  ECC and HANA environment is not completely ready for establishing SLT configuration  and in case of few possible errors that usually comes in creation of  SLT configuration .

Sequence of flow of the document would be as follows –

I. How To Create RFC Connection which is used in SLT Configuration.

II. Step-by-Step Procedure to configure SLT for Data Replication from SAP ECC System to SAP HANA system.

III. How to delete entries from ECC tables for eliminating Error in SLT Configuration Scenario.

I. Creation of RFC Connection – While configuring SLT in LTR Transaction we need to pass RFC connection. In case their is no suitable RFC Connection available or their is issue with existing RFC Connections, we can easily create RFC Connection to meet our requirement  as follows –

  1. In ECC System go to transaction SM59 and click on New

sm59 tcode1.PNG

    2 .    Fill in highlighted fileds and press Enter.

/wp-content/uploads/2015/04/wfwqeqwe_688898.jpg

where as, choose Connection Type – 3 ( ABAP Connection)

3 . Under Technical Settings tab give TargetHost and System Number

rfc connection1.png

So target Hostname is nothing but message server address of your ECC system which you can find out in rz10 Transaction

rz10 tcode.png

Enter the name of the system profile,

Select latest version of the profile.

Click on display so you will find SAP System number and mshost id as mentioned below.

rz10 t.png

rz10 t1.1.png

So after getting this values ,

in Target Host enter your rdisp / mshost id i.e. ‘EHP7’and in System number enter SAPSYSTEM value i.e. ’07’ and than click on Enter, after that Target Host-name will appear and IP address associated to that mshost under IP Address Field will appear.

4 .  Under Logon Security tab fill in required fields and press Enter.

rfc connection2.png

5 .Now click on Save . Hence RFC Connection with name ECC_SLT_HANA is created.

rfc connection3.png

6. To test the conncetion click on Connention Test

rfc connection test1.png

If RFC connection is created successfully below sceen will appear

rfc connection test2.png

II . SLT Configuration Steps.

1. In ECC goto tcode- LTR , It will open a webdynpro screeen.

ltr tcode.png

2. Enter ECC credentials and then click on Log On.

ltr login screen.png

3. Configuration and monitoring dashboard for HANA screen will appear.

slt frst screen.png

Click on New which will pop up Create a New Configuration Window.

4. New configuration screen will appear fill in the required fileds and click on OK.

creation of slt configuration.png

Note : Configuration Name will be the name of the schema in HANA studio where SAP ECC tables will be replicated.

If any schema with specified Configuration name already exist then same schema will be used else new schema will be created.

RFC Destination – Choose the RFC Connection which is being created i.e. ECC_SLT_HANA .

Provide HANA System credentials to which we need to establish connection.

Specify Number of Data Transfer Jobs and Calculation Jobs according to availability of Jobs.

Note : You may specify the number of jobs in LTRC transaction.

5.  Connection is created with name – SYN_SLT_HANA. click on configuration name.

creation of slt configuration1.png

Note: At a time there can be only one configuration.

6. On this popped up window we get the status of created configuration.

created config.png

we can find the Status as Running that means SLT configuration is completed at this point.

7 . Go to HANA studio

hana studio slt1.png

In HANA Studio under SAP HANA Modeler Perspective

click on Data Provisioning.

Data Provisioning window pops up,

Select HANA system and click on Finish.

8. SLT overview screen appears

hana studio slt5.png

As the SLT gets configured 3 ECC system tables DD02L, DD02T and DD08L gets replicated in HANA system.

These are the tables which stores meta data of ECC tables.

Auto-Created Schema in HANA System as below.

hana studio slt4.png

9.  For Loading ECC tables into HANA System

loading table.png

Click on Load then Load window pops up.

Select Table say LFA1 from Source Tables section and click on Add, table gets reflected in Selected tables section.

click on Finish.

10. LFA1 table gets scheduled for load operation

load table1.png

11.  Now to Replicate transactional table say Purchase Order header and line item tables.

replicated table1.png

Click on Replicate , Replicate window pops up

Select EKKO and EKPO tables from Source Tables section and Add them in Selected Section

Click on Finish.

12. So the EKKO And EKPO tables gets scheduled for replication.

replicated table2.png

13. After the tables get scheduled initially the tables get loaded with status executed .

executed state.png

14.  the tables which is being replicated gets new status as ‘In Process’

replication state.png

Note :  The loading / replicating  table’s change of status from Scheduled to Execute and then In Process may take longer time may be more than half an hour.

            In this case we may suspend the replication tables which are already having status as ‘In Process’ however this may not be a best practice.

15. Now to see replication lets create an entry in ECC tables, go to transaction me21n to create Purchase Order

me21n tcode.png

16 . Created Purchase Order

/wp-content/uploads/2015/04/po2_688926.png

/wp-content/uploads/2015/04/po1_688927.png

17 . Reflection of above created PO in HANA system, EKKO table

/wp-content/uploads/2015/04/ekko_688928.png

18.  Reflection of above created PO in HANA system, EKPO table

/wp-content/uploads/2015/04/ekpo_688929.png

III. Error in SLT Configuration Scenario –  When you have deleted existing configuration and you are trying to create new configuration the error pops up saying ‘Not all configurations could be loaded due to data inconsistencies‘ and ‘Source System is already used in different Configuration’.

What happens is, though  you have deleted configuration in LTR transaction still System maintains some records related to deleted configuration in some IUUC* tables so we need to delete those entries from the tables.

Tables from which we need to delete entries are as follows –

IUUC_REPL_MAP

IUUC_MT_HEADER

IUUC_REPL_CONPAR

IUUC_REPL_HDR

Steps to delete entries from ECC Tables are as follows –

1. Go to Transaction SE16 and give table name and click on data preview

/wp-content/uploads/2015/04/se16_688930.png

2 .click on Execute , whole data in the table will be displayed.

/wp-content/uploads/2015/04/se16_1_687917.png

3. Select the record and click on display

/wp-content/uploads/2015/04/se16_2_687926.png

4. To switch on debugging mode write /h and click enter.

/wp-content/uploads/2015/04/se16_3_687927.png

/wp-content/uploads/2015/04/se16_4_687928.png

5. Click Enter again you will land up in ABAP Debugger

/wp-content/uploads/2015/04/se16_5_687945.png

On this screen click on code, so you will get code in variable column under Variable 1 tab, than press on Edit icon.

6. Replace ‘SHOW’ with ‘DELE’ and press enter and than press F8

/wp-content/uploads/2015/04/se16_6_687946.png

7 . So we will get Delete Entry push button through which we can delete records from table.

/wp-content/uploads/2015/04/se16_7_687953.png

By using this procedure  have to delete all the records from above mentioned 4 tables.

Hence, this way we can eliminate those errors.

Regards,

Danish

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. vivek singh

    Hello Danish,

    Nice document, I have a question, in this case ECC would be on Oracle ?

    I have a landscape where I am doing reporting in BOBJ explorer using HANA live views, our DB has completely migrated to HANA, in this case Do I still need SLT to refresh data in HANA Studio ECC tables ?

    (0) 
  2. Naveen M

    Hi Danish,

    Thank you for such a nice document. I followed the same steps as mentioned in this document.

    But i am getting below error in step 5.

    I checked the document https://help.sap.com/hana/SAP_HANA_Security_Guide_Trigger_Based_Replication_SLT_en.pdf

    and provided all the privileges as mentioned in that document to my database user.

    I am using a database user “NAVEEN”. Could you please let me know if i have to provide any other privileges.

    Thank you,

    Navn

    (0) 
    1. Prem Kumar Maharajan

      Hi Naveen,

          It looks like the database user “NAVEEN” is missing object privileges at schema level. Please check the authorization at HANA side for schema Z_N_SHM10.

      Regards,

      Prem Kumar M

      (0) 
  3. Dheen AJ

    Thanks for the clear document.

    Can you explain if SLT is installed in same source system what is the configuration to be followed?

    (0) 
    1. Ted Kwon

      Same configuration is needed as above.

      – RFC connection with source ABAP system

      – DB connection with target HANA system

      (0) 
  4. Suraj Kant

    Hi Danish,

    Really appreciate your effort.

    A small doubt, Can multiple SLT Configurations be done in LTR Tcode , with different names and different sets of tables for replication under it, which could result in multiple Schema in HANA Studio ??

    Need valuable suggestion ..

    Regards,

    Suraj Kant

    (0) 
    1. Amar Ghuge

      Hello Suraj,

      that is right no of the the connections created in SLT do have the indicidual schemas in HANA system unless during the replication configuration you intentionally give the same schema name which is already existing,.

      amar ghuge

      (0) 
  5. Ted Kwon

    Excellent Blog,

    It is one of best post in regarding SLT configuration, particularly detailed touch in potential and practical trouble shooting topics.

    – easy to understand ‘End to End Scenario’

    – never missed ‘sensitive check and setting in ECC’ such as SM59, RZ10

    (1) 
  6. Thomas Taylor

    Does anyone have step-by-step document for changing the SYSTEM user id to a different userid on existing SLT DB Connection?

    I think it is using DBCO -TX

    Thanks,

    Tom T

    (0) 
  7. Amoroso Angelo

     

    Hello Danish,

    Nice document, I have a question for you:

    I have a customer with an SAP ECC landscape where there are two company codes, The company of one of the two company codes has been soldĀ and will have to migrate its data into a new ERP. The solution I wanted to propose is adopt SLTĀ but I have a doubt if it is usable when the source is SAP ECC and the target is SAP S/4 HANA.

     

    Thanks in advance for th support!

     

    Best Regards

    Angelo

    (0) 

Leave a Reply