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

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

 
Picture
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.
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.

The SAP General Ledger Document

Picture
SAP uses a document concept for business transactions in which there is Header data and Item or Segment data. 

​In order to get the full picture for an SAP financial transaction in Alteryx you will need to extract both Header data and Item or Segment data.

The “Big Two” SAP Financial Accounting Tables 

There are thousands of data tables in an SAP system. So how do you identify which tables you need to access? Unless you have developer level access, it can be difficult, but we have already done the heavy lifting for you with our blog on, the most important SAP Finance and Controlling (FI/CO) tables for Alteryx users. Barring this, Google is a great source for SAP table data information.

For SAP General Ledger accounting data there are two important tables that hold the Header data and Item or Segment data for all Financial transactions in SAP. By combining data from the two tables we can effectively recreate SAP Financial Accounting documents within Alteryx.
The tables are:
  • Accounting Document Header – BKPF
  • Accounting Document Segment - BSEG
Picture
Both tables share common fields:
  • Company Code - BUKRS
  • Accounting Document Number - BELNR
  • Fiscal Year – GJAHR
​In our workflow we will use these fields in the BKPF table to find the corresponding entries in the BSEG table.

How to extract General Ledger accounting data using Alteryx and the DVW ACS for Alteryx Designer

So, we’ve established that we need to extract data from two SAP tables:
  • Accounting Document Header – BKPF
  • Accounting Document Segment - BSEG
To achieve this, we are going to use 2 workflows, a “Caller” workflow and a “Callee” workflow. 
Picture
The “Caller” workflow will be used to extract data from the Header table, BKPF. 

Key fields from BKPF will be passed to the “Callee” workflow to support the extract of data from the Segment table, BSEG. 

​The “Callee” workflow will pass the data extracted from BSEG back to the “Caller” workflow, where it will be combined with the data extracted from BKPF to provide us with a complete picture of a financial transaction. 

​Let’s take a look at how the two workflows are defined.

Step 1

Picture
The SAP Logon tool passes your SAP system details & user credentials to the ACS for Alteryx Designer tools that connect to it. 
​
In this workflow, the details are passed to the SAP Table Data tool.

Step 2

Picture
​SAP table, BKPF (Accounting Document Header) is selected in the SAP Table Data tool along with the fields that will (a) be used to select BSEG (Accounting Document Segment) data and (b) included in the workflow output
Picture

Step 3

Picture
​This branch of the workflow passes the data extracted from the BKPF table to the Join tool. This step ensures that the data extracted from the BKPF table will be incorporated into the final workflow output.

Step 4

Picture
The Filter tool controls which fields from table BKPF will be used to select data from table BSEG. In this workflow the following BKPF fields are used to select the required data from BSEG: 
  • Company Code - BUKRS
  • Accounting Document Number - BELNR
  • Fiscal Year – GJAHR
The Filter tool also controls the number of BKPF records that will be passed to the “Callee” workflow to select BSEG data, at a time. In our example we will pass records in batches of 8,000 records.
Picture

Step 5

Picture
​The outputs from the Filter tool are passed to a macro which handles the extract of data from table BSEG. The macro calls the “Callee” workflow.

Step 6

Picture
​This workflow uses “GroupId” as the Control Parameter.

Step 7

Picture
The Macro Input tool macro receives data from SAP table BKPF as inputs from the “Caller” workflow.
​
In order to pass the BKPF table data correctly to the SAP Table Data tool a Text Input Template is defined. 
Picture
​BKPF table data is passed as a dynamic input selection into the SAP Table Data tool.

Step 8

Picture
SAP table, BSEG (Accounting Document Segment) is selected in the SAP Table Data tool along with the fields that will be included in the workflow output.
Picture

Step 9

Picture
​The Macro Output tools enables the data output from the SAP Table Data tool to be passed back to the "Caller" workflow.

Step 10

Picture
​The results of the “Callee” workflow can be viewed by clicking the output port of the Macro.
Picture

Step 11

Picture
​The data extracted from table BKPF and BSEG are joined using the Join tool.

​The join is created on common fields:
  • Company Code - BUKRS
  • Accounting Document Number - BELNR
  • Fiscal Year – GJAHR
Picture

Step 12

Picture
​This branch of the workflow displays the combined BKPF/BSEG output using  SAP table Technical Field Names as column headers.
Picture

Step 13

Picture
The branch of the workflow enables the display of SAP table Field Descriptions rather than Technical Names as column headers in the output.
​
The Select tool is used to define which fields will be displayed in the output.

Step 14

Picture
​The Field Info tool provides the Field Descriptions for the selected fields.
Picture

Step 15

Picture
​The Dynamic Rename tool is used to ensure that the Description of the field rather than the Name of the field is used in the column headers.
Picture

Step 16

Picture
​The Browse tools shows the final combined BKPF/BSEG output with the descriptive column headers.
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