SAP data types
Process extractor determines the target type of an extracted field (this is the type that the field will have in extracted ARIS Process Mining source tables) from the internal ABAP data type of the field.
The internal ABAP data type of every field in the SAP system is specified in the INTTYPE field of the corresponding row of the DD03L table.
List of the mapping from internal ABAP data types to ARIS Process Mining data types.
Internal ABAP data type | ARIS Process Mining data type |
C | Text |
X | Text |
g | Text |
y | Text |
V | Text |
N | Text |
I | Long |
b | Long |
s | Long |
D | Text |
T | Text |
P | Double |
F | Double |
u | Text |
v | Text |
h | Text |
r | Text |
l | Text |
For descriptions of the internal ABAP types, please refer to the SAP documentation or the INTTYPE domain in the SAP Data Dictionary.
Some extracted fields may need to be converted to their intended data type in ARIS Process Mining using a transformation. For example, it is not possible to extract directly data into columns of type Timestamp. You must therefore use a transformation in ARIS Process Mining to convert a date (or a combination of a date and a time) to a Timestamp value.
to_timestamp(concat(`UDATE`,`UTIME`), 'yyyyMMddHHmmss')