ALTERYX CONNECTORS

ALTERYX CONNECTOR FOR SAP
ALTERYX CONNECTOR FOR SAP CX
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
ALTERYX CONNECTOR FOR SUCCESSFACTORS
ALTERYX CONNECTOR FOR SAP RPA
SAP METADATA CONNECTOR FOR ALTERYX CONNECT

KNIME CONNECTORS

KNIME CONNECTOR FOR SAP
KNIME CONNECTOR FOR SUCCESSFACTORS

TABLEAU CONNECTORS

TABLEAU CONNECTOR FOR SAP

POWER BI CONNECTORS

POWER BI CONNECTOR FOR SAP
FREE TRIAL
DVW Analytics
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX RPA CONNECTOR
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
      • KNIME CONNECTOR FOR SUCCESSFACTORS
    • DATAIKU CONNECTORS
    • DOMO CONNECTORS
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • UPCOMING WEBINARS
      • ON-DEMAND WEBINARS
    • EVENTS >
      • UPCOMING EVENTS
      • PAST EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

BLOG

Extract Spool Output Data from SAP Purchasing Documents (T-Code ME2N) into Alteryx

23/3/2022

 
Picture
The SAP Spool Read tool is used to extract the spool data generated from running SAP Transaction Codes (T-Codes) and SAP Reports directly into Alteryx. The SAP spool saves the output of a report in a file that can be viewed in SAP or exported out of SAP.

In this blog we will show you how to use the SAP Spool Read tool to extract data from the MM (Material Management ) Purchasing Documents by Document Number (T-code ME2N) into Alteryx.
This blog will be split into 2 parts. 

In the first part, we will take a look at the Purchasing Document Report in SAP and generate a spool.

In the second part, we will look at how the SAP Spool Read tool can be used to extract the spool output  from within Alteryx.

If you would like to follow the steps described in this blog, you will need:
  • Alteryx Designer - Request a trial here.
  • DVW ACS for Alteryx Designer - Request a trial here.
  • Access to an SAP ECC or SAP S/4HANA system

If you have access to Alteryx Gallery and would like to download the workflow presented in the blog, click here.

1. The SAP Purchasing Document by Document Number  (T-Code ME2N)
The SAP Purchasing Document Reports are some of the most commonly used transactions in SAP ECC and SAP S/4HANA. ​The transactions provide a number of ways for users to list Purchasing Document information; ME2N lists Purchasing documents by document number.
Picture
Picture
The Find Variant button retrieves any variants associated with the transaction. The variant is a powerful piece of functionality in SAP. It allows a user to save the selection criteria entered into the transaction selection screen and reuse it when running the transaction.

Picture
The Scope of List  allows you to select various layout options.

Picture
The Program menu  allows you to chose how the report is executed.

Picture
​When the transaction is executed the results are retrieved based upon the selections specified above.
To generate a spool the Execute in Background should be selected.
Picture
Picture
Select the default Printer as the Output Device. This can vary but common options are LP01 and LOCAL.

Picture
 Click on the Green tick Continue button.

Picture
Picture
Schedule the job;  for example Immediate.

Picture
Once the Save button has been clicked this window closes and the following message will appear at the bottom of the selection screen.

Picture
Picture
Select Own Jobs from the Systems Menu.

Picture
Picture
In the Job overview page the following fields are important when we configure the ACS Spool Read Tool.  Job Name, Job Created By, Start Date and  Start Time.

Picture
To view the spool output in SAP . Select the row by clicking on the check box and then select Spool.

Picture
Picture
Select the Spool row and display.

Picture

2. Extract the Purchasing Documents by Document Number (T-Code ME2N) using the SAP Spool Read tool in Alteryx​
So, we now have a run the Purchasing Document by Document Number transaction in SAP ECC or SAP S/4HANA and saved the output to a SAP spool request. 

There are a number of ways in which we can replicate the output of the Purchasing Document by Document Number in Alteryx. 

One option is to use the SAP Report tool to extract data directly from ME2N.


Other options include using  the SAP Table Data tool to extract data from tables EKKO and EKPO or 

another option would be to define an SAP Query (T-Codes SQVI / SQ01 / SQ02 / SQ03) referencing tables EKKO and EKPO and use the SAP Query tool to extract the data into Alteryx.

In this blog we the SAP Spool Read tool will be used.

Let's take a look at the construction of an Alteryx workflow using the SAP Spool Read tool to extract data from the Purchasing Documents by Document Number  (T-Code ME2N) transaction.
Picture
Picture
 The SAP ECC 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.

Picture
Picture
The SAP Job name and run details that were generate in SAP  (see Section 1 point 8 above ) are entered into the Selection Parameter on the Selection Tab. ​

Picture
Once the Raw Preview Button is clicked the spool is retrieve from SAP .
Picture
The line containing the header fields needs to be identified. Click on the relevant row and then select Add Header Row No  from the  context menu. After the header row has , click the Confirm Layout  button to review the formatted output. ​
Picture
The Header Row number can be seen in the Parameters tab.
The report columns can be seen in the Fields tab, unrequired fields can be deselected here.
Picture
Finally, an Alteryx browse tool is added to the workflow. 
When the workflow is run the data extracted from the MM Purchase Document by Document Number transaction  (T-Code ME2N) is output in a format ready for further analysis.

Picture
GET A FREE TRIAL TODAY

Comments are closed.

    RSS Feed

    Categories

    All
    ACS
    ACS BOP
    ACS CX
    ACS Metadata
    ACS SF
    Alteryx
    Alteryx Connector For BusinessObjects
    Alteryx Connector For SAP
    Alteryx Connector For SuccessFactors
    Alteryx Gallery
    Alteryx Inspire
    Alteryx RPA Tools
    Alteryx Server
    APA
    Audit
    BusinessObjects
    Data Migration
    DVW Integration Platform
    Finance
    KCS
    KNIME
    KNIME Connector For SAP
    Microsoft Azure
    Office Of Finance
    On Demand Webinar
    Power BI
    Power BI Connector For SAP
    Predictive Analytics
    Process Automation
    Professional Services
    Qlik
    Read Tools
    RPA
    Salesforce
    Salesforce Wave Analytics
    Sample Workflow
    SAP Business Suite
    SAP BW
    SAP C4C
    SAP ECC
    SAP ERP
    SAP HANA
    SAP S/4HANA
    SAP Tables
    SAP T Codes
    SAP T-Codes
    SAP Transaction Codes
    Snowflake
    Snowflake Connector For SAP
    SuccessFactors
    Tableau
    Tableau Connector For SAP
    Tableau Desktop
    Tableau Online
    Tableau Prep
    Tableau Server
    Tax
    TCS
    ThoughtSpot
    Tool: BOP Universe
    Tool: BOP Webi
    Tool: HTML RPA
    Tool: SAP BAPI Read
    Tool: SAP BAPI Write
    Tool: SAP BW Write
    Tool: SAP Document Read
    Tool: SAP IDoc
    Tool: SAP Query
    Tool: SAP Report
    Tool: SAP RPA
    Tool: SAP Spool Read
    Tool: SAP Table Data
    Tool: SuccessFactors Read
    Tool: SuccessFactors Write
    Top 10 Blog
    Webinar
    Write Tools

    Archives

    January 2023
    October 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    December 2021
    November 2021
    October 2021
    May 2021
    April 2021
    December 2020
    October 2020
    July 2020
    June 2020
    May 2020
    February 2020
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    September 2018
    August 2018
    June 2018
    April 2018
    February 2018
    July 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    November 2015

PRODUCTS

​ALTERYX CONNECTORS
​ALTERYX CONNECTOR FOR SAP
​
ALTERYX RPA TOOLS
​ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
​ALTERYX CONNECTOR FOR BUSINESSOBJECTS
​ALTERYX CONNECTOR FOR SUCCESSFACTORS
SAP METADATA CONNECTOR FOR ALTERYX CONNECT​
​ALTERYX CONNECTOR FOR SAP IBP (COMING SOON)

​KNIME CONNECTORS
​KNIME CONNECTOR FOR SAP
​KNIME CONNECTOR FOR SUCCESSFACTORS

​POWER BI CONNECTORS
POWER BI CONNECTOR FOR SAP

TABLEAU CONNECTORS
TABLEAU CONNECTOR FOR SAP

DATAIKU CONNECTORS

​DOMO CONNECTORS

SNOWFLAKE CONNECTORS

FREE TRIAL

​ALTERYX CONNECTORS
​FREE TRIAL OF ALTERYX CONNECTOR FOR SAP
​FREE TRIAL OF ALTERYX RPA TOOLS
​FREE TRIAL OF ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF ​ALTERYX CONNECTOR FOR BUSINESSOBJECTS
FREE TRIAL OF ​ALTERYX CONNECTOR FOR SUCCESSFACTORS
FREE TRIAL OF ALTERYX CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)​

​KNIME CONNECTORS
​FREE TRIAL OF KNIME CONNECTOR FOR SAP
FREE TRIAL OF KNIME CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
FREE TRIAL OF ​KNIME CONNECTOR FOR SUCCESSFACTORS

POWER BI CONNECTORS
FREE TRIAL OF POWER BI CONNECTOR FOR SAP
​FREE TRIAL OF POWER BI CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF POWER BI CONNECTOR FOR SUCCESSFACTORS

TABLEAU CONNECTORS
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP
​​FREE TRIAL OF TABLEAU CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF TABLEAU CONNECTOR FOR SUCCESSFACTORS

DATAIKU CONNECTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP

DOMO CONNECTORS
FREE TRIAL OF DOMO CONNECTOR FOR SAP

SERVICES

PRICING

DEMOS

BLOG

HELP CENTRE

ABOUT US

CONTACT US

The DVW Integration Platform from DVW Analytics, brings the power of SAP to users of Alteryx, KNIME, Power BI, Tableau and other global software leaders for Analytics & Process Automation

© COPYRIGHT 2003 - 2023 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.

SAP® Business Suite, SAP® BusinessObjects™, SAP® BW, SAP® SuccessFactors are the trademarks or registered trademarks of SAP SE in Germany and in several other countries.
PRIVACY POLICY
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX RPA CONNECTOR
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
      • KNIME CONNECTOR FOR SUCCESSFACTORS
    • DATAIKU CONNECTORS
    • DOMO CONNECTORS
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • UPCOMING WEBINARS
      • ON-DEMAND WEBINARS
    • EVENTS >
      • UPCOMING EVENTS
      • PAST EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS