- PRODUCTS
- SERVICES
- DEMOS
- FREE TRIAL
- PRICING
-
RESOURCES
-
WEBINARS
>
- ON-DEMAND WEBINAR: SAP IN ALTERYX DESIGNER AND SERVER 101 - LEARN HOW TO ACCESS YOUR DATA LIKE A PRO
- ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA WITH COCA-COLA EUROPEAN PARTNERS
- ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA FULL DEMO
- ON-DEMAND WEBINAR: DETAILED WALKTHROUGH OF THE ALTERYX CONNECTOR FOR SAP
- ON-DEMAND WEBINAR: WHAT'S NEW WITH THE ALTERYX CONNECTOR FOR SAP
- 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 >
- FAQ
- LICENSE
- RESELLER RESOURCES
- GETTING STARTED
- INSTALLATION GUIDES
- SOFTWARE DOWNLOADS
- TUTORIALS
- SAMPLE WORKFLOWS
-
WEBINARS
>
- BLOG
- ABOUT
In this blog we identify the SAP Finance and Controlling (FI/CO) tables that users of KNIME and the DVW KNIME Connector for SAP should know. The following SAP sytems contain SAP Finance and Controlling tables:
The "Big Two" SAP Financial Accounting (FI) Transaction Data Tables
Table BKPF holds the Header data for all Financial transactions in SAP while table BSEG holds the Segment or Item data for all Financial transaction in SAP. In Alteryx you will typically extract data from both tables in order to get the full picture for a Financial transaction. There are a number of other SAP Financial Accounting transaction tables that can be used in association with BKPF and BSEG. Tables that can be used with BKPF:
Tables that can be used with BSEG:
The following SAP Financial Accounting transaction tables are also useful and can be used in association with table BKPF:
Key SAP Controlling (CO) Transaction Data TablesCost Centre Accounting
Profit Centre Accounting
Important SAP Finance and Controlling (FI/CO) Master Data TablesGeneral Ledger
Cost Centre
Cost Element
Profit Centre
Accounts Payable - Vendor Master DataVendor Master - General Data
Vendor Master - Purchasing Data
Vendor Master - Company Code Data
Accounts Receivable - Customer Master DataCustomer Master - General Data
Customer Master - Sales Area Data
Customer Master - Company Code Data
Useful SAP Finance and Controlling (FI/CO) Configuration Data Tables
SAP S/4HANA Finance Tables
With SAP S/4HANA, table ACDOCA contains all the Item data for Finance ( Controlling (CO) and Asset Accounting (AA). ACDOCA can be used as an alternative to:
Table BKPF still holds the Header data for all Financial transactions in SAP S/4HANA. Comments are closed.
|
Categories
All
Archives
December 2020
|
PRODUCTSALTERYX CONNECTOR FOR SAP
ALTERYX CONNECTOR FOR BUSINESSOBJECTS ALTERYX CONNECTOR FOR SUCCESSFACTORS SAP METADATA CONNECTOR FOR ALTERYX CONNECT KNIME CONNECTOR FOR SAP SERVICESDEMOSFREE TRIAL |
PRICINGBLOGABOUT USCONTACT US |
DVW Analytics, from De Villiers Walton, is dedicated to bringing the power of SAP to users of Alteryx, KNIME, Tableau & other global leaders in BI and analytics. |
© COPYRIGHT 2003 - 2020 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. |