This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
Reject
Welcome to the Gallery. Please feel free to post and comment, and check out our FAQ!
community Data Science Portal Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Community Gallery

Post, download, and share all of your favorite tools and workflows — from Alteryx supported to user-built.
SAP Sales - Extract Sales Document Data, Customer Master Data and Configuration Data
Workflows Uploaded by on 01-07-2022 Downloaded 27 times
  • Partner
  • Prep and Blend
  • SAP
  • Workflows
    • Download
    Post Comment

    Description

    This workflow from DVW Analytics uses the Alteryx Connector for SAP (ACS) to demonstrate how to extract  Sales Document Data, Customer Master Data and Configuration Data from SAP ECC & SAP S/4HANA into Alteryx.
    Jie_DvW_0-1641547716048.png

     

    This workflow provides:

    1. Examples of how to extract data from Sales Document Header (VBAK) and Item (VBAP) tables, Delivery Document Header (LIKP) and Item (LIPS) tables and Billing Document Header (VBRK) and Item (VBRP) tables.

    2. Examples of the primary Customer Master Data tables ( KNA1, KNB1, KNKK, KNVV).

    3. Examples of important Configuration Data tables including Sales Organizations (TVKO, TVZBT, TVFKT, AUFK).

     

    • Works with: SAP ECC & SAP S/4HANA
    • SAP Read Tools used: SAP Table Data tool, ACS Filter tool
    • SAP Write Tools used: N/A

     

    Attachments
    Extract SAP Sales Document Data, Customer Master Data and Configuration Data from SAP ECC & SAP S_4HANA.yxmd