Icon

Extract SAP Purchasing Document Data, Invoice Data and Vendor Master Data from SAP ECC & SAP S_​4HANA

Extract SAP Purchasing Document Data, Invoice Data and Vendor Master Data from SAP ECC & SAP S_4HANA
Extract SAP Purchasing Document Data, Invoice Data and Vendor Master Data from SAP ECC & SAP S_4HANA Workflow Description:This workflow provides:1. Examples of how to extract data from Purchasing Document Header (EKKO) and Item tables (EKPO), Purchasing Invoice Document Header (RBKP) and Item (RSEG)tables.2. An example of how to extract Vendor Master Data from the primary Vendor Master Data tables (LFA1 and LFB1).3. Examples of important Configuration Data tables (EKBE, T169G, TIBAN)Prerequisites:KCS SAP ExecutorTools used:SAP Table toolThis workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com To learn more about this workflow and the DVW KNIME Connector for SAP, visit us at www.dvwanalytics.com Column expressionsand table manipulatorto transform the tabledata to theappropriate format forKCS table tooldynamic input KCS SAP Executortable read tool toextract invoice receiptHeader details Table Manipulatorto convert ordervalues from stringto number KCS SAP Executortable read tool toextract invoice receiptitem details KCS SAP Executortable read tool toextract PO Headerdetails Column expressionsand table manipulatorto transform the tabledata to theappropriate format forKCS table tooldynamic input Table Manipulatorto convert ordervalues from stringto number KCS SAP Executortable read tool toextract PO itemdetails KCS SAP Executortable read tool toextract Vendor bankdetails KCS SAP Executortable read tool toextract Vendor Masterdata Column expressionsand table manipulatorto transform the tabledata to theappropriate format forKCS table tooldynamic input KCS SAP Executortable read tool toextract PO history KCS SAP Executortable read tool toextract ToleranceLimits, InvoiceVerification KCS SAP Executortable read tool toextract IBAN info KCS SAP Executortable read tool toextract VendorCompany Codedetails Combine datafrom the twotables to get header and itemdetails Combine datafrom the twotables to get header and itemdetails Combine datafrom all the tablesto all vendormaster details The Group Loop Start and Loop End batchesthe Invoice Receipt output from RBKP intogroups allowing large volume of data to beextracted. The Group Loop Start and Loop End batchesthe PO output from EKKO into groups allowinglarge volume of data to be extracted. Group and Unpivot byCompany Code,Fiscal Year andDocument Number Table RBKPTable RSEGNode 3Node 5Table EKKOTable EKPONode 8Node 9Node 10Node 11Node 12Node 13Node 14Node 15Node 16Table LFA1Node 18Node 19Table LFBKTable LFB1Node 22Node 23Table EKBE Table T169GTable TIBANNode 27Node 28Node 30KCS SAP Executor KCS SAP Executor Column Expressions Table Manipulator KCS SAP Executor KCS SAP Executor Column Expressions Group Loop Start Loop End Joiner (Labs) Sorter Table Manipulator Group Loop Start Loop End Joiner (Labs) KCS SAP Executor Column Expressions Sorter KCS SAP Executor KCS SAP Executor Joiner (Labs) Joiner (Labs) KCS SAP Executor KCS SAP Executor KCS SAP Executor Unpivoting GroupBy Table Manipulator Extract SAP Purchasing Document Data, Invoice Data and Vendor Master Data from SAP ECC & SAP S_4HANA Workflow Description:This workflow provides:1. Examples of how to extract data from Purchasing Document Header (EKKO) and Item tables (EKPO), Purchasing Invoice Document Header (RBKP) and Item (RSEG)tables.2. An example of how to extract Vendor Master Data from the primary Vendor Master Data tables (LFA1 and LFB1).3. Examples of important Configuration Data tables (EKBE, T169G, TIBAN)Prerequisites:KCS SAP ExecutorTools used:SAP Table toolThis workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com To learn more about this workflow and the DVW KNIME Connector for SAP, visit us at www.dvwanalytics.com Column expressionsand table manipulatorto transform the tabledata to theappropriate format forKCS table tooldynamic input KCS SAP Executortable read tool toextract invoice receiptHeader details Table Manipulatorto convert ordervalues from stringto number KCS SAP Executortable read tool toextract invoice receiptitem details KCS SAP Executortable read tool toextract PO Headerdetails Column expressionsand table manipulatorto transform the tabledata to theappropriate format forKCS table tooldynamic input Table Manipulatorto convert ordervalues from stringto number KCS SAP Executortable read tool toextract PO itemdetails KCS SAP Executortable read tool toextract Vendor bankdetails KCS SAP Executortable read tool toextract Vendor Masterdata Column expressionsand table manipulatorto transform the tabledata to theappropriate format forKCS table tooldynamic input KCS SAP Executortable read tool toextract PO history KCS SAP Executortable read tool toextract ToleranceLimits, InvoiceVerification KCS SAP Executortable read tool toextract IBAN info KCS SAP Executortable read tool toextract VendorCompany Codedetails Combine datafrom the twotables to get header and itemdetails Combine datafrom the twotables to get header and itemdetails Combine datafrom all the tablesto all vendormaster details The Group Loop Start and Loop End batchesthe Invoice Receipt output from RBKP intogroups allowing large volume of data to beextracted. The Group Loop Start and Loop End batchesthe PO output from EKKO into groups allowinglarge volume of data to be extracted. Group and Unpivot byCompany Code,Fiscal Year andDocument Number Table RBKPTable RSEGNode 3Node 5Table EKKOTable EKPONode 8Node 9Node 10Node 11Node 12Node 13Node 14Node 15Node 16Table LFA1Node 18Node 19Table LFBKTable LFB1Node 22Node 23Table EKBE Table T169GTable TIBANNode 27Node 28Node 30KCS SAP Executor KCS SAP Executor Column Expressions Table Manipulator KCS SAP Executor KCS SAP Executor Column Expressions Group Loop Start Loop End Joiner (Labs) Sorter Table Manipulator Group Loop Start Loop End Joiner (Labs) KCS SAP Executor Column Expressions Sorter KCS SAP Executor KCS SAP Executor Joiner (Labs) Joiner (Labs) KCS SAP Executor KCS SAP Executor KCS SAP Executor Unpivoting GroupBy Table Manipulator

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: SophieBaig
Created at: 2022-03-28
On NodePit since: 2022-04-05
Last update: 2024-11-21
Created with KNIME version: v4.3.2
Tags: SAPDVW Analytics

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

Try NodePit Runner!