-
Products
- Solutions
- Pricing
- Free Trial
-
Resources
-
Insights
- Blog
-
SAP Data Models
>
- SAP FI/CO Table Relationships - Interactive Data Model Diagram
- SAP SD Table Relationships - Interactive Data Model Diagram
- SAP Inventory Management Table Relationships - Interactive Data Model Diagram
- SAP Purchasing Table Relationships - Interactive Data Model Diagram
- SAP PP Table Relationships - Interactive Data Model Diagram
- SAP QM Table Relationships - Interactive Data Model Diagram
- SAP PM Table Relationships - Interactive Data Model Diagram
- SAP WM Table Relationships - Interactive Data Model Diagram
- SAP HCM Table Relationships - Interactive Data Model Diagram
- SAP PS Table Relationships - Interactive Data Model Diagram
- Demos & Recordings >
- Webinars
- Events
- Contact Us
Ready-to-run KNIME workflows that read SAP data straight into your analysis.
We build these templates to show what you can do once SAP data is inside KNIME. Open any template on the KNIME Community Hub, download it, and point it at your own data.
Every template reads live SAP data with the DVW KNIME Connector for SAP. Start a free trial to run them against your own SAP system. We add new templates over the coming weeks and months, so check back for more.
Office of Finance
SAP Finance Workflows
A starter pack of KNIME workflows for finance and audit teams, each one built around a demo in our Office of Finance video series. Download a workflow from the KNIME Community Hub and run it on your own SAP system.
Post Journal Entries to SAP
Post journal entries as G/L documents straight into SAP from KNIME, with SAP's own confirmation returned for the audit trail. This one writes back to SAP, not just reads.
Applies to: journal posting, accruals, corrections, period-end adjustments
SAP Financial Documents (FB03)
Pull a list of posted financial documents into KNIME with the FB03 document search, then explore them in an interactive dashboard and write them out to Excel.
Applies to: document review, posting checks, period-end close
SAP General Ledger (FBL3N)
Pull the general ledger into KNIME with the FBL3N line item display, clean up the amounts SAP returns as text, and explore balances by G/L account.
Applies to: GL review, account analysis, month-end
SAP GL Source Tables (BKPF and BSEG)
Read the general ledger header and line item tables straight from SAP, filtered and joined in KNIME. Get to the posting detail behind the standard reports without a file export.
Applies to: journal analysis, reconciliations, GL detail extracts
SAP Cost Center Actuals (KSB1)
Pull cost center actual line items from SAP into KNIME, then explore spend by cost center and period in an interactive view.
Applies to: cost center reporting, budget vs actual, overhead analysis
SAP Customer Line Items (FBL5N)
Bring customer open and cleared items from SAP into KNIME to analyze receivables, aging, and payment behavior.
Applies to: accounts receivable, collections, DSO analysis
Audit
SAP Audit Test Templates
These templates adapt the KNIME Audit Starter Pack to run directly on SAP data, grouped into the same four test categories KNIME uses.
Data Integrity & Duplicate Testing
SAP Fuzzy Name Matching
Pull vendor master data from SAP and use fuzzy matching to find near-duplicate names. Clean up the spelling and formatting variations that hurt reporting, compliance, and spend analysis.
Applies to: vendor, customer, and employee master data; GL accounts
SAP Duplicate Transactions
Extract purchasing headers and line items from SAP and test for duplicates on the fields you choose, such as document number, vendor, or amount. Helps prevent duplicate payments and fraud.
Applies to: invoices, purchase orders, requisitions, journal entries
Fraud Detection & Red Flag Analytics
Even Value SAP Transactions
Find transactions with amounts evenly divisible by a value you set. A simple test for round-number payments, expense claims, and journal entries that are worth a second look.
Applies to: corporate card, expense reimbursements, journal entries
Trend & Outlier Analysis
High Standard Deviation in SAP Transactions
Calculate standard deviation on any numeric SAP field and flag values that sit far from the norm. A fast way to surface outliers and anomalies across large populations of data.
Applies to: processing times, manufacturing costs, write-offs, scrap rates
SAP Transaction Volume Summary
Aggregate SAP transaction counts and values by day, week, month, or year. Spot peaks, slowdowns, and trends, then present them in interactive tables and bar charts.
Applies to: any transaction table you want to monitor by period
Aging & Timeliness Testing
SAP Transaction Aging Calculation
Sort open invoices, payables, and inventory into aging buckets from a cutoff date you choose. See overdue items at a glance for collections, payments, and audit review.
Applies to: accounts payable, accounts receivable, inventory
Run these workflows on your own SAP data
The DVW KNIME Connector for SAP reads live SAP data into KNIME. Full functionality. No commitment. Trusted by 500+ enterprises worldwide.
Start your DVW KNIME Connector for SAP trial
30-day free trial. Takes less than a minute.
Thank you for registering
We're setting up your KNIME Connector for SAP trial. Check your inbox for login details. They'll be with you shortly.
Not ready to install today?
Have a look at the product first, or talk to us about your use case.
|
Products
|
Resources & Insights
Solutions
|
Company
|
Get started
DVW Analytics gives business users and technical teams direct access to SAP data from Alteryx, KNIME, Dataiku, Power BI, Databricks, Snowflake, and more. Trusted by 500+ enterprises worldwide.
|
|
© COPYRIGHT 2003 - 2026 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.
|
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Alteryx is a registered trademark of Alteryx, Inc. KNIME is a registered trademark of KNIME AG. Dataiku is a registered trademark of Dataiku SAS. All other product, company, and brand names mentioned herein are the trademarks or registered trademarks of their respective owners and are used for identification purposes only.