Icon

SAP GL Accounting Data Table Extract (BKPF and BSEG)

SAP General Ledger Accounting Data (BKPF and BSEG Table Extract)
Execute the extract of selectedBKPF table data from SAP. Prepare the data extracted from BKPF to use as a dynamic input to select the associated item level data from BSEG table. Join the output from BKPF table with theoutput from the BSEG table to provideconsolidated Financial Accountingdocument output Dynamically extract datafrom BSEG table basedon data extracted fromBKPF table Pass data extracted from BKPF table tothe Joiner Node. This workflow requires the DVW KNIME Connector for SAP (KCS)To learn more, visit https://www.dvwanalytics.com/knime-connectors.htmlTo request a trial, go to https://www.dvwanalytics.com/free-trial.html SAP General Ledger Accounting Data (Table Extract)This workflow from DVW Analytics demonstrates how to extract data from the "Big Two" SAP Financial Accounting (FI) Transaction Data Tabk: BKPF (AccountingDocument 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. Bycombining 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 Node 2Node 3Node 4Node 5Node 7Node 8Node 9Node 10Node 11Node 12Node 14Node 15Node 16 KCS SAP Executor Column Filter Joiner GroupBy Unpivoting Column Rename ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column KCS SAP Executor Column Filter Excel Writer Execute the extract of selectedBKPF table data from SAP. Prepare the data extracted from BKPF to use as a dynamic input to select the associated item level data from BSEG table. Join the output from BKPF table with theoutput from the BSEG table to provideconsolidated Financial Accountingdocument output Dynamically extract datafrom BSEG table basedon data extracted fromBKPF table Pass data extracted from BKPF table tothe Joiner Node. This workflow requires the DVW KNIME Connector for SAP (KCS)To learn more, visit https://www.dvwanalytics.com/knime-connectors.htmlTo request a trial, go to https://www.dvwanalytics.com/free-trial.html SAP General Ledger Accounting Data (Table Extract)This workflow from DVW Analytics demonstrates how to extract data from the "Big Two" SAP Financial Accounting (FI) Transaction Data Tabk: BKPF (AccountingDocument 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. Bycombining 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 Node 2Node 3Node 4Node 5Node 7Node 8Node 9Node 10Node 11Node 12Node 14Node 15Node 16KCS SAP Executor Column Filter Joiner GroupBy Unpivoting Column Rename ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column KCS SAP Executor Column Filter Excel Writer

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: DarronWalton
Created at: 2020-12-14
On NodePit since: 2021-06-29
Last update: 2024-04-28
Created with KNIME version: v4.3.2
Tags: dvw analytics sap

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!