Hub
Pricing About
WorkflowWorkflow

Audit SAP Duplicate Transactions

knime_sap profile image
VersionV1Latest, created on 
Jan 7, 2026 1:23 PM
Drag & drop
Like
Download workflow
Workflow preview

Duplicate Transactions

This analytic test is used to identify any potentially duplicated transactions. Duplicate transactions could indicate employee errors, system errors, or fraudulent transactions, including collusion. In the example we are checking the SAP Vendor purchasing document header and item data contained in tables EKKO and EKPO. This analytic workflow can be amended to suit to a wide variety of other data (e.g. invoices, payments, payroll, corporate card transactions, expense reports etc.)

The analytic identifies potential duplicate transactions by displaying records that have the same values for the combination of fields on which the user chooses to perform a duplicate test.

To see an example of this workflow in action, click the Workflow Demonstration link under External Resources

This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at https://www.dvwanalytics.com/

External resources

  • www.dvwanalytics.com
  • Workflow Demonstration
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.8.1
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.8.1

    knime
  • Go to item
    KNIME Column Expressions (legacy)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.6.0

    knime
  • Go to item
    KNIME Connector for SAP(KCS) NodesTrusted extension

    De Villiers Walton Ltd

    Version 1.1.25190

    knime_sap profile image
    knime_sap
  • Go to item
    KNIME Excel SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.6.0

    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.8.0

    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.7.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.8.1

    knime
  • Go to item
    KNIME ReportingTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.6.0

    knime
  • Go to item
    KNIME Statistics NodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.6.0

    knime
  • Go to item
    KNIME ViewsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.8.1

    knime
  • Go to item
    Lhasa public pluginTrusted extension

    Lhasa Limited (http://www.lhasalimited.org)

    Version 2.1.1

    lhasa_knime_dev

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2026 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits