We have listed all SAP tables that are used in financial and controlling module. You are requested to give your feedback and suggestions on this so that we can improve it based on your requirements.
Some of the important SAP tables used in Financial Accounting Module
SAP Table Name | Description |
Financial Accounting | |
T001 | Company Code |
T005 | Countries |
TCURC | Currency Codes |
TCURR | Exchange Rate |
TCURT | Currency Name |
T0775 | Account Group (G/L Accounts) |
T009 | Fiscal Year Variant |
T880 | Global Company Code |
T004 | Chart Of Accounts |
T009 | Fiscal Year Variant |
T010O | Posting period variant |
T010P | Posting Period variant names |
T001B | Permitted posting periods |
T003 | Document types |
SKA1 | G/L Master Chart of Accounts Segment |
SKB1 | G/L Master Company Code Segment |
BKPF | Accounting Document Header |
BSEG | Accounting Document Segment |
BSIP | Index for Vendor Validation of Double Documents |
BVOR | Inter Company Posting Procedure |
EBKPF | Accounting Document Header (docs from External Systems) |
FRUN | Run Date of a Program |
KLPA | Customer / Vendor Linking |
KNB4 | Customer Payment History |
KNB5 | Customer Master Dunning Data |
KNBK | Customer Master Bank Details |
KNC1 | Customer Master Transaction Figures |
KNC3 | Customer Master Special GL Transactions Figures |
LFB5 | Vendor Master Dunning Data |
LFBK | Vendor Master Bank Details |
LFC1 | Vendor Master Transaction Figures |
LFC3 | Vendor Master Special GL Transactions Figures |
VBKPF | Document Header for Document Parking |
KNA1 | Customer Master (General Data) |
KNB1 | Customer Master (Company Code) |
LFA1 | Vendor Master (General Section) |
LFB1 | Vendor Master (company Code Section) |
SKA1 | G/L Account Master (Chart of Accounts) |
SKAT | G/L Account Master (Chart of Accounts – Description) |
MAHNS | Accounts Blocked by Dunning Selection |
MHNK | Dunning Data (Account Entries) |
SKAS | G/L Account Master (Chart of Accounts – Key Word list) |
SKB1 | G/L Account Master (Company Code) |
FIGLREP | Settings for G/L Posting Reports |
TSAKR | Create G/L account with reference |
KOMU | Account Assignment Templates for G/L Account items |
KNKA | Customer Master Credit Management : Central Data |
KNKK | Customer Master Credit Management : Control Area Data |
KNKKF1 | Credit Management : FI Status data |
RFRR | Accounting Data – A/R and A/P Information System |
PAYR | Payment Medium File |
PCEC | Pre-numbered Check |
F111G | Global Settings for Payment Program for Payment Requests |
FDZA | Cash Management Line Items in Payment Requests |
PAYRQ | Payment Requests |
ANKA | Asset Classes: General Data |
ANKP | Asset Classes: Fld Cont Dpndnt on Chart of Depreciation |
ANKT | Asset Classes: Description |
ANKV | Asset Classes: Insurance Types |
ANLA | Asset Master Record Segment |
ANLB | Depreciation Terms |
ANLT | Asset Texts |
ANLU | Asset Master Record User Fields |
ANLW | Insurable Values (Year Dependent) |
ANLX | Asset Master Record Segment |
ANLZ | Time Dependent Asset Allocations |
ANAR | Asset Types |
ANAT | Asset Type Text |
ANEK | Document Header Asset Posting |
ANEP | Asset Line Items |
ANEV | Asset Down payment Settlement |
ANKB | Asset Class: Depreciation Area |
ANLC | Asset value Fields |
ANLH | Main Asset Number |
ANLP | Asset Periodic Values |
GB03 | Validation / Substitution User |
GB92 | Substitutions |
GB93 | Validation |
Some of the important SAP tables in Controlling Module
AUSP | Characteristic Values |
A132 | Price per Cost Center |
A136 | Price per Controlling Area |
A137 | Price per Country / Region |
COSC | CO Objects: Assignment of Original Costing Sheets |
CSSK | Cost Center / Cost Element |
CSSL | Cost Center / Activity Type |
KAPS | CO Period Locks |
CSKA | Cost Elements (Data Dependent on Chart of Accounts) |
CSKB | Cost Elements (Data Dependent on Controlling Area) |
CSKS | Cost Center Master Data |
CSLA | Activity Master |
COBK | CO Object: Document Header |
COEJ | CO Object: Line Items (by Fiscal Year) |
COEJL | CO Object: Line Items for Activity Types (by Fiscal Yr) |
COEJR | CO Object: Line Items for SKF (by Fiscal Year) |
COEJT | CO Object: Line Items for Prices (by Fiscal Year) |
COEP | CO Object: Line Items (by Period) |
COEPL | CO Object: Line Items for Activity Types (by Period) |
COEPR | CO Object: Line Items for SKF (by Period) |
COEPT | CO Object: Line Items for Prices (by Period) |
COKA | CO Object: Control Data for Cost Elements |
COKL | CO Object: Control Data for Activity Types |
COKP | CO Object: Control Data for Primary Planning |
COKR | CO Object: Control Data for Statistical Key Figures |
COKS | CO Object: Control Data for Secondary Planning |
COFI01 | Object Table for Reconciliation Ledger COFIT |
COFI02 | Transaction Dependent Fields for Reconciliation Ledger |
COFIP | Single Plan Items for Reconciliation Ledger |
COFIS | Actual Line Items for Reconciliation Ledger |
A138 | Price per Company Code |
A139 | Price per Profit Center |
AUAA | Settlement Document: Receiver Segment |
AUAB | Settlement Document: Distribution Rules |
AUAI | Settlement Rules per Depreciation Area |
AUAK | Document Header for Settlement |
AUAO | Document Segment: CO Objects to be Settled |
AUAV | Document Segment: Transactions |
COBRA | Settlement Rule for Order Settlement |
COBRB | Distribution Rules Settlement Rule Order Settlement |
AUFK | Order Master Data |
AUFLAY0 | Enttity Table: Order Layouts |
CEPC | Profit Center Master Data Table |
CEPCT | Texts for Profit Center Master Data |
CEPC_BUKRS | Assignment of Profit Center to a Company Code |
GLPCA | EC-PCA: Actual Line Items |
GLPCC | EC-PCA: Transaction Attributes |
GLPCO | EC-PCA: Object Table for Account Assignment Element |
GLPCP | EC-PCA: Plan Line Items |
A141 | Dependent on Material and Receiver Profit Center |
A142 | Dependent on Material |
A143 | Dependent on Material Group |
Note: SAP and SAP logo is a registered trademark of SAP AG in Germany and in several other countries. We are not affiliated or related to any division or subsidiary of SAP AG.