Icon

SAP Purchasing - Extract Contract Data (Table Extract)

SAP Purchasing - Extract Contract Data (Table Extract)
SAP Purchasing - Extract Contract Data (Table Extract)This workflow from DVW Analytics demonstrates can be used to extract Contract data from SAP ECC or SAP S/4HANA.Table EKKO holds the Header data for Purchasing transactions (including Purchase Order, Contract, Scheduling Agreement & Request for Quotation) in SAP while tableEKPO holds the Item data for Purchasing transactions. By combining data from the two tables we can effectively recreate SAP Purchasing documents within KNIME.Prerequisites:KCS SAP ExecutorTools used:SAP Table Read capability - Works with standard and custom SAP Tables and ViewsTables Extracted: Purchase transaction header (EKKO), Purchase transaction item (EKPO)This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com Execute the extract of selectedEKKO table data from SAP. Pass data extracted from EKKO table tothe Joiner Node. Dynamically extractdata from EKPO tablebased on dataextracted from EKKOtable Prepare the data extracted from EKKO to use as a dynamic input to select the associated item level data from EKPOtable. To learn more about this workflow and the DVW KNIME Connector for SAP, visit us at www.dvwanalytics.com EKKOEKPONode 3Node 5Node 7Node 8Node 15Node 17Node 18 KCS SAP Executor KCS SAP Executor Column Filter GroupBy Unpivoting Column Rename Column Filter Column Expressions Joiner (Labs) SAP Purchasing - Extract Contract Data (Table Extract)This workflow from DVW Analytics demonstrates can be used to extract Contract data from SAP ECC or SAP S/4HANA.Table EKKO holds the Header data for Purchasing transactions (including Purchase Order, Contract, Scheduling Agreement & Request for Quotation) in SAP while tableEKPO holds the Item data for Purchasing transactions. By combining data from the two tables we can effectively recreate SAP Purchasing documents within KNIME.Prerequisites:KCS SAP ExecutorTools used:SAP Table Read capability - Works with standard and custom SAP Tables and ViewsTables Extracted: Purchase transaction header (EKKO), Purchase transaction item (EKPO)This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com Execute the extract of selectedEKKO table data from SAP. Pass data extracted from EKKO table tothe Joiner Node. Dynamically extractdata from EKPO tablebased on dataextracted from EKKOtable Prepare the data extracted from EKKO to use as a dynamic input to select the associated item level data from EKPOtable. To learn more about this workflow and the DVW KNIME Connector for SAP, visit us at www.dvwanalytics.com EKKOEKPONode 3Node 5Node 7Node 8Node 15Node 17Node 18 KCS SAP Executor KCS SAP Executor Column Filter GroupBy Unpivoting Column Rename Column Filter Column Expressions Joiner (Labs)

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: Purnima
Created at: 2022-02-21
On NodePit since: 2022-04-08
Last update: 2024-04-27
Created with KNIME version: v4.3.2
Tags: SAPDVW Anaytics

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

Try NodePit Runner!