Icon

14_​Theobald_​meets_​SAP_​HANA

There has been no title set for this workflow's metadata.

Will They Blend: SAP Theobald meets SAP Hana

This workflow calculates various Key Perfomance Indicators (KPI) based on sales data extracted from two SAP tables via Theobald and SAP Hana. The KPIs are, for example, the total number of orders monthly, average net weights monthly, and the most popular product for each year, among other things. These various indicators are wrapped together nicely to form an interactive dashboard with visualizations of the KPIs.

The data are provided by SAP as part of the Sales and Distribution module.

This workflow demonstrates how to load SAP tables into KNIME via Theobald using the SAP Reader (Theobald) node, as well as via the legacy way of using SAP Hana with DB Connector node.
Fetch sales tables from SAP Hana
Fetch SAP sales tables via TheobaldEnter the Theobald URL and your SAP credentials here!
Interactive dashboard containing various KPIs
KPI Dashboard
join both tables on VBELN column
Joiner
extract Year and Month
Extract Date&Time Fields
connect to SAP HanaEnter your SAP HANA credentials here
DB Connector
import to KNIME
DB Reader
add prefix to col headers
Column Rename (Regex)
select table VBAK
DB Table Selector
add prefix to col headers
Column Rename (Regex)
extract sales order items VBAP
SAP Reader (Theobald Software)

Nodes

Extensions

Links