In this blog we identify the most important SAP Finance and Controlling (FI/CO) tables for users of:
SAP Finance and Controlling tables are found in the following SAP systems:
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. The following tables can be used with BKPF:
The following tables can be used with BSEG:
In addition to the above the following SAP Financial Accounting transaction tables are useful to know:
Tables BSEC and BSET 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. Other Sources of SAP Table InformationGoogle is your best friend when searching for SAP Table data. Give it a go!
Comments are closed.
|
Categories
All
Archives
November 2024
|
ProductsAlteryx Connectors
KNIME Connectors Power BI Connectors Tableau Connectors Dataiku Connectors Snowflake Connectors Free TrialAlteryx Connectors
Free Trial of Alteryx Connector for SAP Free Trial of Alteryx RPA Tools Free Trial of Alteryx Connector for SAP CX Free Trial of Alteryx Connector for SAP SuccessFactors Free Trial of Alteryx Connector for SAP IBP Free Trial of Alteryx Connector for SAP Ariba Free Trial of Alteryx Connector for SAP BusinessObjects KNIME Connectors Free Trial of KNIME Connector for SAP Power BI Connectors Free Trial of Power BI Connector for SAP Tableau Connectors Free Trial of Tableau Connector for SAP Dataiku Connectors Free Trial of Dataiku Connector for SAP Snowflake Connectors Free Trial of Snowflake Connector for SAP DVW Flow Tool Free Trial of DVW Flow Tool |
ServicesPricingDemosBlogHelp CentreAbout UsContact Us |
DVW Analytics brings the power of SAP to users of Alteryx, KNIME, Power BI, Dataiku and other global software leaders. |
© COPYRIGHT 2003 - 2024 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. |