SAP FICO

Tables in SAP FICO – List of Top 100 with details (2022)

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.

Related: SAP HANA In-Memory Database

Types of Tables in SAP FICO

There are three types of Internal Tables-

  1. Standard Tables with “linear” index.  The key is always “non-unique”.
  2. Stored Tables with either “unique” or “non-unique” keys.
  3. 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.

Table NameTable Code
GL Account Master- Chart of AccountSKA1
AR and AP information SystemsRFRR
Correspondence RequestBKORM
Accounting Document HeaderBKPF
Accounting Document-Line ItemBSEG
Accounting Document-Line Item-New GLFAGLFLEXA
Index –Customer Open ItemBSID
Index –Customer Cleared ItemBSAD
Index-GL Accounts-Open ItemsBSIS
Index- GL Accounts  Cleared ItemsBSAS
Index-Vendor Open ItemsBSIK
Index-Vendor Cleared ItemsBSAK
Depreciation AreaANKB
Asset Class-DescriptionANKT
Asset Class-General DataANKA
Asset Class-Insurance TypeANKV
Asset Down Payment SettlementANEV
Asset Line ItemsANEP
Asset Master Record SegmentANLA
Asset Master Record SegmentANLX
Asset Master Record User FieldsANLU
Asset Periodic ValuesANLP
Asset TextsANLT
Asset TypeANAR
Asset Value FieldsANLC
Bank Master RecordBNKA
Business Partner -General DataBP000
Cash Management Line Item in Payment RequestFDZA
Create GL account with ReferenceTSAK
Credit Management-FI DataKNKK
Customer/Vendor LinkingKLPA
Customer Master General DataKNA1
Customer Master Partner FunctionsKNVP
Customer Master Sales DataKNVV
Customer Master Sales RequestKNVD
Customer Master Data-Company CodeKNB1
Customer Master Bank DetailsKNBK
Customer Master Credit Management-Central DataKNKA
Customer Master Credit Management-Control Area DataKNKK
Customer Master Dunning DataKNB5
Customer Master Special GL TransactionsKNC3
Customer Master Transaction FiguresKNC1
Customer Payment HistoryKNB4
Depreciation TermsANLB
Asset Posting-HeaderANEK
Document Parking HeaderVBKP
Recurring Entry-HeaderBKDF
Document Type TextT003T
Dunning DataMHNK
EBS Line EntryFEBEP
GL Account DescriptionSKAT
GL Account-Chart of AccountSKA1
GL Account-Company CodeSKB1
APP RunF111
Vendor ValidationBSIP
Inter-Company Posting ProcedureBVOR
Asset NumberANLH
Dunning Program-Management RecordMAHNV
Payment Medium FilePAYR
Pre-numbered CheckPCEC
Tax Code NamesT007S
Vendor Master General DataLFA1
Vendor Master Company CodeLFB1
Vendor Master Bank DataLFBK
Vendor Master Purchasing DataLFM2
Vendor Master Purchasing Organization DataLFM1

Also Read: Most common Tcodes in SAP FI

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 NameTable Code
Activity Type MasterCSLA
Assignment of Work Center to Cost CenterCRCO
Control Data for Activity TypeCOKL
Control Data for Cost CenterCOKA
Primary Cost Element-Control DataCOKP
Secondary Cost Element-Control DataCOKS
Statistical Key FigureCOKR
Cost Object Document HeaderCOBK
Cost Object Line Item ( By Year)COEJ
Cost Object Line Item ( By period)COEP
Line Items Activity TypeCOEPL
Line Item for SKFCOEJR
CO VersionsTKVS
Controlling AreaTKA01
Cost Center/Activity TypeCSSL
Cost Center/Cost ElementCSSK
Cost Center Master DataCSKS
Cost Element-Chart of AccountCSKA
Cost Element-Company CodeCSKB
Controlling Object-HeaderBPBK
Settlement-HeaderAUAK
EC-PCAGLPCA
EC-PCA-Plan Line ItemsGLPCP
Cost Total-External PostingCOSP
Cost Total-Internal PostingCOSS
Order Master DataAUFK
PCA Total TableGLPCT
Profit Center Master DataCEPCT
Distribution Settlement DocumentAUAB

Visit Course Page: SAP S/4HANA Finance Training

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.

Read: Common Errors in SAP FICO

Also read: Why and Who should learn SAP FICO on S/4HANA

Pradeep

Recent Posts

SAP MRP – Material Requirement Planning in Material Management

What is SAP MRP? SAP MRP (Material requirements planning) is a planning tool to help…

5 months ago

SAP Career for Freshers- What is the right process?

How is SAP Career for Freshers? SAP Career for Freshers seems challenging initially. If you've…

6 months ago

Tax on Sale Purchase in SAP S/4HANA

SAP S/4 HANA covers the business processes like Procure-to-Pay, Order-to-Cash and record-to-report. To understand the…

9 months ago

Key Objects to Configure Material Master in SAP

What do we require to Configure Material Master? Master data in materials management requires a…

9 months ago

SAP New GL Activation & Migration Process

SAP New GL Activation and Migration From Classic GL During a new installation, the New…

1 year ago

SAP Material Management – An Engine to Supply Chain

SAP Material Management in S/4HANA Logistics SAP Material Management is an integral part of Logistics.…

1 year ago