Important SAP FICO Tables

This page contains information about various important SAP FICO Tables. This is an ever-evolving page, so if you do not find details of any table or if you are looking for information related to some specific table do let us know in comment section.

Enterprise structure / SAP FICO Basis Customizing SAP Tables

Table Description	Table Name
1. Clients	T000
2. Company Codes	T001
3. Global Company Data	T880
4. T Document Types	T003
5. Directory of Charts of Accounts	T004
6. G/L account groups	T077S
7. Fiscal Year Variants	T009
8. Credit control areas	T014
9. Posting period variant	T010O/P
10. Permitted Posting Periods	T001B
11. Language Keys	T002
12. T Countries	T005
13. Units of Measurement	T006
14. T Business Areas	TGSB

General ledger G/L accounts related SAP Tables

Table Name	Table Description
1. SKA1	G/L accounts (chart of accounts)
2. SKB1	SKB1 G/L accounts (company code)
3. SKA1T	G/L accounts (chart of accounts) translation in different languages
4. SKM1 / T	Sample G/L accounts
5. SKPF	Inventory Sampling
6. SKAS	Chart of accounts: keyword list

Customer / Creditor / Business Partner related

Table Name	Table Description
1. KNA1	Customer Master General Data at Country Level
2. KNAS	VAT Registration Numbers
3. KNB1	Customer Master Company Code Data
4. KNB5	Customer Master Dunning Data
5. KNB4	Customer Master Payment History
6. KNBK	Customer Master Bank Data
7. KNC1	Transaction Posting Figures
8. KNC3	Special GL Data

Vendor / Debtor /Business Partner related

Table Name	Table Description
1. LFA1	Vendor Master General Data at Country level
2. LFB1	Vendor master Company Code Data
3. LFB5	Vendor Dunning Data
4. LFAS	VAT Registration Number
5. LFBK	Vendor Bank Details
6. LFC1	Vendor Transaction Figures
7. LFC3	Vednor Special GL Transaction figure
8. LFM1	Record Purchasing Organisation
9. T078K	Vendor Master Data Transaction Screen Selections

SAP-FI: Accounting documents (postings)

Table Name	Table Description
BKPF	Accounting Document Header
BSEG	Accounting Documents Line Items
BSID	Customer Open Items
BSIK	Vendors Open Items
BSAD	Customer Cleared Items
BSAK	Vendor Cleared Items
BSIS	GL Open Items
BSAS	GL Cleared Items
BSIP	Vendor Validation of Double Document
BSET	Tax Data Document Line
BSEC	One Time Account Line Items
VBKPF	Parked Document Header Data

House Banks related tables in SAP

Table Name	Table Description
T012	House Bank Details
T012T	House Bank Account ID Description
T012K	House Bank Account Details
BNKA	Bank Master Details
TIBAN	Bank Account IBAN Details

Payment (= pmnt) Methods related Tables

Table Name	Table Description
T042	Parameters of Payment Transaction. FBZP -> All company code details
T042B	FBZP -> Paying Company code Details table
T042E	FBZP -> Payment Method in Company Code details
T042Z	FBZP -> Payment Method in Country
T042W	FBZP -> Payment Method in Country -> Permitted Currency
T042A	FBZP -> Bank Determination -> Ranking Order of House bank
T042D	FBZP -> Bank Determination -> Available Amount
T042I	FBZP -> Bank Determination -> Bank Account Determination
T042V	FBZP -> Bank Determination -> Value Date for Automatic Program
T042S	FBZP -> bank Determination -> Expenses/Charges for Automatic Payment Transactions
T042F	Payment Method Supplement ID and Text
T042H	Payment Method Supplement Language Description
T008	Payment Block Details Table
T042N	Bank Transaction Codes
T042K	Accounts for Bank Charges
T042J	Bank charges determination
T042G	Groups of Company Code

Tolerance Groups (TG) related Table

Table Name	Table Description
T043G	Tolerance group for Customer and Vendor Accounts
T043GT	Tolerance Group for Customer and Vendor Accounts Language-specific description
T043S	Tolerance for Groups of GL Accounts
T043ST	Tolerance for Groups of GL Accounts Description in different Language
T043T	FI Tolerance Group per Company code
T043	Assign User to Tolerance Group
T043I	Tolerance Group for Person Processing Inventory Difference
T043K	Control of Payment Notices to Customer / Vendor
T043U	Paying Company Code – Payment method combination Negative grace period

Interests in SAP FICO processes

Table Name	Table Description
T056	Interest Settlement: Name, Type and Description
T056G	Interest Calculation Rules
T056R	Reference Interest Rate Description
T056S	Interest scale interest terms (acct bal.int.calc.)
T056Z	Currency wise Interest Rate

Tables related to Taxes

Table Names	Table Description
T007A	Tax Codes or Tax Keys for all Tax Procedures
T007S	Tax Code/Key Description
T059A	Country wise Tax Recepient for Vendor
T059B	Description for Withholding tax Class for Vendors
T059C	Types of Recipient: Vendors per Withholding Tax Type
T059D	Types of Recipient: Vendors per Withholding Tax Type
T059E	Country-wise Income Types
T059G	Description of Country-wise Income Types
T007B	Tax processing in Accounting.
T059F	Formulas for Calculating Withholding Tax
T059P	Country-wise Withholding tax types
T059Z	Country-wise Withholding tax code (enhanced functions)

Currency related Tables in SAP

Table Name	Table Description
TCURC	Currency codes (Report RFTBFF00)
TCURT	Currency Code name
TCURR	Transacrtion Code OB08, Exchange Rates
TCURX	Decimal Places in Currencies
TCURF	Exchange rate type Conversion Factors
TCURV	Exchange rate types for currency translation

SAP Tables – Without Category

Table Name	Table Description
CDHDR	Change document header
CDPOS	Change document items
JCDS	Change Documents for System
JEST	Change Documents for User Status
JSTO	Status object information
ARCH_OBJ	Objects for archiving and reorganization
SNAP	Snapshot for Runtime Errors (Dumps)
TBTCO	Job status overview
TBTCP	Batch Input step overview
DDSHPVAL5	Personal Help Values

Variants (Reports & Jobs)

Table Name	Table Description
VARID	Variant for Reports
VARIT	Description of Variant for Reports
TVARV	Variables in selection criteria
VARIS	Assignment of variant to selection screen

Transport Requests tables

Table Name	Table Description
E070	Header of Requests
E71K	Header of Tasks (View: E070V)
E070C	Source / Target Client of Requests / Tasks
TLOCK	Change and Transport System: Lock Table

SAP-CO: Controlling / Cost center

Table Name	Table Description
CSKA	Cost elements (chart of accounts)
CSKB	Cost elements (controlling area)
CSKU	Cost element texts
CSLA	Activity master
CSLAT	Activity type texts
CSKS	Cost center: Master
CSKT	Cost Center Texts
CSSK	Cost center: Cost element
CSSL	Cost center: Activity
COSP	CO Object: Cost Totals for External Postings
COEP	CO Object: Line Items (by Period)
COBK	CO Object: Document header
COST	CO Object: Price Totals
TKA01	Controlling areas
TKA02	Controlling areas assignment
KEKO	Product Costing – Header Data
KEPH	Cost Components for Cost of Goods Mfd
KALO	Costing Run: Costing Objects (KVMK)
KANZ	Sales order items – costing objects
CEPC-T	Profit Center Master Data Table
CKPH-T	Master Record: Cost Object ID Number

Orders (Cost Accounting) tables

Table Name	Table Description
AUFK	Order master data
AFKO	Order header data PP orders
AFPO	Order item

Number ranges Table

Table Name	Table Description
NRIV	Number range intervals
TNRO	Number range objects

Text / Print / Spool / SAP Documentation

Table Name	Table Description
STXFADM	Smart Forms: Administration
STXB	Texts in non-SAP script forma
STXH	SAP script text file header
STXL	SAP script text file lines
TSP01	Spool Requests
TSP02	Print Requests
TST01	TemSe – header and data (= Temp. Sequential)
TST03	TemSe – header and data (= Temp. Sequential)
TTXOB	Valid text objects
TTXOT	Valid text objects, see TTXID for text IDs
DOKIL	Index for Documentation Table DOKH
DOKHL	Documentation: Headers
DOKTL	Documentation – text lines

ABAP & SAP Data Dictionary Tables

Table Name	Table Description
TFDIR,TFTIT	Function Module (se37) / FM short text
TRDIR	Programs / Sources (REPOSRC / D010SINF)
D010TAB	Where Used: Report – Tables
T100	Messages
TSTC and TSTCT	Transaction Codes (= TC)
TSTCP	Parameter for transactions
PATH	Physical paths / file names

Automatic Payment Run F110 Tables

Table Name	Table Description
REGUH	Transaction Code F110 table: Settlement data from payment program
REGUP	Transaction Code F110 table: Processed items from payment program
REGUA	Transaction Code F110 table: Change of payment proposals: user and time
REGUHM	Payment Data for Cross-Payment Run Payment Medium
REGUPW	W/tax information per w/tax type/FI line item in pmnt run
REGUS	Transaction Code F110 table: Accounts blocked by payment proposal
REGUS_SEPA	SEPA Mandate Lock: Applications To Be Retrieved
REGUT	Transaction Code F110 table: TemSe – Administration Data
REGUTA	Paying Company Codes for DME Files

SAP Dunning Run F150 SAP Tables

Table Name	Table Description
MHNK	Transaction code F150 table: Dunning data (account entries)
MHND	Transaction code F150 table: Dunning data
KNB5	Customer master (dunning data)