Icon

Extract Pricing Condition Record Data from SAP ECC v2

Extract Pricing Condition Record Data from SAP ECC v2
SAP table, KONP (Condition Items)is selected in the SAP Table Datatool along with the fields that will beincluded in the workflow output.Take a look at the Basic andParameters tabs of the SAP TableData tool. This branch of the workflow passes the data extracted from the KONH table to the Joiner tool. Thisstep ensures that the data extracted from the KONH table will be incorporated into the final workflowoutput. SAP table, KONH (ConditionsHeader) is selected in theSAP Table Data tool alongwith the fields that will (a) beused to select KONP(Conditions Item) data and(b) included in the work flowoutput. To learn more about this workflow and the DVW KNIME Connector for SAP, visit us at www.dvwanalytics.com The Group Loop batches (100 per batch) the Condition record numbers from KNOPinto groups and passes them as input selections into the SAP Table Data Tool. Extract Pricing Condition Record Data from SAP ECCWorkflow Description:This workflow uses the DVW KCS SAP Table Data tool to extract data from the two most important SAP Pricing Condition Record tables. Data is extracted from the Conditions Header table (KONH) and combined with data from the Condition Items table (KONP) to provide a consolidated output. Thereare a number of other Pricing Conditions tables within SAP but this workflow provides a good starting point.This specific workflow enables the extract of data for Pricing Condition Type PR00 (Price) and Condition Table A304 (Material with Release Status).Prerequisites:KCS SAP ExecutorTables Extracted:Conditions Header table (KONH) and Condition Items table (KONP) The Column Expressions and TableManipulator controls which fields fromtable KONH will be used to select datafrom table KONP. In this workflow the following KONHfields are used to select the requireddata from KONP: KNUMH (ConditionRecord Number). Somewhat unhelpfully for us,SAP stores the fields used todetermine a price (e.g. SalesOrganisation, DistributionChannel, Division, Customer,Material etc.) in a concatenatedformat in field VAKEY. In this workflow we are extractingpricing data for Condition Type,PR00 and Condition Table A304(Material with release status). Condition Table A304 comprisesSales Organisation, DistributionChannel and Material. Node 3Node 6Node 7Collect resultsNode 11Node 12Node 13Node 14 Group Loop Start Column Expressions Table Manipulator Loop End Joiner (Labs) KCS SAP Executor KCS SAP Executor Cell SplitterBy Position SAP table, KONP (Condition Items)is selected in the SAP Table Datatool along with the fields that will beincluded in the workflow output.Take a look at the Basic andParameters tabs of the SAP TableData tool. This branch of the workflow passes the data extracted from the KONH table to the Joiner tool. Thisstep ensures that the data extracted from the KONH table will be incorporated into the final workflowoutput. SAP table, KONH (ConditionsHeader) is selected in theSAP Table Data tool alongwith the fields that will (a) beused to select KONP(Conditions Item) data and(b) included in the work flowoutput. To learn more about this workflow and the DVW KNIME Connector for SAP, visit us at www.dvwanalytics.com The Group Loop batches (100 per batch) the Condition record numbers from KNOPinto groups and passes them as input selections into the SAP Table Data Tool. Extract Pricing Condition Record Data from SAP ECCWorkflow Description:This workflow uses the DVW KCS SAP Table Data tool to extract data from the two most important SAP Pricing Condition Record tables. Data is extracted from the Conditions Header table (KONH) and combined with data from the Condition Items table (KONP) to provide a consolidated output. Thereare a number of other Pricing Conditions tables within SAP but this workflow provides a good starting point.This specific workflow enables the extract of data for Pricing Condition Type PR00 (Price) and Condition Table A304 (Material with Release Status).Prerequisites:KCS SAP ExecutorTables Extracted:Conditions Header table (KONH) and Condition Items table (KONP) The Column Expressions and TableManipulator controls which fields fromtable KONH will be used to select datafrom table KONP. In this workflow the following KONHfields are used to select the requireddata from KONP: KNUMH (ConditionRecord Number). Somewhat unhelpfully for us,SAP stores the fields used todetermine a price (e.g. SalesOrganisation, DistributionChannel, Division, Customer,Material etc.) in a concatenatedformat in field VAKEY. In this workflow we are extractingpricing data for Condition Type,PR00 and Condition Table A304(Material with release status). Condition Table A304 comprisesSales Organisation, DistributionChannel and Material. Node 3Node 6Node 7Collect resultsNode 11Node 12Node 13Node 14 Group Loop Start Column Expressions Table Manipulator Loop End Joiner (Labs) KCS SAP Executor KCS SAP Executor Cell SplitterBy Position

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: IngridHaywood
Created at: 2022-03-21
On NodePit since: 2022-03-22
Last update: 2024-04-28
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!