Importing S/4HANA Data to a New or Existing Model
You can create a connection that lets you import data from S/4HANA using generic OData services.
Prerequisites
You are using a supported version of SAP S/4HANA. For more information, see System Requirements and Technical Prerequisites.
Context
-
SAP Analytics Cloud supports OData Version 4.0. Logical Operators (such as Equal, Not Equal, Less or Equal, Greater than, Greater than or Equal, Less than, Less than or equal, Logical and, Logical or, Startswith, and substringof) are supported for S/4HANA. Not logical negation, arithmetic operators, or functions are not supported. The following table lists the minimum requirements for S/4HANA OData services:
Data Type
Operator
Format
String (Edm.String) "eq", "ne", "startswith", "toLower","substringof", "gt", "ge", "lt", "le", "eq", "ne"
"eq", "ne", "startswith", "toLower","substringof", "gt", "ge", "lt", "le", "eq", "ne"
Number (Edm.Decimal) "gt", "ge", "lt", "le", "eq", "ne", "M"
[value] m
Number (Edm.Double) "gt", "ge", "lt", "le", "eq", "ne", "d"
[value] d
Number (Edm.Single) "gt", "ge", "lt", "le", "eq", "ne", "f"
[value] f
Number (Edm.Int16) "gt", "ge", "lt", "le", "eq", "ne"
Number (Edm.Int32) "gt", "ge", "lt", "le", "eq", "ne"
Number (Edm.Int64) "gt", "ge", "lt", "le", "eq", "ne", "L"
[value] L
Datetime (Edm.DataTime) "gt", "ge", "lt", "le", "eq", "ne"
Datetime (Edm. DataTimeOffset) "gt", "ge", "lt", "le", "eq", "ne"
Boolean (Edm.Boolean) "eq", "ne"
True|False
Edm.Guid "eq", "ne"
guid'[value]'
Logical Operator "and", "or"
- Embedded Complex types are not supported.
Procedure
Next Steps
After the initial import of raw data, continue with the data preparation task before completing your model: Preparing Data.