Tables in SAP FICO – List of Top 100 with details (2022)
SAP FICO tables | Important SAP FI Tables List
![Tables in SAP FICO – List of Top 100 with details (2022)](https://sapmantra.com/blog/uploads/images/202305/image_750x_64577200cdfb3.jpg)
What are Tables in SAP FICO?
Tables in SAP are a storage space in SAP Database that segments and stores data module-wise. Say, for example, we enter any data like Configuration Data, Master data, and Transaction data. Here SAP Tables in SAP FICO store them properly and in order in the SAP Database.
What is the use of Tables in SAP FICO?
There are certain Tables, in SAP that when changed will not affect a similar Table in other clients. There are known as “Client-Dependent” Tables. All the client-dependent Tables will have their first field as “Mandt”. Example LFA1.On the other hand, if a change is made in one Table, it is reflected in a similar Table across various Clients. Then such a Table will be called “ Client Independent”. In this case, the first field of the Table will not be “Mandt”.
Internal Tables
There are also other types of Tables known as Internal Tables. These are standard data type objects which exist only during the “runtime” of an ABAP program. They are used to perform calculations on subsets of database Tables. Further, they help us to reorganize the contents of database Tables according to the user’s needs. Internal Tables fulfil the need for arrays in ABAP.
Types of Tables in SAP FICO
There are three types of Internal Tables-
- Standard Tables with “linear” index. The key is always “non-unique”.
- Stored Tables with either “unique” or “non-unique” keys.
- Hashed Tables (they do not have a linear index) with key defined always as unique.
Now let us see the list of the Most Important Tables in SAP FICO i.e. in SAP Financial Accounting and SAP Controlling.
SAP FI Tables List – Financial Accounting
SAP Financial Accounting handles the financial obligations of the business. It enables company-wide control and integration of financial information. It is essential for strategic decision-making. Further, the SAP Finance component within SAP Financials has several new functions. Its modern enhancements help to meet today’s financial and management requirements in accounting and reporting.
Below are the key Tables in SAP FI which are most commonly used.
List of SAP Controlling Tables
SAP Controlling is a vital part of SAP FICO which is as important as SAP Financial Accounting. As you know Financial Accounting deals with the external reporting of the business. Whereas Controlling helps to report all costs and Profitability Analysis to the internal management. Further, it helps improve management across the financial spectrum by Planning and analyzing costs to deliver reports that influence decision-making.
Let us see the Most Important Tables in SAP Controlling.
Table Name | Table Code |
---|---|
Activity Type Master | CSLA |
Assignment of Work Center to Cost Center | CRCO |
Control Data for Activity Type | COKL |
Control Data for Cost Center | COKA |
Primary Cost Element-Control Data | COKP |
Secondary Cost Element-Control Data | COKS |
Statistical Key Figure | COKR |
Cost Object Document Header | COBK |
Cost Object Line Item ( By Year) | COEJ |
Cost Object Line Item ( By period) | COEP |
Line Items Activity Type | COEPL |
Line Item for SKF | COEJR |
CO Versions | TKVS |
Controlling Area | TKA01 |
Cost Center/Activity Type | CSSL |
Cost Center/Cost Element | CSSK |
Cost Center Master Data | CSKS |
Cost Element-Chart of Account | CSKA |
Cost Element-Company Code | CSKB |
Controlling Object-Header | BPBK |
Settlement-Header | AUAK |
EC-PCA | GLPCA |
EC-PCA-Plan Line Items | GLPCP |
Cost Total-External Posting | COSP |
Cost Total-Internal Posting | COSS |
Order Master Data | AUFK |
PCA Total Table | GLPCT |
Profit Center Master Data | CEPCT |
Distribution Settlement Document | AUAB |
Why Learn Them?
The Tables in SAP FICO are used by FICO Consultants and users. They access them to fetch required data to use or refer to for any configuration work or resolving issues.Not just this, interviews also ask about some mostly used tables in SAP FICO interviews to check the core knowledge of contestants.
Learn them and understand them so as to work better and build a good career in SAP FICO.
(AASHIT SRIVASTAVA)
What's Your Reaction?
![like](https://sapmantra.com/blog/assets/img/reactions/like.png)
![dislike](https://sapmantra.com/blog/assets/img/reactions/dislike.png)
![love](https://sapmantra.com/blog/assets/img/reactions/love.png)
![funny](https://sapmantra.com/blog/assets/img/reactions/funny.png)
![angry](https://sapmantra.com/blog/assets/img/reactions/angry.png)
![sad](https://sapmantra.com/blog/assets/img/reactions/sad.png)
![wow](https://sapmantra.com/blog/assets/img/reactions/wow.png)