Use only the compatible flat SAP OData V4 data types in mappings, dynamic mapping tasks, and mapping tasks to read from SAP Datasphere and SAP S/4HANA applications, or write to SAP S/4HANA applications.
The following table lists the flat SAP OData V4 data types that you can use with SAP OData V4 Connector, along with the corresponding transformation data types when you read from SAP Datasphere applications:
SAP OData V4 Data Type
Transformation Data Type
Edm.Binary
Binary
Edm.Boolean
String
Edm.Date
Date/Time
Edm.DateTimeOffset
Date/Time
Edm.Decimal
Decimal
Edm.Double
Double
Edm.Int32
Integer
Edm.Int64
Bigint
Edm.Single
Double
Edm.String
String
Edm.TimeOfDay
Date/Time
The following table lists the flat SAP OData V4 data types that you can use with SAP OData V4 Connector, along with the corresponding transformation data types when you read from or write to SAP S/4HANA applications: