Creating a Dataset from SAP S/4HANA Data
You can import data into a dataset from SAP 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 importing the raw data, continue with data preparation before completing your dataset: About Adding Data to a Story.