Blog - DVW Analytics

Using the most commonly used SAP Transactions (T-Codes) with Alteryx

16/7/2020

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

15/7/2020

The manual posting of General Ledger documents is a major headache for many SAP customers. With the DVW Alteryx Connector for SAP you can now automate that process using Alteryx.

Analytic Process Automation in action - Creating SAP Sales Orders with Alteryx & the DVW Alteryx Connector for SAP

26/6/2020

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.

On-Demand Webinar: Analyse + Automate Your SAP Data

20/6/2020

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.

On-Demand Webinar: What's new with the DVW Alteryx Connector for SAP

28/5/2020

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.

Sample Alteryx workflows that use SAP Finance and Controlling data

27/2/2020

In a previous blog we identified the most important SAP Finance and Controlling (FI/CO) tables for Alteryx users.
In this blog we go a step further and present a set of predefined workflows for you to use with Alteryx and the DVW Alteryx Connector for SAP.

Sample Alteryx workflows that use SAP Purchasing data

26/2/2020

In a previous blog we identified the most important SAP Purchasing (MM-PUR) tables for Alteryx users. In this blog we go a step further and present a set of predefined workflows for you to use with Alteryx and the DVW Alteryx Connector for SAP.

Tax, Audit & Finance - Extract Sales & Purchasing Tax Data from SAP ECC & SAP S/4HANA using Alteryx & the DVW Alteryx Connector for SAP

20/2/2020

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

16/11/2019

In this demo we will show you how Alteryx and the DVW Alteryx Connector for SAP can be used to migrate SAP ECC Pricing Condition Records to SAP S/4HANA.

Extract SAP Vendor Line Item data into Alteryx (T-Code FBL1N)

7/10/2019

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.

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

13/9/2019

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

31/8/2019

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.

Join us at Alteryx Inspire Europe 2019 and see the Alteryx Connectors for SAP and BusinessObjects in action

30/8/2019

We're running out of superlatives to describe the quality of the Alteryx Inspire events. Alteryx Inspire 2019 in Nashville was spectacular and we have high hopes for this year's Alteryx Inspire Europe in London.

On-Demand Webinar: SAP for everyone - An introduction to SAP data preparation and analytics with Alteryx

17/7/2019

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.

On-Demand Webinar: Detailed walkthrough of the DVW Alteryx Connector for SAP

17/7/2019

Watch this On-Demand webinar to learn:

How to install the DVW Alteryx Connector for SAP
How to use the SAP BW Read tool
How to use the SAP Table Data tool and Filter tool
How to use the SAP Query tool
How to use the SAP Report tool
Important sources: Installation Guide / Tutorials / Software

Learn how you can easily extract SAP General Ledger accounting data from SAP ECC & SAP S/4HANA using Alteryx & the DVW Alteryx Connector for SAP

7/6/2019

In this blog we will show you how you can easily extract SAP General Ledger Accounting Data from SAP ECC & SAP S/4HANA into Alteryx with the DVW Alteryx Connector for SAP.

The most important SAP Inventory Management tables for Alteryx users

18/5/2019

In this blog we identify the most important SAP Inventory Management tables for users of Alteryx and the DVW Alteryx Connector for SAP.

The most important SAP Purchasing (MM-PUR) tables for Alteryx users

18/5/2019

In this blog we identify the most important SAP Purchasing (MM-PUR) tables for users of Alteryx and the DVW Alteryx Connector for SAP.

The most important SAP Sales and Distribution (SD) tables for Alteryx users

17/5/2019

In this blog we identify the most important SAP Sales and Distribution (SD) tables for users of Alteryx and the DVW Alteryx Connector for SAP.

The most important SAP Finance and Controlling (FI/CO) tables for Alteryx users

17/5/2019

In this blog we identify the most important SAP Finance and Controlling (FI/CO) tables for users of Alteryx and the DVW Alteryx Connector for SAP.

Join us at Alteryx Inspire 2019 and see the Alteryx Connectors for SAP and BusinessObjects in action

14/5/2019

Alteryx Inspire is simply the best analytics event anywhere. DVW is delighted to be a Gold Sponsor of Alteryx Inspire 2019, which is being held in Nashville from June 10 to June 14, 2019.

Using the DVW Tableau Connector for SAP with Tableau Prep

24/3/2019

The DVW Tableau Connector for SAP ("TCS") is a flexible, fast and easy to use Desktop tool that can be used with Tableau and Tableau Prep.

In this blog we will use the TCS to extract data from two commonly used SAP finance tables, import the data into Tableau Prep, create a Join between the table data in Tableau Prep and generate an output file ready for consumption in Tableau.

Accelerate your SAP and Salesforce migrations with Alteryx and the DVW Alteryx Connectors for SAP

30/9/2018

Alteryx is recognised as a leader in the self-service data analytics movement, yet it’s data blending capabilities lend it to use cases beyond those of interest to its core data analytics audience.

In this blog, we’ll consider the use of Alteryx to accelerate the migration of data from one enterprise application software product to another. Specifically, we’ll look at the migration of data from one Customer Relationship Management (CRM) solution to another.

We're Hiring! Data Analytics Customer Success Engineers (FT and PT Roles)

16/9/2018

Due to a period of rapid growth, we are looking for Data Analytics Customer Success Engineers to join our Customer Success Team. We have Full-Time and Part-Time roles available available for UK-based candidates. If you have an SAP background and are interested in cross-training into Alteryx and Tableau, take a look at the roles below!

If I plan to use SAP HANA CDS Views with Alteryx, do I still need the Alteryx Connector for SAP?

23/8/2018

The use of SAP HANA CDS Views and the Alteryx Connector for SAP (ACS) with Alteryx is not mutually exclusive. Whether you should use one, the other or both depends upon a number of different factors.

PRODUCTS

ALTERYX CONNECTOR FOR SAP
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
ALTERYX CONNECTOR FOR SUCCESSFACTORS
ALTERYX CONNECTOR FOR SAP CLOUD
SAP METADATA CONNECTOR FOR ALTERYX CONNECT

SERVICES

PROFESSIONAL SERVICES
TRAINING

FREE TRIAL

FREE TRIAL OF ALTERYX CONNECTOR FOR SAP
FREE TRIAL OF ALTERYX CONNECTOR FOR BUSINESSOBJECTS
FREE TRIAL OF ALTERYX CONNECTOR FOR SUCCESSFACTORS

DEMOS

BLOG

ABOUT US

CONTACT US

DVW Analytics, from De Villiers Walton, is dedicated to bringing the power of SAP to users of Alteryx, Tableau & other global leaders in BI and analytics.

© COPYRIGHT 2003 - 2020 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.