Tobias Koebler

May 14, 2013 1 minute read

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.

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

11 Comments

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

Christian Schäfer

May 14, 2013 at 12:51 pm

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 🙂

Tobias Koebler

Blog Post Author

May 17, 2013 at 11:56 am

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

Hemanth Aluri

July 3, 2013 at 8:43 am

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,

shishupalreddy ramreddy

August 6, 2013 at 8:08 am

As always Very help full Information Tobias Thank you .

Shishupal .

Hemanth Aluri

September 12, 2013 at 7:39 pm

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,

Nilesh Pathak

August 27, 2015 at 11:10 pm

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

Nilesh Pathak

September 2, 2015 at 7:57 pm

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 !!

Former Member

October 19, 2015 at 8:54 am

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,

Pawel Mierski

January 12, 2016 at 9:20 pm

Hi Ozzie,

Did you solve your problem?

Former Member

February 24, 2017 at 9:37 am

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.

Pankaj Kedia

February 27, 2017 at 2:34 pm

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

How SLT is mapping data types

Assigned Tags