Hub
Pricing About
WorkflowWorkflow

SAP General Ledger Accounting Data (BKPF and BSEG Table Extract)

Dvw analyticsSap
darronwalton profile image
Draft Latest edits on 
Dec 14, 2020 5:09 PM
Drag & drop
Like
Download workflow
Workflow preview
This workflow from DVW Analytics demonstrates how to extract data from the "Big Two" SAP Financial Accounting (FI) Transaction Data Tabk: BKPF (Accounting Document Header) and BSEG (Accounting Document Segment). Table BKPF holds the Header data for all Financial transactions in SAP while table BSEG holds the Segment or Item data for all Financial transactions in SAP. By combining data from the two tables we can effectively recreate SAP Financial Accounting documents within KNIME. Functions used: * SAP Table Read capability - Works with standard and custom SAP Tables and Views

External resources

  • DVW Analytics KNIME Connectors
  • Learn how you can easily extract SAP General Ledger accounting data from SAP ECC & SAP S/4HANA using KNIME & the DVW KNIME Connector for SAP
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

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

    KNIME AG, Zurich, Switzerland

    Version 4.3.2

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

    De Villiers Walton Ltd

    Version 1.0.2125

    knime_sap
  • Go to item
    KNIME Excel SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.2

    knime

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
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits