Conversion for Data Types and Advanced Scripting Types
The data types are converted to the advanced scripting types in the rules Advanced Editor.
When you define your parameters and choose a data type, you're choosing an SAP Data Intelligence data type. When you define your conditions and filters and then run the rule, the Data Intelligence data type you defined for the parameter is converted to a scripting type in the background.
When you use the rules Advanced Editor, choose the advanced scripting data types.
|
SAP Data Intelligence Data Type |
Advanced Scripting Type |
Supported in SAP Data Intelligence Rules |
|---|---|---|
|
Boolean |
int*1 |
Yes |
|
Date |
date |
Yes |
|
DateTime |
datetime |
Yes |
|
Decimal |
decimal, numeric |
Yes |
|
Float |
double, real |
Yes |
|
Integer |
int |
Yes |
|
String |
varchar |
Yes |
|
Time |
time |
Yes |
|
N/A |
interval |
No |
|
N/A |
timestamp |
No |
1 * int is used with true=1 and false=0