Icon

SAP ECC Customer Returns Analysis

SAP ECC Customer Returns Analysis
ECC Customer Analytics Accelerator: Customer Returns AnalysisWorkflow Description:When running a business, mistakes are inevitable. Some mistakes result in customer returns. Examples include shipping the wrong product or product of inferiorquality, poor packaging and others. With this Customer Returns workflow, a Customer Service Manager can easily identify spikes in Customer Returns and takecorrective action before it dents profitability and customers satisfaction. This workflow has been designed to work with SAP ECC data but could be easily adapted towork with SAP S/4HANA data.Prerequisites:KCS SAP ExecutorTables Extracted:VBAK (Customer Order Header), VBAP (Customer Order Item), KNA1 (Customer Master General Data)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 customerorder headerinformation based onreturn order type andtime period Columnexpressions nodeto build the tablefor KCS table readdynamic input Remove the fieldswhich are notneeded andrename ordernumber asLowKey as inputrange KCS SAP Executortable read tool toextract customerorder item informationfrom the dynamicinput Joiner tocombineheader anditem datatogether Convert ordervalue andquantityto numerictype Extract yearand monthfrom the orderdate Output in bar toshow returnquantity and valueby month, piechart to breakdown to materials Build the table forKCS table readdynamic input toextract customerdata Remove anyhidden chars Duplicatedcustomernumbers KCS SAP Executortable read tool toextract customergeneralinformation Join order andcustomer details Output to Tableaufor furtherexploration andvisualisation To learn more about this workflow and the DVW KNIME Connector for SAP, visit us at www.dvwanalytics.com VBAKExtract Year/month from created dateNode 6Node 7VBAPNode 9Node 10Node 7Node 24Node 25KNA1Node 27Node 28Return QuantityNode 30Node 31Return ValueNode 34Return by MatetrialNode 36 KCS SAP Executor String Manipulation Column Expressions Table Manipulator KCS SAP Executor Joiner Tableau Writer Table Manipulator String Manipulation DuplicateRow Filter KCS SAP Executor GroupBy Table Manipulator Bar Chart Table Manipulator DuplicateRow Filter Bar Chart GroupBy Pie/Donut Chart Joiner ECC Customer Analytics Accelerator: Customer Returns AnalysisWorkflow Description:When running a business, mistakes are inevitable. Some mistakes result in customer returns. Examples include shipping the wrong product or product of inferiorquality, poor packaging and others. With this Customer Returns workflow, a Customer Service Manager can easily identify spikes in Customer Returns and takecorrective action before it dents profitability and customers satisfaction. This workflow has been designed to work with SAP ECC data but could be easily adapted towork with SAP S/4HANA data.Prerequisites:KCS SAP ExecutorTables Extracted:VBAK (Customer Order Header), VBAP (Customer Order Item), KNA1 (Customer Master General Data)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 customerorder headerinformation based onreturn order type andtime period Columnexpressions nodeto build the tablefor KCS table readdynamic input Remove the fieldswhich are notneeded andrename ordernumber asLowKey as inputrange KCS SAP Executortable read tool toextract customerorder item informationfrom the dynamicinput Joiner tocombineheader anditem datatogether Convert ordervalue andquantityto numerictype Extract yearand monthfrom the orderdate Output in bar toshow returnquantity and valueby month, piechart to breakdown to materials Build the table forKCS table readdynamic input toextract customerdata Remove anyhidden chars Duplicatedcustomernumbers KCS SAP Executortable read tool toextract customergeneralinformation Join order andcustomer details Output to Tableaufor furtherexploration andvisualisation To learn more about this workflow and the DVW KNIME Connector for SAP, visit us at www.dvwanalytics.com VBAKExtract Year/month from created dateNode 6Node 7VBAPNode 9Node 10Node 7Node 24Node 25KNA1Node 27Node 28Return QuantityNode 30Node 31Return ValueNode 34Return by MatetrialNode 36 KCS SAP Executor String Manipulation Column Expressions Table Manipulator KCS SAP Executor Joiner Tableau Writer Table Manipulator String Manipulation DuplicateRow Filter KCS SAP Executor GroupBy Table Manipulator Bar Chart Table Manipulator DuplicateRow Filter Bar Chart GroupBy Pie/Donut Chart Joiner

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: JieZhao
Created at: 2021-04-14
On NodePit since: 2022-02-11
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!