Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
tobias_koebler
Advisor
Advisor
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 typeHANA type
ACCPNVARCHAR
CDAYSMALLINT
CHARNVARCHAR
CLNTNVARCHAR
CUKYNVARCHAR
CURRDECIMAL
D16DDECIMAL
D16RVARBINARY
D16SVARBINARY
D34DDECIMAL
D34RVARBINARY
D34SVARBINARY
DATSNVARCHAR
DAYINTEGER
DECDECIMAL
FLTPDOUBLE
INT1SMALLINT
INT2SMALLINT
INT4INTEGER
INT8BIGINT
LANGNVARCHAR
MINSMALLINT
MONINTEGER
NUMCNVARCHAR
PRECDECIMAL
QUANDECIMAL
RAW or LRAW (length < 7.000)VARBINARY
RAW or LRAW (length >= 7.000)BLOB
RSTRBLOB
SECINTEGER
SRST (length < 7.000)VARBINARY
SRST (length >= 7.000)BLOB
SSTRNVARCHAR
STRGNCLOB
TIMSNVARCHAR
UNITNVARCHAR
UTCLBIGINT
UTCMBIGINT
UTCSBIGINT
VARC or LCHR (length < 7.000)NVARCHAR
VARC or LCHR (length >= 7.000)BLOB
WEEKINTEGER

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 :smile:

Best Regards,

Tobias

11 Comments