Important SAP tables in Financial Accounting and Conrolling Module

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

 

Leave a Reply

Your email address will not be published. Required fields are marked *