Skip to Content
avatar image
Former Member

SLT Replication - BSEG and BKPF tables

Hello team

My DMIS version is as below, so please check on my points/questions accordingly and help me to understand on that.

Please check and help me to understand the below points

1. I have created configuration and loaded KNA1 table from ECC system to HANA system. It is successfully loaded. I have checked SM37 in SLT server for job details, i am not able to find any job created for this run and parallely i checked in hana studion-->dataprovisioning-->jobs, here also i am not finding any job created for that loading of KNA1 from ECC to HANA system.

So now i want to know where can i see the jobs created in background to load KNA1 data into HANA because i want to measure the time taken for loading KNA1 data into HANA. please check and help me to get the job details, do i need to check SM37 in ECC system, please clarify. In the meantime, please tell me where can i get complete statistics of TIME taken to load KNA1 data into HANA from ECC system.

2. I want to replicate BSEG and BKPF table from ECC to HANA system. so please check and suggest me on the below points.

a) Do i need to do any additional settings to replicate these two BSEG and BKPF tables because these tables are cluster tables and these tables are having huge amount of data in it.

b) I had see a blog from Tobias Koebler on "

How To filter on the initial load & parallelize replication DMIS 2011 SP06 or higher", please check and suggest me whether i need to follow these steps for replicating BSEG and BKPF tables. please clarify.

c) i want to keep filter on BKPF table and i want to extract data from BKPF and BSEG tables based on those filters. normally in abap we join these two tables by using inner join and in where condition we will put the filters. so now i want to know how i can join these two tables BSEG and BKPF tables while replicating because i dont want to extract all data. Based on the filters of one table lets say BKPF and the for that filtered data i want to extract BSEG data or vise-verse. please check and suggest me how to put the inner join for these two tables in SLT replication.

Additional inputs are welcome.

Thanks and Regards

Raj

dmis.PNG (15.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 03, 2015 at 11:38 PM

    Raj

    Find my Responses

    1. I have created configuration and loaded KNA1 table from ECC system to HANA system. It is successfully loaded. I have checked SM37 in SLT server for job details, i am not able to find any job created for this run and parallely i checked in hana studion-->dataprovisioning-->jobs, here also i am not finding any job created for that loading of KNA1 from ECC to HANA system.

    So now i want to know where can i see the jobs created in background to load KNA1 data into HANA because i want to measure the time taken for loading KNA1 data into HANA. please check and help me to get the job details, do i need to check SM37 in ECC system, please clarify. In the meantime, please tell me where can i get complete statistics of TIME taken to load KNA1 data into HANA from ECC system.

    Response:

    1. 1. First check if Logging table is created in the source system and also on the Target system. Also check the Current Action of the Table from T Code LTRC à Table Overview.

    You will see something like that

    DD02L /1CADMC/00000501 Replication TRANSP X Activated Table created Table created Synonym created

    If you see the replication status has initial load, then the data is still loading from Source to Target system. You can check the status of load from Load Statistics tab. In the selection select “Load in process” and check if you see the records. If you Refresh then you see the records are being calculated and read.

    If the above steps does not work, then you can check the Jobs from Sm37. You will see jobs like this

    /1LT/IUC_LOAD_MT_016_010 SAPBASIS Active 02/03/2015 00:00:14 63,019

    /1LT/IUC_REP_MSTR SAPBASIS Active 02/03/2015 00:00:05 63,028

    IUC_LOAD_MT are the Data Transfer jobs used to transfer the data between the systems. IUC_REP_MSTR is the master job which controls all the SLT jobs in the system. If you don’t see any Jobs in SM37, then the master job must have stopped.

    1. Go to LTRC à Administration Data à Check Configuration Status. It should be running and if it is stopped, start the configuration. Once it is started, you should see the Jobs in SM37.

    Check and let me know these things

    1. 2. I want to replicate BSEG and BKPF table from ECC to HANA system. so please check and suggest me on the below points.

    a) Do i need to do any additional settings to replicate these two BSEG and BKPF tables because these tables are cluster tables and these tables are having huge amount of data in it.

    Response

    If you would like to replicate normally with single threaded, then you don’t need additional settings. But if you would like to use Parallelization from Tobias Blog, then you need to make some changes to tables before you start the replication.

    b) I had see a blog from Tobias Koebler on "How To filter on the initial load & parallelize replication DMIS 2011 SP06 or higher", please check and suggest me whether i need to follow these steps for replicating BSEG and BKPF tables. please clarify.

    Response


    Tobias has written a very good blow on improving the initial load for large tables. You can use this for both cluster and transparent tables. I have implemented this in our landscape and working well. Check this Link

    http://scn.sap.com/community/replication-server/blog/2013/09/26/how-to-improve-the-initial-load-by-row-id-approach

    If you need any help with the Parallel replication let me know.


    Mahesh Shetty


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I will reply to some of your queries-

      1. yes the records which get created after your initial load would be considered as delta.

      2. for knowing the logging table, login to your slt system - > ltrc tcode -> table overview tab->you can see the logging table name created for your corresponding source table.

      3. no other setting is required for starting the replicate.

      4. LTRC tcode- "table overview tab"- > "data provisioning" icon is present at the top.

      Please refer to the Application Operations guide available on help for any more queries.Moreover next to the data provisioning icon there is a small "I" icon which contains detailed documentation. Have a look at it.

      Hope this helps.

      Regards,

      Saritha K

  • avatar image
    Former Member
    Feb 02, 2015 at 01:16 PM

    Hi,

    I will answer to some extent -

    1. By default in SM37, there would be few LOAD JOBS running- starting IUC_LOAD* which takes care of your tables replication.

    Initially there would be some calculation jobs *CALC* also running prior to it.

    2. For knowing the statistics of your table, go to tcode- LTRC - load statistics tab.

    3. FOR BSEG and BKPF, you could set up your configuration as PERFORMANCE OPTIMISED(LTR code)

    4. replication takes place for tables individually. So I don't think inner join concept works over here.

    Regards,

    Saritha K

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Saritha

      Thanks for your reply.

      1. SM37 --> i think it is in SLT server only right. so you mean IUC_LOAD* jobs are used for replicaiton and what is the use of *CALC* jobs. so we will not have a individual job for one replication, am i right?

      2. i want to know how much time taken for one table replication. so you mean i can get this statistics in LTRC-->statistics tab.

      3. if i select perfomance optimzed option in my configuraiton , wil it take care of everything, i mean loading of huge tables without having performance issues.

      4. i am cleared here, so i need to extract full data right.

      Regards

      Raj

  • Sep 10, 2015 at 02:55 AM

    Hi,

    I was wondering how do you know the access plan id is 00001? I see my system generates two access plans in access plan head table 00001, 00010; do we need to provide filter for 00010 too? it looks like the access plans are generated at runtime, how could i customizing can know how many access plans i will get beforehand?

    also what is the difference between standard access plan and collective access plan? thanks
    !

    NBIll

    Add comment
    10|10000 characters needed characters exceeded