Accelerate your migration to SAP S/4HANA with Alteryx and the DVW Alteryx Connector for SAP

Please download to get full document.

View again

of 37
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Similar Documents
Information Report
Category:

Software

Published:

Views: 0 | Pages: 37

Extension: PDF | Download: 0

Share
Description
As an SAP customer you will, at some point in the near future, need to consider replacing SAP ECC with SAP S/4HANA. Regardless of whether you proceed with a new (Greenfield) implementation, a system conversion (the so-called, Brownfield approach) or a selective data transition; the successful migration of your business data will be key to delivering a successful programme. Irrespective of whether you will ultimately use the SAP S/4HANA Migration Cockpit or SAP Data Services to execute the migration of data, a significant effort is required to review, clean-up and prepare the data for migration. In this presentation, we will introduce you to the idea of using Alteryx and the DVW Alteryx Connector for SAP to support and accelerate the process of reviewing and preparing your business data for migration. 
Transcript
  • 1. ACCELERATE YOUR MIGRATION TO SAP S/4HANA WITH ALTERYX & THE DVW ALTERYX CONNECTOR FOR SAP © 2019 De Villiers Walton Limited
  • 2. CONTENTS • Introduction • Focus • Identifying the data source: Bank Master Record • Extract and analyse SAP ECC Bank Master Record data • Extract and analyse SAP ECC Bank Master Record data after cleaning • Compare SAP ECC and SAP S/4HANA Bank Master Record data prior to migration • Prepare the SAP ECC Bank Master Record migration file • Next Steps © 2019 De Villiers Walton Limited
  • 3. As an SAP customer you will, at some point in the near future, need to consider replacing SAP ECC with SAP S/4HANA. Regardless of whether you proceed with a new (Greenfield) implementation, a system conversion (the so-called, Brownfield approach) or a selective data transition; the successful migration of your business data will be key to delivering a successful programme. Irrespective of whether you will ultimately use the SAP S/4HANA Migration Cockpit or SAP Data Services to execute the migration of data, a significant effort is required to review, clean-up and prepare the data for migration. In this presentation, we will introduce you to the idea of using Alteryx and the DVW Alteryx Connector for SAP to support and accelerate the process of reviewing and preparing your business data for migration. INTRODUCTION © 2019 De Villiers Walton Limited
  • 4. If you are unfamiliar with Alteryx and DVW Alteryx Connector we recommend that you first watch, “SAP for Everyone” to get an understanding of both tools. INTRODUCTION © 2019 De Villiers Walton Limited
  • 5. The worked example will focus on the review, clean-up and preparation of a specific master data object, the Bank Master Record in 5 parts: 1. Identify the source of the Bank Master Record in both the SAP ECC system and the SAP S/4HANA system. 2. Build a simple Alteryx workflow to extract and analyse the required Bank Master Record data from SAP ECC. 3. Use an Alteryx workflow to review the SAP ECC Bank Master Record data after it has been cleaned by the data owners. 4. Use an Alteryx workflow to review and compare the Bank Master Record data from SAP ECC and SAP S/4HANA. 5. Prepare the clean SAP ECC Bank Master Record data, so it is ready for import into the SAP S/4HANA using SAP S/4HANA Migration Cockpit or SAP Data Services FOCUS © 2019 De Villiers Walton Limited
  • 6. 1. IDENTIFY THE DATA SOURCE: BANK MASTER RECORD • The Bank Master Record (transaction FI01 / FI02 / FI03) is common to both SAP ECC and SAP S/4HANA. © 2019 De Villiers Walton Limited
  • 7. 1. IDENTIFY THE DATA SOURCE: BANK MASTER RECORD • SAP master data and transaction data objects are typically comprised of multiple tables but for ease of illustration, we will focus on a single table. • In SAP ECC and SAP S/4HANA the Bank Master Record data we are interested in is stored in SAP table, BNKA (Bank master record). • The screenshot shows the content of table BNKA in SAP ECC using the Data Browser (SE16 / SE16N) transaction. © 2019 De Villiers Walton Limited
  • 8. 1. IDENTIFY THE DATA SOURCE: BANK MASTER RECORD • SAP provides various migration templates. • This example shows the Field List tab of the standard migration template for Migration Object: Bank. This template can be used if you are using the SAP S/4HANA Migration Cockpit. © 2019 De Villiers Walton Limited
  • 9. 1. IDENTIFY THE DATA SOURCE: BANK MASTER RECORD • This example shows a sample SAP template for the Bank Master Record. This template can be used if you are using SAP Data Services. So, we have identified the data source for the Bank Master Record along with the available migration templates for us to populate © 2019 De Villiers Walton Limited
  • 10. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • We now need to define a simple Alteryx workflow to extract and analyse the SAP ECC Bank Master Record data from table BNKA. © 2019 De Villiers Walton Limited
  • 11. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • The SAP system to be accessed is selected on the Parameters tab of the SAP Logon tool. • Details of the selected SAP system along with the credentials of the logged in user are passed to the other tools in the workflow. © 2019 De Villiers Walton Limited
  • 12. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • Bank Master Record table, BNKA is selected on the Parameters tab of the SAP Table Data tool. • We have selected the same fields used in the SAP templates. • Note, the "Show selected items only?" checkbox is checked so only the selected fields are displayed. © 2019 De Villiers Walton Limited
  • 13. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • For this worfklow we are interested in extracting all Bank Master Record data for Great Britain. • Right-click on the Bank Country Key field and create a filter for Bank Country Key, "GB". © 2019 De Villiers Walton Limited
  • 14. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • Check the Filters and Variables view on the Parameters tab of the SAP Table Data tool. Note, that it is possible to directly edit the filter from this view. We have now identified the table and fields we want to extract from SAP ECC. We have also defined a simple Filter to further refine the data to be extracted. © 2019 De Villiers Walton Limited
  • 15. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • An Alteryx Browse tool is added to the SAP Table Data tool out port. The Alteryx Browse tool is rich in functionality. At the most basic level it displays the data from a connected tool - in this case the SAP Table Data tool. It also provides clear insight into the quality of the data that is displayed. • Running the workflow triggers the extract of data from SAP ECC table, BNKA. © 2019 De Villiers Walton Limited
  • 16. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • The Browse tool Results window displays the output of the extract. The Results window also displays a coloured data quality bar at the top of each column of data. • In this example, the PROVZ column has a Yellow coloured bar. The SWIFT column has a Yellow and Green coloured bar. The remaining columns have a Green bar. • The colour coding allows us to easily determine that the PROVZ and SWIFT columns need further examination. We will take a closer look at the SWIFT column. • Red (Not OK): The column contains values with leading or trailing white space. • Yellow (Null): The column contains no values. • Grey (Empty): The column contains strings with no values. • Green (OK): The column contains values without leading or trailing white spaces. © 2019 De Villiers Walton Limited
  • 17. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • By clicking a column in the Browse tool Results window, a detailed analysis of the content of the column is displayed in the Profile tab of the Browse tool Configuration window. • In this example, the SWIFT column has been selected and the analysis displayed in the Profile tab of the Browse tool Configuration window. © 2019 De Villiers Walton Limited
  • 18. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • Further analysis reveals that 31 of the extracted Bank Master Records do not have an associated SWIFT / BIC code (SWIFT). © 2019 De Villiers Walton Limited
  • 19. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • Based on the analysis we will modify the workflow to isolate the 31 Bank Master Records without a SWIFT / BIC code (SWIFT). • On the Parameters tab of the SAP Table Data tool, right-click on the SWIFT / BIC for International Payments field and create a Filter for a value of, EMPTY. © 2019 De Villiers Walton Limited
  • 20. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • Once we have identified the Bank Master Records with missing SWIFT / BIC for International Payments data there are several ways in which the data can be corrected and loaded into the source SAP ECC system. We are going to create an Excel spreadsheet for our data owners to review before manually updating the Bank Master Records in SAP ECC. • An Alteryx Output Data tool is used to write the output from the extract to an Excel spreadsheet.
  • 21. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • Running the workflow triggers the extract of data from SAP ECC table, BNKA. • The extracted data is written to an Excel spreadsheet which can be handed over to the data owners for further analysis and correction. © 2019 De Villiers Walton Limited
  • 22. 2. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA • The Bank Master Records are updated in SAP ECC using transaction FI02. © 2019 De Villiers Walton Limited
  • 23. 3. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA AFTER CLEANING • After the Bank Master Records have been updated the original workflow is run (without the filter on the SWIFT / BIC for International Payments field) to re-evaluate the data. • In the example below, the SWIFT column now has a Green coloured bar.
  • 24. 3. EXTRACT & ANALYSE SAP ECC BANK MASTER RECORD DATA AFTER CLEANING • Further analysis confirms that there are no Bank Master Records with empty SWIFT fields. © 2019 De Villiers Walton Limited
  • 25. 4. COMPARE SAP ECC & SAP S/4HANA DATA BANK MASTER RECORD PRIOR TO MIGRATION • We now need to define an Alteryx workflow to extract and compare the SAP ECC Bank Master Record data from table BNKA with the SAP S/4HANA Bank Master Record data from SAP S/4HANA. © 2019 De Villiers Walton Limited
  • 26. 4. COMPARE SAP ECC & SAP S/4HANA DATA BANK MASTER RECORD PRIOR TO MIGRATION • The SAP systems to be accessed are selected on the Parameters tab of the SAP Logon tool. Details of the selected SAP system along with the credentials of the logged in user are passed to the other tools in the workflow. • In this example below, the SAP ECC system and the SAP S/4HANA system have been added to the SAP Logon tool. © 2019 De Villiers Walton Limited
  • 27. 4. COMPARE SAP ECC & SAP S/4HANA DATA BANK MASTER RECORD PRIOR TO MIGRATION • The SAP ECC system is selected on the Basic tab of the SAP Table Data tool. The Bank Master Record table, BNKA is selected on the Parameters tab of the SAP Table Data tool. We have selected the same fields used in the SAP templates. © 2019 De Villiers Walton Limited
  • 28. 4. COMPARE SAP ECC & SAP S/4HANA DATA BANK MASTER RECORD PRIOR TO MIGRATION • The SAP S/4HANA system is selected on the Basic tab of the SAP Table Data tool. The Bank Master Record table, BNKA is also selected on the Parameters tab of the SAP Table Data tool. We have selected the same fields used in the SAP templates. © 2019 De Villiers Walton Limited
  • 29. 4. COMPARE SAP ECC & SAP S/4HANA DATA BANK MASTER RECORD PRIOR TO MIGRATION • An Alteryx Join tool is added to the workflow. The SAP Table Data tool out port for the SAP ECC system is connected to the Left in port of the Join tool. The SAP Table Data tool out port for the SAP S/4HANA system is connected to the Right in port of the Join tool. • The Join tool combines two inputs based on common fields between the two tables. In the example below, the join between the SAP ECC BNKA table and the SAP S/4HANA BNKA table is created on three common fields: Bank Country Key (BANKS), Bank Keys (BANKL) and Name of Bank (BANKA). © 2019 De Villiers Walton Limited
  • 30. 4. COMPARE SAP ECC & SAP S/4HANA DATA BANK MASTER RECORD PRIOR TO MIGRATION • An Alteryx Browse tool is added to the left out port of the Alteryx Join tool. • When the workflow is run, the Browse tool will show the Bank Master Records that are available in the SAP ECC system but not the SAP S/4HANA system. • There are 262 Bank Master Records that need to be migrated to SAP S/4HANA.
  • 31. 4. COMPARE SAP ECC & SAP S/4HANA DATA BANK MASTER RECORD PRIOR TO MIGRATION • An Alteryx Browse tool is added to the join out port of the Alteryx Join tool. • When the workflow is run, the Browse tool will show the Bank Master Records that are available in both the SAP ECC system and the SAP S/4HANA system.
  • 32. 4. COMPARE SAP ECC & SAP S/4HANA DATA BANK MASTER RECORD PRIOR TO MIGRATION • An Alteryx Browse tool is added to the right out port of the Alteryx Join tool. • When the workflow is run, the Browse tool will show the Bank Master Records that are available in the SAP S/4HANA system but not the SAP ECC system.
  • 33. 5. PREPARE THE SAP ECC BANK MASTER RECORD MIGRATION FILE • Finally, we need to extend the Alteryx workflow to create the SAP ECC Bank Master Record migration file. © 2019 De Villiers Walton Limited
  • 34. 5. PREPARE THE SAP ECC BANK MASTER RECORD MIGRATION FILE • An Alteryx Output Data tool is used to write the output from the extract to an CSV file. © 2019 De Villiers Walton Limited
  • 35. 5. PREPARE THE SAP ECC BANK MASTER RECORD MIGRATION FILE • Running the workflow, triggers the extract of data from SAP ECC table, BNKA. The extracted data is written to a file that can be imported into SAP S/4HANA using the SAP S/4HANA Migration Cockpit or SAP Data Services. © 2019 De Villiers Walton Limited
  • 36. NEXT STEPS © 2019 De Villiers Walton Limited
  • 37. VISIT US AT WWW.DVWANALYTICS.COM © 2019 De Villiers Walton Limited
  • Recommended
    View more...
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks
    SAVE OUR EARTH

    We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

    More details...

    Sign Now!

    We are very appreciated for your Prompt Action!

    x