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 TOOLS
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • 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
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
    • ALTERYX CONNECTOR PRICING
    • KNIME CONNECTOR PRICING
    • POWER BI CONNECTOR PRICING
    • TABLEAU CONNECTOR PRICING
    • DATAIKU CONNECTOR PRICING
    • SNOWFLAKE CONNECTOR PRICING
  • RESOURCES
    • WEBINARS >
      • ALTERYX CONNECTOR WEBINARS
      • KNIME CONNECTOR WEBINARS
      • POWER BI CONNECTOR WEBINARS
      • TABLEAU CONNECTOR WEBINARS
      • SNOWFLAKE CONNECTOR WEBINARS
    • EVENTS >
      • ALTERYX EVENTS
      • KNIME EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

BLOG

How to extract attachments for SAP ECC & SAP S/4HANA Plant Maintenance and Customer Service documents into Alteryx

31/8/2019

 
Picture
The SAP Document Read tool can extract attachments in any of the SAP supported MIME type formats including texts, images, audio, video and applications such as PDF, MS Word, MS Excel, MS Powerpoint etc.
In this blog we will show you how to extract attachments for Plant Maintenance and Customer Service documents stored in SAP ECC or SAP S/4HANA. For example you can extract the attachments for Plant Maintenance Notifications (IW21 / IW22 / IW23),  Plant Maintenance Orders / Service Orders  (IW31 / IW32 / IW33), Service Notifications (IW51 / IW52 / IW53), Functional Locations (IL01 / IL02 / IL03), Equipment (IE01 / IE02 / IE03) and so on. 
The principles used here can be applied to any of the other functional areas in SAP including Sales & Distribution, Purchasing, Inventory Management and Financial Accounting.
The remainder of this blog will be split into 2 parts. 
In the first part, we will identify the source of the data we want to extract using the SAP Document Read tool. ​
In the second part, we will look at how to build an Alteryx workflow that will extract the required data using the Alteryx Connector for SAP and the optional SAP Document Read tool add-on.
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. Identifying the data source: Plant Maintenance Notification 

We will use the Plant Maintenance Notification (IW21 / IW22 / IW23) to demonstate the approach. 
In the example below, Notification Number, "10000000" has been selected and displayed with transaction IW23.
Picture
The selected Notification is of type, "M2" for a Malfunction Report. We will use this later when building the Alteryx workflow.
Picture
Select the Attachment List for the Notification. The selected Notification has 10 attachments. The Alteryx workflow will extract all 10 attachments for the Notification.
Picture
We now need to identify the SAP table name for the Plant Maintenance Notification. 
​SAP transactions typically have multiple tables associated with them. For the purposes of this example we are only interested in the document header table for the Plant Maintenance Notification. There are various resources available on the web covering this topic but if you have access to SAP then you can usually find the correct table by clicking on a field (we've selected the Notification Number field) and pressing F1. This displays a Field Help pop-up window from which you can select Technical Information. 
The Technical Information for the Notification Number field is shown below. The Technical Information also shows the table associated with the selected field: VIQMEL (Notification Header). We will need to access table VIQMEL in the Alteryx workflow.
Picture
Let's take a look at table VIQMEL using the Data Browser (SE16 / SE16N) transaction. The header data associated with the Plant Maintenance Notification is highlighted below (partial extract). The attachment data is not directly associated with the Plant Maintenance Notification tables. 
Picture
We need to establish the link between the Plant Maintenance Notification and its attachments. The link for Plant Maintenance Notifications and for all SAP transaction and master data objects is stored in table, SRGBTBREL. Field INSTID_A below represents the Plant Maintenance Notifcation number. Field INSTID_B is the technical name of the attachment. Note that there are 10 entries, one for each attachment linked to the Plant Maintenance Notification.
Picture
We have now established the source for the Plant Maintenance Notification transaction data and the associated attachment data.

2. Alteryx workflow: Extract Plant Maintenance Notification Attachments from SAP ECC & SAP S/4HANA

We have published a sample workflow, "Extract attachments for Plant Maintenance and Customer Service documents stored in SAP ECC & SAP S/4HANA" to Alteryx Gallery. Click here to download it.
From Alteryx Designer select Open Workflow then Alteryx Gallery.
Picture
In the Alteryx Gallery window, search for "DVW".  Then select, "Extract attachments for Plant Maintenance and Customer Service documents stored in SAP ECC & SAP S/4HANA" from the list of DVW Analytics workflows. 
Click, Open to install the workflow. Note: You will need the Alteryx Connector for SAP and the SAP Document Read tool installed to use the workflow.
Picture
Let's take a look at how the workflow is constructed.
Picture
Picture
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.

Picture
Picture
Notification Header table, VIQMEL is selected on the Parameters tab of the SAP Table Data tool. The Notification Number and Notification Table fields are selected. Note, the "Show selected items only?" checkbox is checked so only the selected fields are displayed.

Picture
For this worfklow we are interested in extracting the attachments for all Plant Maintenance Notifications of type, "M2" (Malfunction Report).
Right-click on the Notification Type field and create a filter for Notification Type, "M2".
Picture
Check the Filters and Variables view on the Parameters tab of the SAP Table Data tool. Note, that is possible to directly edit the filter from this view.
Picture
When the workflow is executed, the SAP Table Data tool Ouput shows the VIQMEL table entries that match the selection criteria. This Ouput will be passed onto the next tool in the workflow.
Picture
Picture
We now need to convert the Output from table, VIQMEL into a format that can be used to dynamically select the corresponding entries in table, ​SRGBTBREL.

The Alteryx Formula tool is used for this. In the example below,  we are using the Notification Number (QNUM) output from table VIQMEL and mapping it to SRGBTBREL field, INSTID_A. 
Picture
When the workflow is executed, the Alteryx Formula tool Ouput shows the VIQMEL table entries that match the selection criteria. The "Name", "Selection", "Operator", "LowKey", "HighKey" and "Split" values from this Output will be passed onto the next tool in the workflow.
Picture
Picture
Table SRGBTBREL is selected on the Parameters tab of the SAP Table Data tool. Fields INSTID_A and INSTID_B are selected for the Output. 

Picture
The values in this table will be selected dynamically using the Output from the Alteryx Formula tool in the previous step. The Dynamic Input tab on the SAP Table Data tool ensures that the correct fields from the Output of the Alteryx Formula tool are mapped. 
Picture
When the workflow is executed, the SAP Table Data tool Ouput shows the SRGBTBREL table entries that match the dynamic selection criteria. The "INSTID_B" field value will be passed onto the next tool in the workflow and will be used to extract the attachments using the SAP Document Read tool. 
Note, that in this example only 1 of the Plant Maintenance Notification documents originally selected ("10000000") has been found to have attachments.  There are 10 attachments associated with the same Plant Maintenance Notification.
Picture
Picture
The SAP Document Read tool Configuration tab uses a simple dynamic input. The INSTID_B field value from the previous workflow step maps to the DOCUMENT_ID field.

Picture
When the workflow is executed, the SAP Table Data tool generates two Ouputs.
The first Output from the Document Data out port will be used to generate the file names for the attachments.
Picture
The second Output from the Contents Hex out port holds the hexadecimal content for each of the attachments. Note that there are multiple lines for a single Attachment Document ID.
Picture
Picture
An Alteryx Formula tool is used to create the File Name for each extracted attachment. ​

Picture
When the workflow is executed, the Alteryx Formula tool creates the File Name for each attachment.
Picture
Picture
The Alteryx Summarize tool is used to concatenate multiple Lines for each Document ID into a single output per Document ID.

Picture
After running the workflow, the 5000 plus records Input into the Alteryx Summarize tool...
Picture
... are Output as 10 records.
Picture
Picture
The Alteryx Blob tool is used to convert the HEX encoded Binary Data input from the Alteryx Summarize tool into a Blob Field.

Picture
When the workflow is executed, the Alteryx Blob Convert tool generates the Blob Field for each attachment.
Picture
Picture
The Alteryx Join tool combines the attachment File Name with the attachment Blob Field.

Picture
When the workflow is executed, the Alteryx Join tool generates the combined File Name and Blob Field ouput.
Picture
Picture
The Alteryx Blob Output tool is used to write the attachments to disk. Before running the workflow specify a dummy file name. This will be overwritten with the name created for each attachment when the workflow is executed.

Picture
When the workflow is executed the extracted attachment files are written to the directory specified in the Blob Output tool.
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

    March 2023
    February 2023
    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
​KNIME CONNECTORS
​POWER BI CONNECTORS
TABLEAU CONNECTORS
DATAIKU 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 SAP SUCCESSFACTORS
FREE TRIAL OF ALTERYX CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)​
FREE TRIAL OF ​ALTERYX CONNECTOR FOR SAP BUSINESSOBJECTS

​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 SAP SUCCESSFACTORS
FREE TRIAL OF KNIME CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

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 SAP SUCCESSFACTORS
FREE TRIAL OF POWER BI CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

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 SAP SUCCESSFACTORS
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

DATAIKU CONNECTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)


SNOWFLAKE CONNECTORS
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)

FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

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 TOOLS
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • 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
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
    • ALTERYX CONNECTOR PRICING
    • KNIME CONNECTOR PRICING
    • POWER BI CONNECTOR PRICING
    • TABLEAU CONNECTOR PRICING
    • DATAIKU CONNECTOR PRICING
    • SNOWFLAKE CONNECTOR PRICING
  • RESOURCES
    • WEBINARS >
      • ALTERYX CONNECTOR WEBINARS
      • KNIME CONNECTOR WEBINARS
      • POWER BI CONNECTOR WEBINARS
      • TABLEAU CONNECTOR WEBINARS
      • SNOWFLAKE CONNECTOR WEBINARS
    • EVENTS >
      • ALTERYX EVENTS
      • KNIME EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS