In the SAP HANA database, data often has the format integer (INT4, INT8, DEC). To allow this data to be accessed from the BW system or to be loaded, it must be converted to another format. You can use conversion routine SNUMC to do this.
More information: Conversion Routines in the BW System
You need this conversion for example if you want to use an Open ODS view to access a table or a view in SAP HANA or if you load data into the BW system using a SAP HANA DataSource.
SAP HANA data type |
DDIC data type |
Internal length |
Output length (InfoObject maintenance) |
Externe length (SAP HANA DataSource, Open ODS view) |
Comment |
---|---|---|---|---|---|
INTEGER |
INT4 |
11 |
14 |
11 |
|
BIGINT |
INT8 |
20 |
26 |
20 |
|
DECIMAL(p,0) (p <= 31) |
DEC(n,0) |
p+1 [2,32] |
( 4 * (p+1) -2 ) DIV 3 |
Same as the internal length |
- Fractional units are not supported - Maximum length in the DDIC: 31 |