SAP General Ledger - Extract General Ledger Accounting Data (Table Extract)

[#1]

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

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.

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 DVW 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