Skip to Content

Hi,

this blog post describe the steps to adjust the target table during the replication.

Some manuel steps are required.

DMIS 2011 SP7:

There are two options. The recommended approach is the execution of the program.

A.) Program with docu:

1.) Stop master job

2.) SE38 -> Execute programm and read docu to understand the settings: IUUC_REPL_ADJUST_TARGET_TABLE

3.) Restart master job

B.)Step-by-Step approach:

1.) Stop the master job for the configuration (via LTR or LTRC)

2.) Enter LTRS and add the new field and a rule if relevant. Save the settings.

3.) Execute Expert Function „Reset Status of Tables and Synonyms“ for the table.

4.) Delete the synonym table

a)   For 1:1 replication:

           – goto LTRC -> Tab “Table Overview” and copy the Logging Table      name

           – Replace the the first 0 of your logging table with S, e.g. /1CADMC/00001243 will become /1CADMC/S0001243

           – Enter SE11 and input the value (/1CADMC/S0001243) as database table and delete it.

b) for 1:N configurations

          – goto table IUUC_TAB_ID and filter on your mt id, table name, system_type = R and Ident_type = S

          – get the ident id

          – enter SE11 and inpit /1LT/*<ident> ; e.g. /1LT/*4587

          – search via F4 help and delete it

5.) Enter LTRC and navigate to tab Expert Functions and execute “Reset Replication      Object Definition”.

6.) Adjust the table on HANA with the new field (SQL statement alter table)

7.) Restart the master job for the configuration.

DMIS 2011 SP05:

1.) Stop the master job for the configuration (via LTR or LTRC)

2.) Enter IUUC_REPL_CONTENT and add the new field and a rule if relevant. Save the settings      and execute “Reset Migration Objects”.

3.) Enter SE16 and access table IUUC_TABLES.

     – Find your table and open the record

     – Clear the field ‘LCL TAB FOR RCV’, that signals the system that there is no target table           information and it will be created again. 

4.) Delete the synonym table -> goto LTRC -> Tab “Table Overview” and copy the Logging Table      name

5.) Replace the the first 0 of your logging table with S, e.g. /1CADMC/00001243 will      become /1CADMC/S0001243

6.) Enter SE11 and input the value as database table and delete it.

7.) Enter LTRC and navigate to tab Expert Functions and execute “Reset Replication      Object Definition”.

8.) Adjust the table on HANA with the new field (SQL statement alter table)

10.) Restart the master job for the configuration.

Best Regards,

Tobias

To report this post you need to login first.

19 Comments

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

    1. Tobias Koebler Post author

      Hi Jomy,

      I think this is a special case. Maybe you need a precalculated field and the calculation has to take place on the SLT system instead of the HANA system (for what ever reason).

      Best,

      Tobias

      (0) 
  1. Christina Halim

    Hi Tobias,

    I have a question, is it possible to replicate raw table to raw table? This is just as a test, not real business scenario. If it is possible, could you share how to achieve this? Thanks beforehand.

    Christina

    (0) 
    1. Tobias Koebler Post author

      Hi,

      what do you mean with raw table? Do you want a row store instead of a column store in HANA? If yes, this can be defined in LTRS -> table settings.

      Best,
      Tobias

      (0) 
      1. Christina Halim

        Hi Tobias,

        We have just installed our SLT but do not have a HANA system to connect to (yet .. in process, licenses were purchased), so we are thinking of testing the SLT functionality by replicating from SAP ABAP to another SAP ABAP, just a table that we created ourselves (example: ZUSER) … just to see if it is working. Is this even possible? Sorry .. I am new to this. Thanks for your help.

        Christina

        (0) 
        1. Tobias Koebler Post author

          Hi,

          yes you can. With DMIS SP06 ABAP to ABAP replication is available. Just define in LTR the configuration to an ABAP target via RFC. Important is that the target table already exists (ZUSER must be created in target as a table upfront). Also it is important that you write from the same client into the same client (client 123 to 123 or 222 to 222). If this is not possible you have to define a transformation rule that the mandt/client field will be changed to the target client. If not you will not see any data. I play to post a how to in the next weeks on this.

          Best,

          Tobias

          (0) 
          1. Christina Halim

            Hi Tobias,

            Thank you for replying so quickly .. do I need to use tcode IUUC_REPL_CONTENT to define which table need to be replicated? If you don’t mind .. what other setting do I need to replicate table to table?

            Thanks,

            Christina

            (0) 
          2. Christina Halim

            Hi Tobias,

            I manage to replicate data from z-table from 1 abap system to another abap system. When choosing Data Provisioning as Start Load, it completed successfully. However, when data provisioning is: start replication, it failed to replicate additional data from the table. Could you please advise? Maybe there is something that I forgot to do. Do I have to schedule replication of these tables: DD02L, DD02Tand DD08L beforehand?

            Thanks,

            Christina

            (0) 
            1. Tobias Koebler Post author

              Hi,

              when you choose load, it executes only one single initial load – no replication is executed afterwards.Choose replication (it is implied an initial load).

              Best,
              Tobias

              (0) 
  2. Christian Harrington

    Hi Tobias and all,

    We have this scenario where we added a calculated field on the SLT with LTRC. We don’t want to reload the table from the source system since it’s big but just get the new data to populate this new field. So we followed the procedure described here to adjust target table…without success.

    We are at DMIS 2011 SP6 with correction 20.

    For steps 5 and 6 mentioning to delete the “S” table, it’s not existing…is this on the SLT or source system? so we were not able to delete that table. We proceeded anyway with 7, 8 and 10 (was there a 9)? But on the SLT we got that error:

    SLT error.jpg

    The procedure is from 2013, maybe it should be adjusted? any new recommendation?

    Thanks

    Christian

    (0) 
  3. Amir Dror

    Hi Tabias,

    I just watched the recording from SLT TechEd Lecture – DMM108 and in minute 23 it was explained that there is a note that after implementing it the changes of the source table are reflected automatically in the target table.

    1. What is the note you are refering to?

    2. Whats the different between this note and running the program IUCC_REPL_ADJUST_TARGET_TABLE?

    Thanks,

    Amir

    (0) 
    1. Viktor Vass

      Dear Amir,

      Were you able to find the SNOTE mentioned in the DMM108 session? Could you please share the SAP Note number?

      Thanks in advance!

      (0) 
  4. Siddharth Shah

    Hi Tobias,

    I am trying to replicate table from source to target where my source table has different structure then target. I am using table settings for field mapping but I am unable to see table structure tab under table settings. All I can see is only table settings where I can give source table name and target table name. Can you please help if I am missing any particular note or authorization to see hidden tabs?

    We are on DMIS 2011_1_731 0011 SAPK-11611INDMIS DMIS 2011_1

    Thanks,
    Siddharth

    (0) 
  5. Benjamin LIgnereux

    Hello Tobias,

     

    We have a DMIS 10 in ECC.

    After the replication of a table, we need to add another field at the end of the structure.

    I first tried the IUUC_REPL_ADJUST_TARGET_TABLE program. No result.

    Then I tried the step by step approch (B), but as soon as I added the column in LTRS, the table is not anymore available in eclipse (hana studio) and the ‘alter’ command returns the error “Could not execute ‘alter table … SAP DBTech JDBC: [259]: invalid table name:….”

     

    Then when I reactivate the connexion, I get back the table in eclipse with the new column but all the data left.

    Can you help me please to recover the data ?

    Thank you in advance.

    (0) 

Leave a Reply