Icon

SAP Purchasing - Extract Purchasing Document Data (Table Extract)

SAP Purchasing - Extract Purchasing Document Data (Table Extract)
ECC Customer Analytics Accelerator: SAP Purchasing - Extract Purchasing Document Data (Table Extract)Workflow Description:The workflow can be used to extract Request for Purchasing Document data from SAP ECC or SAP S/4HANA.This workflow uses the DVW KCS SAP Executor to extract data from the following Purchasing Document tables: EKKO (Purchasing Document Header) and EKPO(Purchasing Document Item).Table EKKO holds the Header data for Purchasing transactions (including Purchase Order, Contract, Scheduling Agreement & Request for Quotation) in SAP whiletable EKPO holds the Item data for Purchasing transactions. By combining data from the two tables we can effectively recreate SAP Purchasing documents withinAlteryx.Prerequisites:KCS SAP ExecutorTables Extracted:EKKO (Purchasing Document Header), EKPO (Purchasing Document Item)This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com KCS SAP Executortable read tool toextract puchasingdocument headerdata Columnexpressions nodeto build the tablefor KCS table readdynamic input Remove the fieldswhich are notneeded KCS SAP Executortable read tool toextract purchasingdocument item information from thedynamic input Joiner tocombineheader anditem datatogether Group andUnpivot byCompany Codeand DocumentNumber The Group Loop Startand Loop End batchesthe output from EKKO into groups allowinglarge volume of data to beextracted. EKKONode 5Node 8Node 9Node 10Node 11Node 12Node 13EKPO KCS SAP Executor Table Manipulator Joiner (Labs) Group Loop Start Loop End GroupBy Unpivoting Column Expressions KCS SAP Executor ECC Customer Analytics Accelerator: SAP Purchasing - Extract Purchasing Document Data (Table Extract)Workflow Description:The workflow can be used to extract Request for Purchasing Document data from SAP ECC or SAP S/4HANA.This workflow uses the DVW KCS SAP Executor to extract data from the following Purchasing Document tables: EKKO (Purchasing Document Header) and EKPO(Purchasing Document Item).Table EKKO holds the Header data for Purchasing transactions (including Purchase Order, Contract, Scheduling Agreement & Request for Quotation) in SAP whiletable EKPO holds the Item data for Purchasing transactions. By combining data from the two tables we can effectively recreate SAP Purchasing documents withinAlteryx.Prerequisites:KCS SAP ExecutorTables Extracted:EKKO (Purchasing Document Header), EKPO (Purchasing Document Item)This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com KCS SAP Executortable read tool toextract puchasingdocument headerdata Columnexpressions nodeto build the tablefor KCS table readdynamic input Remove the fieldswhich are notneeded KCS SAP Executortable read tool toextract purchasingdocument item information from thedynamic input Joiner tocombineheader anditem datatogether Group andUnpivot byCompany Codeand DocumentNumber The Group Loop Startand Loop End batchesthe output from EKKO into groups allowinglarge volume of data to beextracted. EKKONode 5Node 8Node 9Node 10Node 11Node 12Node 13EKPO KCS SAP Executor Table Manipulator Joiner (Labs) Group Loop Start Loop End GroupBy Unpivoting Column Expressions KCS SAP Executor

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: TusharKale
Created at: 2022-02-17
On NodePit since: 2022-04-14
Last update: 2024-04-27
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!