Explore the different datatype to catalog datatype mappings available for the SAP S/4HANA datasource.
The tables lists the mapping from datatype to catalog datatype for datasource, making
data management simpler and more organized.
| Datatype | Catalog datatype |
|---|---|
| undefined | string |
| date | date |
| date_date | date |
| date_day_of_month | integer |
| date_day_of_week | string |
| date_day_of_week_index | integer |
| date_day_of_year | integer |
| date_fiscal_month_num | integer |
| date_fiscal_quarter | integer |
| date_fiscal_quarter_of_year | integer |
| date_fiscal_year | integer |
| date_hour | integer |
| date_hour_of_day | integer |
| date_microsecond | integer |
| date_millisecond | integer |
| date_minute | integer |
| date_month | integer |
| date_month_name | string |
| date_month_num | integer |
| date_quarter | integer |
| date_quarter_of_year | integer |
| date_raw | date |
| date_second | integer |
| date_time | datetime |
| date_time_of_day | datetime |
| date_week | integer |
| date_week_of_year | integer |
| date_year | integer |
| distance | decimal |
| duration | datetime |
| duration_day | integer |
| duration_hour | integer |
| duration_minute | integer |
| duration_month | integer |
| duration_quarter | integer |
| duration_second | integer |
| duration_week | integer |
| duration_year | integer |
| int | integer |
| location | string |
| number | decimal |
| string | string |
| tier | string |
| time | time |
| unquoted | integer |
| yesno | string |
| zipcode | string |
| date_hourX | integer |
| date_millisecondX | integer |
| date_minuteX | integer |