SAP Tables – SAP FICO Important tables
SAP FICO Tables- SAP Tables are used to store the data when you enter some data in a screen. Sometimes more than one table is linked to a particular screen. As an SAP fico consultant, it is mandatory you should know the table in the SAP software and its data structure.
Important Tables
SAP FI Tables
The Important tables of SAP FI tables as follows
SAP Tables – Enterprise structure
| Description | Table |
| SAP Company-Code | T001 |
| Countries in SAP | T005 |
| SAP Currency-codes | TCURC |
| Exch-rate in SAP | TCURR |
| Currency-name in SAP | TCURT |
| G/L Account-group | T077S |
| Fiscal year variants in SAP | T009 |
| Global-company-data in SAP | T880 |
| Credit-control-area SAP | T014 |
| SAP Chart of accounts (COA) | T004 |
| SAP Posting-period-variant (PPV) | T010O |
| Posting period variant names in SAP | T010P |
| Permitted posting periods in SAP | T001B |
| Document-types in SAP | T003 |
| House-banks in SAP | T012 |
SAP FI G/L Tables
| Chart of accounts segment GL master data | SKA1 |
| Company code segment G/l master data | SKB1 |
| Bank master record in SAP | BNKA |
| SAP Accounting documents header | BKPF |
| Bank master record SAP | BNKA |
| Accounting documents header in SAP | BKPF |
SAP Accounts Receivable Table
| Bank details | KNBK |
| Contact persons | KNVK |
| Customer hierarchy | KNVH |
| Customer master tax indicator | KNVI |
| Customer master—Company code data | KNB1 |
| Customer master—General data | KNA1 |
| Customer master—Sales data | KNVV |
| Customer partners | KNVP |
| Shipment data for customer | KNVS |
SAP FI Accounts payable tables
| Bank details | LFBK |
| Purchasing data | LFM2 |
| Purchasing organization data | LFM1 |
| Vendor dunning data | LFB5 |
| Vendor master—Company code data | LFB1 |
| Vendor master—General data | LFA1 |
SAP tables – Assets Accounting
| Asset classes: Depreciation area | ANKB |
| Asset classes: Description | ANKT |
| Asset classes: General data | ANKA |
| Asset line items | ANEP |
| Asset master record user fields | ANLU |
| Document header asset posting | ANEK |
| Time-dependent asset allocation | ANLZ |
SAP CO Tables
Important tables of SAP CO are as follows.
Cost Center Accounting tables
| Cost center master data | CSKS |
| Cost center texts | CSKT |
| Assignment of work center to cost center | CRCO |
| Cost totals for external postings | COSP |
| Line items (by period) | COEP |
| Document header | COBK |
| Price totals | COST |
Profit center Accounting tables
| Actual line items – Profit center | GLPCA |
| Object table for account – Profit center | GLPCO |
| Plan line items – Profit center | GLPCP |
| Transaction attributes – Profit center | GLPCC |
| Profit center master data table | CEPC |
| Texts for profit center master data | CEPCT |