How SLT is mapping data types
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
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 🙂
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
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
As always Very help full Information Tobias Thank you .
Shishupal .
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
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
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 !!
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,
Hi Ozzie,
Did you solve your problem?
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.
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