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.
The SAP Report tool is used to extract data from SAP Transaction Codes (T-Codes) and SAP Reports directly into Alteryx. In this blog we will show you how to use the SAP Report tool to extract data from the PM (Plant Maintenance) Order Data transaction (T-Code IW39) into Alteryx.
Sample Alteryx Workflow: SAP General Ledger - Extract General Ledger Accounting Data (Table Extract)
With the Holiday season up on us we are offering a free 60-day no-obligation trial of the ACS for Alteryx Server to all current paid customers who register their interest with the ACS Sales Team on or before 31 December 2021.
The DVW Alteryx Connector for SAP allows Alteryx users to build SAP-based workflows on Alteryx Designer with the ACS for Alteryx Designer. But what if you want to schedule those workflows or make them available to non-Alteryx Designer users to consume on-demand? This is where Alteryx Server and the ACS for Alteryx Server come in.
On-Demand Webinar: Accelerate your SAP ECC to SAP S/4HANA Data Migration with Alteryx & DVW Analytics
Tick-tock. Tick-tock. The SAP S/4HANA countdown timer - just - won't - stop.
If you are having a physical reaction to these words, you are in good company!
Watch this on-demand webinar to learn how Alteryx and DVW Analytics can help you to reduce the cost, time and risk associated with your SAP ECC to SAP S/4HANA data migration.
Professionals in the Audit function can often find themselves diving into large "haystacks" of data to find very small "needles".
With each passing year those haystacks are getting bigger and the needles harder to find.
Join this on-demand webinar to find out how Alteryx can streamline your SAP audit processes; bringing accelerated, dynamic, and automated solutions, with the possibility of predictive analysis in a package that is easy to use by experts and novices alike.
To extract SAP Transaction Code (T-Code) data from a wide range of SAP systems, including SAP ECC and SAP S/4HANA, directly into Alteryx then you will need the SAP Report tool. The SAP Report tool is just one of a collection of tools that comprise the DVW Alteryx Connector for SAP.
In this blog we will show you how the SAP Report tool works by demonstrating the extraction of data from the G/L Account Line Item Display transaction (T-Code FBL3N).
An increasing number of our customers have embraced Analytic Process Automation (APA) with Alteryx and are looking to write data from Alteryx into SAP BW. This is where the SAP BW Write tool comes in. A premium add-on to the DVW Alteryx Connector for SAP, the SAP BW Write tool is used to load data from Alteryx workflows directly into SAP BW InfoProviders (InfoCube and ODS Objects).
Saved attachments held in SAP give invaluable insights when viewing individual documents in the SAP GUI, but bring pain to those who need to get visibility of a range of these. Even more so if you are looking to view, archive or migrate documents on mass.
The DVW Alteryx Connector for SAP provides tools which allow you to easily identify, extract and file all the required attachments in a single workflow. This process could also be scheduled to run automatically using dynamic control parameters on the Alteryx Server (or Analytics Hub).
Professionals in the Audit function can often find themselves diving into large "haystacks" of data to find very small "needles". With each passing year those haystacks are getting bigger and the needles harder to find.
Read on to understand how Alteryx can streamline your audit processes; bringing accelerated, dynamic, and automated solutions, with the possibility of predictive analysis in a package that is easy to use by experts and novices alike.
In this blog we present a list of the most commonly used SAP Transactions (T-Codes) and the DVW ACS tools that can be used to either read (extract) data from them or write (load / create / update) data to them.
The list of T-Codes was compiled based on a combination of web search and personal experience. So, if there's a particular T-Code that is used extensively within your company and is not on this list, let us know and we will update the blog with details.
Analytic Process Automation in action - Posting SAP G/L Account Documents with Alteryx & the DVW Alteryx Connector for SAP
Analytic Process Automation in action - Creating SAP Sales Orders with Alteryx & the DVW Alteryx Connector for SAP
Many of you will already be familiar with the capabilities of the DVW Alteryx Connector for SAP in reading (extracting) data from a wide range of SAP systems and sources into Alteryx.
Enabling Analytic Process Automation in an SAP context however requires the ability not only to read data but to write (load) it back into SAP.
Thanks to everyone who joined Alteryx, DVW Analytics and Coca-Cola European Partners for, "Analyse and Automate your SAP data".
The webinar is now available on-demand. So, if you missed it first time around or just want to relive the "magic" again, read on.
View this on-demand webinar to learn how we’ve enhanced the functionality and capability of the DVW Alteryx Connector for SAP (ACS) with version 2.1.2018, our first major release since 2019.
Tax, Audit & Finance - Extract Sales & Purchasing Tax Data from SAP ECC & SAP S/4HANA using Alteryx & the DVW Alteryx Connector for SAP
The use of Alteryx within the Tax, Audit and Finance functions is a particularly hot topic at the moment and with good reason. Alteryx can help users across the Tax, Audit, and Finance offices to significantly reduce the time and effort spent manually gathering data and reconciling business and legal entities, along with generating their internal and regulatory reporting.
All of this is true, but if the majority of the data you need to access resides in an SAP system you will need the DVW Alteryx Connector for SAP to streamline the import of that data into Alteryx.
SAP Data Migration - Load SAP ECC Pricing Condition Record Data into SAP S/4HANA using Alteryx & the DVW Alteryx Connector for SAP
The SAP Report tool is used to extract data from SAP Transaction Codes (T-Codes) and SAP Reports directly into Alteryx.
In this blog we will show you how to use the SAP Report tool to extract data from the SAP Vendor Line Item Display transaction (T-Code FBL1N) into Alteryx.
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.
How to extract attachments for SAP ECC & SAP S/4HANA Plant Maintenance and Customer Service documents into Alteryx
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.
On-Demand Webinar: SAP for everyone - An introduction to SAP data preparation and analytics with Alteryx
Business users want to power their analytics with SAP data. But, working with SAP data can be cumbersome, time-consuming and costly.
Join this on-demand webinar to learn how you can easily extract data from SAP; consume that data in almost any way you choose and then automate the whole process. Instead of extracting your SAP data manually using common techniques - learn how you can use Alteryx and the DVW Alteryx Connector for SAP (ACS) to do the job for you.
Watch this On-Demand webinar to learn:
© COPYRIGHT 2003 - 2022 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.