Skip to Content
Author's profile photo Tobias Koebler

How to adjust a target table during replication

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

Assigned Tags

      19 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Helpful INFO thanks For sharing.

      Author's profile photo Former Member
      Former Member

      Thanks for sharing!

      Author's profile photo Former Member
      Former Member

      Hi Tobias,

      What is the usecase for doing this ?

      Thanks & regards,

      Jomy

      Author's profile photo Tobias Koebler
      Tobias Koebler
      Blog 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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Tobias Koebler
      Tobias Koebler
      Blog 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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Tobias Koebler
      Tobias Koebler
      Blog 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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Tobias Koebler
      Tobias Koebler
      Blog 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

      Author's profile photo Christian Harrington
      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

      Author's profile photo Tobias Koebler
      Tobias Koebler
      Blog Post Author

      HI Chris,

      with SP6 this should work, if not - can you please open a ticket.

      With SP7 we have a report: IUUC_REPL_ADJUST_TARGET_TABLE

      Best,

      Tobias

      Author's profile photo SAP Basis Competency Center
      SAP Basis Competency Center

      Hi Tobias,

      Does the new field always gets added at the last position in HANA table structure despite giving a different position in SLT (LTRS)? Is there any other workaround?

      Thanks.

      Author's profile photo Matt Ellicott
      Matt Ellicott

      we're on SP07 and program IUCC_REPL_ADJUST_TARGET_TABLE does not exist, is this in a note?

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Viktor Vass
      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!

      Author's profile photo Siddharth Shah
      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

      Author's profile photo Benjamin LIgnereux
      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.