Based on the large number of possible UD Connect sources, the most diverse data types are possible in the output system. For this reason, a compatibility check is made at the time of generation of the UD Connect DataSource that is based on the type information supplied by the source systems. This attempts to decrease the probability of errors during the extraction process.
Following data type assignments are permitted:
Data Type in SAP NetWeaver BW | Data Type in the UD Connect Source |
---|---|
ACCP |
C |
CHAR |
All except X and b |
CUKY |
C |
CURR |
P, I |
DATS |
D, g |
DEC |
P, I |
FLTP |
F, I |
INT1 |
B |
INT2 |
S |
INT4 |
I |
LCHR |
G, V |
NUMC |
I |
PREC |
b |
QUAN |
I, P |
SSTR |
C |
STRG |
g |
TIMS |
T |
VARC |
All except X, P, F |
UNIT |
C, g |
Abbreviations for the data types of UD Connect sources:
C - character
X - hexadecimal
P - packed decimal, decimal
I - integer
n - numeric string
D - date
b - tiny int
g, G - long string
F - float
s - small int
V - variable character
T - time