Sample Alteryx Workflow: SAP General Ledger - Extract General Ledger Accounting Data (Table Extract)

This workflow from DVW Analytics uses the Alteryx Connector for SAP (ACS) to demonstrate how to extract SAP General Ledger Accounting data from the "Big Two" SAP Financial Accounting (FI) Transaction Data Tables: BKPF (Accounting Document Header) and BSEG (Accounting Document Segment).

The workflow is available for download from the Alteryx Community Gallery along with our other sample workflows.

DOWNLOAD WORKFLOW FROM ALTERYX COMMUNITY GALLERY

This particular workflow is the starting point for many of our users in Finance, Tax and Audit who need the level of granularity that SAP Table data can provide.

The pattern established in this workflow can be applied to all other areas of SAP including (but not limited to) Sales & Distribution,  Materials Management, Plant Maintenance etc.

The workflow works with SAP ECC and SAP S/4HANA.

While you are here, check out this recording of the DVW Financial Reporting for SAP using Alteryx & DVW Analytics webinar which shows how you can you easily extract data from SAP Tables, SAP T-Codes and Reports, SAP BW Queries and more with the Alteryx Connector for SAP to accelerate and automate your reporting in areas such as:
​

• Accounts Payable and Account Receivable Reporting
• Asset Lifecyle Reporting
• Cash Management Reporting
• Management Accounting Reporting
• Product Costing Reporting and Profitability Analysis
• Tax Reporting
• Treasury and Risk Management Reporting