ECC DATS to HANA Date transformation

[Former Member]

Hello,

I'm trying to change the data type of ECC source table (DATS) to HANA SQL type DATE. I have gone through numerous posts on SDN and decided that we don't want to do the master setting in table IUUC_REPL_TYPMAP to avoid all the dates to transform into DATE...based on following posts.

http://scn.sap.com/community/replication-server/blog/2013/05/14/how-slt-is-mapping-data-types

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

1. I tried changing the data type in IUUC_REPL_TABSTG directly in "Edit table structure" but it didn't work. I changed DATS to DATE in lower bottom and clicked on "Calculate new structure". I also tried writing the abap include and assigning a DATS type value into result structure.

2. I also tried directly entering mapping in IUUC_REPL_TYPMAP as "DATS" to "DATE". but unfortunately, this one didn't work either.

We are on DMIS 2011 SP5 and HANA SPS06 rev 61.

Also read about table - IUUC_REPL_TYPRED to maintain field level data type mapping; but there is absolutely no documentation/help on this.

Thanks.

Abhijeet

[Former Member]

Update 12/30:

I was able to make the global setting work with mapping table IUUC_REPL_TYPMAP.

But unfortunately, for blank dates, its just filtering out records; so it may not be a good option. I have decided to create calculated columns in HANA as a workaround.

[Former Member]

Hi Abhijeet,

It never excluded records for me but the replication failed whenever it finds records with empty dates and hence we needed to write small piece of code which defaulted date to 000000 instead of blank ones.

Thanks & regards,

Jomy

[Former Member]

Hello,

         What was the issue we are currently not able to get this to work with SQL server as a target database.

Regards,