Workflow to Import Transaction Data from SAP S/4HANA
- Open the model that will be updated.
- Select SAP S/4HANA as the data source.
- Choose the S/4HANA connection, or create a new connection.
- Copy a query from an existing model (which you can edit before saving), or create a new query. The query selects the specific SAP S/4HANA data you need for your model.
- Start the import and initial mapping process.
- Finish mapping the imported data to existing dimensions in the model.
- Use default values for dimensions such as audit and flow (there is no equivalent in S/4).
- Mapping Options: Do not convert the values by account type since the source value signs are import-ready. Fill empty cells with the "#" value.
- Cleanse your data and fix any mapping or data quality problems.
- Finish the import.