Skip to Content
Author's profile photo Tobias Koebler

How SLT is mapping data types

Hi,
in this blog I would like to give more insight in the type mapping of SLT. In general every data type from a source system has to be mapped to the corresponding HANA type. There is a default mapping in SLT established that are based on the SAP standard mapping.
The following table illustrates the standard DDIC to HANA mapping.
DDIC type HANA type
ACCP NVARCHAR
CDAY SMALLINT
CHAR NVARCHAR
CLNT NVARCHAR
CUKY NVARCHAR
CURR DECIMAL
D16D DECIMAL
D16R VARBINARY
D16S VARBINARY
D34D DECIMAL
D34R VARBINARY
D34S VARBINARY
DATS NVARCHAR
DAY INTEGER
DEC DECIMAL
FLTP DOUBLE
INT1 SMALLINT
INT2 SMALLINT
INT4 INTEGER
INT8 BIGINT
LANG NVARCHAR
MIN SMALLINT
MON INTEGER
NUMC NVARCHAR
PREC DECIMAL
QUAN DECIMAL
RAW or LRAW (length < 7.000) VARBINARY
RAW or LRAW (length >= 7.000) BLOB
RSTR BLOB
SEC INTEGER
SRST (length < 7.000) VARBINARY
SRST (length >= 7.000) BLOB
SSTR NVARCHAR
STRG NCLOB
TIMS NVARCHAR
UNIT NVARCHAR
UTCL BIGINT
UTCM BIGINT
UTCS BIGINT
VARC or LCHR (length < 7.000) NVARCHAR
VARC or LCHR (length >= 7.000) BLOB
WEEK INTEGER

For those of you what would like to see this resprented in the coding, have a look at the ABAP include SDB2FIUC on the SLT system.

What to do to change the standard mapping?

a.) For the complete configuration

The default type mapping can be redefined for each configuration. The individual type mapping can be defined in table IUUC_REPL_TYPMAP and will affect all tables of the corresponding configuration. For those data types where no individual type mapping is defined, the default mapping will be used.

Mapping.jpg

b.) For only one field of a table wihtin your configuration

In order to have the function available, entries in tables IUUC_REPL_TABSTG and IUUC_REPL_TAB_DV needed.

1.) IUUC_REPL_TABSTG – For the desired table, field TABLE_DEVIATION must be set to TRUE.

2.) IUUC_REPL_TAB_DV – Fields to deviate from the original source table need to be inserted in this table.

Any feedback and questions are welcome 🙂

Best Regards,

Tobias

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Christian Schäfer
      Christian Schäfer

      Hello Tobias Koebler, thank you for these Informations.

      Please add the Information, that in DMIS 2011 SP04 you can edit the mapping rules for each table in IUUC_REPL_TYPRED.

      Can you please add a tutorial with an example ?

      In our case we have a Table with a Column with Type Datetime in MSSQL and we want to have Timestamp in SAP HANA. Further more we have in this Table a varchar(3000) and we want to have varchar(3000) in SAP HANA. I want to to have an similar Typemap from MSSQL to SAP HANA so we don't need to convert the replicated data again in HANA.

      thx for your great help 🙂

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

      Thanks,

      I will work on an example and more details also for the table IUUC_REPL_TYPRED you mentioned above. Give me some days and I will post more details here.

      Best,

      Tobias

      Author's profile photo Hemanth Aluri
      Hemanth Aluri

      Hi Tobias,

      I have lots of questions on configuration a). I have posted a thread below. Could you please provide me your inputs ?

      http://scn.sap.com/thread/3384902

      Regards,

      HA

      Author's profile photo shishupalreddy ramreddy
      shishupalreddy ramreddy

      As always Very help full Information Tobias Thank you .

      Shishupal .

      Author's profile photo Hemanth Aluri
      Hemanth Aluri

      Hello Tobias,

      Did you get a chance to Look at the Table - IUUC_REPL_TYPRED.

      Can I derive the Data type defintion IUUC_REPL_TYPMAP (Replication: Type Mapping) for a particular table ?

      Thanks,

      HA

      Author's profile photo Nilesh Pathak
      Nilesh Pathak

      hi Tobias,

      one quick question for SLT SP9 - I need to add new field of date/time stamp to the table that we plan to replicate from ecc and send it to ORACLE DB.

      What would be the mapping for this , do we need to maintain table as well for the same as oracle has different format for date.

      Please advice on this - would be great for us.

      regards

      Author's profile photo Nilesh Pathak
      Nilesh Pathak

      hi Tobias,

      Can you please comfirm how this will be in case of SLT oracle scenario where oracle is end system. Any mapping details please that can be used as at the minute we are unable to replicate table with append field in ORacle. thanks for help !!

      Author's profile photo Former Member
      Former Member

      Hello,

      We are using SLT SP8 and replicating to an SQL server target database, we have updated the table IUUC_REPL_TYPMAP with data mapping but replicated tables do not have updated data types. Are there any other steps that need to be completed fo this to work?


      Regards,

      Author's profile photo Pawel Mierski
      Pawel Mierski

      Hi Ozzie,

      Did you solve your problem?

      Author's profile photo Former Member
      Former Member

      Hi Tobias,

      this is a realy good introduction in type mapping, thank you for that.

      But I have another problem now. I mapped DATS to DATE and TIMS to TIME. The SLT creates the table on my HANA database and sets for example:

      "XY_DATE"  DATE       DEFAULT '00000000' NOT NULL

      This is a small part  of the SLT SQL create statement simulation. During the initial load, the SLT can't insert records which are NULL and returns Error.

      My question is: Is there a way to manipulate the create statement of the SLT or another way to solve this problem? Thank you.

       

      Author's profile photo Pankaj Kedia
      Pankaj Kedia

      Hello Tobias,

       

      I am trying to replicate the DECIMAL(15) ABAP data type to HANA via SLT. In the target HANA system, I want the data type as TIMESTAMP (since it is a timestamp data stored as decimal in the source system).

       

      I tried all the above mentioned steps, no luck.

       

      I need to make this change only on 1 table out of many tables in the configuration.

       

      I made the desired changes in the below tables as you have mentioned –

      1.) IUUC_REPL_TABSTG – For the desired table, field TABLE_DEVIATION must be set to TRUE.

      2.) IUUC_REPL_TAB_DV – Fields to deviate from the original source table need to be inserted in this table.

       

      Once I make the above changes, the data is not getting replicated at all.

       

      Request your help in this regard.

       

      Regards,

      Pankaj Kedia