DVW ANALYTICS
  • PRODUCTS
    • ALTERYX CONNECTOR FOR SAP
    • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • ALTERYX CONNECTOR FOR SAP CLOUD
    • ALTERYX SAP BW WRITE TOOL
    • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • BLOG
    • WEBINARS >
      • ON-DEMAND WEBINAR: HOW TO INSTALL & USE THE ALTERYX CONNECTOR FOR SAP V2
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP FOR ALTERYX USERS
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP DATA PREP & ANALYTICS WITH ALTERYX
      • ON-DEMAND WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • EVENTS >
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

Using the Alteryx Connector for SAP with SAP S/4HANA

18/1/2017

0 Comments

 
Picture
The Alteryx Connector for SAP, works with SAP S/4HANA (AKA SAP Business Suite 4 SAP HANA) on-premise edition in the same way as it does for SAP’s Business Suite solutions (ECC, CRM etc.).

Take a look at this short demo of the Alteryx Connector for SAP (ACS) being used with an SAP S/4HANA system.
If you are interest in a detailed walkthrough of the ACS please go to our demo page.

Apart from the use of the in-memory SAP HANA database a key feature of S/4HANA is the simplified data model that has been implemented by SAP. This new data model makes it even easier for users with limited knowledge of SAP to access the data they need.

Let’s consider the Sales and Distribution area of SAP.

In SAP ECC we have the following tables (NOTE: This is not an exhaustive list):

Primary Document
  • VBAK (Sales Document: Header Data)
  • VBAP (Sales Document: Item Data)
  • LIKP (SD Document: Delivery Header Data)
  • LIPS (SD document: Delivery: Item data)
  • VBRK (Billing Document: Header Data)
  • VBFA (Sales Document Flow)

Foreign Trade (Export / Import) Tables
  • EIKP (Foreign Trade: Export/Import Header Data)
  • EIPO (Foreign Trade: Export/Import: Item Data)

Status Tables
  • VBUK (Sales Document: Header Status and Administrative Data)
  • VBUP (Sales Document: Item Status)

LIS Tables
  • S066 (Open orders: credit management)
  • S067 (Open deliveries/billing documents KM)

Index Tables
  • VAPMA (Sales Index: Order Items by Material)
  • VLPMA (SD Index: Delivery Items by Material)
  • VLKPA (SD Index: Deliveries by Partner Functions)
  • VRPMA (SD Index: Billing Items per Material)
  • VRKPA (Sales Index: Bills by Partner Functions)

Rebate Index
  • VBOX (SD Document: Billing Document: Rebate Index)

Output Management
  • NAST (Message Status)

​With SAP S/4HANA this has been simplified to:
  • VBAK (Sales Document: Header Data)
  • VBAP (Sales Document: Item Data)
  • LIKP (SD Document: Delivery Header Data)
  • LIPS (SD document: Delivery: Item data)
  • VBRK (Billing Document: Header Data)
  • VBRP (Billing Document: Item Data)
  • VBFA (Sales Document Flow)

In ECC, if I want to understand Sales Order status, I need to consider at least VBAK and VBUK. With S/4HANA, sales document status has been moved out of VBUK and into VBAK so I only need to consider the VBAK table. A simple example but when you consider the type of simplification across the system a significant one.

If you are interested in a trial of the Alteryx Connector for SAP to use with SAP S/4HANA, SAP Business Suite or SAP BW click on the button below.
GET A FREE TRIAL OF THE DVW ALTERYX CONNECTOR FOR SAP
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    RSS Feed

    Categories

    All
    ACS
    ACS BusinessObjects
    ACS BW Write
    ACS Cloud
    ACS Metadata
    Alteryx
    BusinessObjects
    Consulting
    Inspire
    Jobs
    Microsoft Azure
    Microsoft Power BI
    Predictive Analytics
    Qlik
    Salesforce
    Salesforce Wave Analytics
    SAP BusinessObjects
    SAP Business Suite
    SAP BW
    SAP Data Migration
    SAP Document Tool
    SAP ECC
    SAP ERP
    SAP HANA
    SAP IDoc Tool
    SAP Read Tools
    SAP Report Tool
    SAP S/4HANA
    SAP Table Data Tool
    SAP Tables
    SAP Transaction Codes
    SAP Write Tools
    Services
    Tableau
    Tableau Prep
    TCS
    Training
    Webinar

    Archives

    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    March 2019
    September 2018
    August 2018
    June 2018
    May 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 CONNECTOR FOR SAP
​
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
ALTERYX CONNECTOR FOR SAP CLOUD
​ALTERYX SAP BW WRITE TOOL
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 DESIGNER

DEMOS

BLOG

ABOUT US

CONTACT US

DVW Analytics by 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 - 2019 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.

SAP® Business Suite, SAP® BusinessObjects™, SAP® BW are the trademarks or registered trademarks of SAP SE in Germany and in several other countries.
PRIVACY POLICY
  • PRODUCTS
    • ALTERYX CONNECTOR FOR SAP
    • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • ALTERYX CONNECTOR FOR SAP CLOUD
    • ALTERYX SAP BW WRITE TOOL
    • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • BLOG
    • WEBINARS >
      • ON-DEMAND WEBINAR: HOW TO INSTALL & USE THE ALTERYX CONNECTOR FOR SAP V2
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP FOR ALTERYX USERS
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP DATA PREP & ANALYTICS WITH ALTERYX
      • ON-DEMAND WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • EVENTS >
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS