The complete list of SAP Tables in Financial Accounting module. The most commonly used Tables are at the top of the list. Click on a sub-module to see the Tables specific to that module.

SAP Financial Accounting Tables by Sub-Module

FI General Tables

Go to top of the page
S.No Table Description Table Type
1 BSEG Accounting Document Segment Cluster Table
2 BKPF Accounting Document Header Transparent Table
3 LFA1 Vendor Master (General Section) Transparent Table
4 T001 Company Codes Transparent Table
5 BSID Accounting: Secondary Index for Customers Transparent Table
6 BSIS Accounting: Secondary Index for G/L Accounts Transparent Table
7 BSIK Accounting: Secondary Index for Vendors Transparent Table
8 LFB1 Vendor Master (Company Code) Transparent Table
9 BSAK Accounting: Secondary Index for Vendors (Cleared Items) Transparent Table
10 BSAD Accounting: Secondary Index for Customers (Cleared Items) Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI General Tables
Go to top

Localization Tables (FI-LOC)

Go to top of the page
S.No Table Description Table Type
1 J_1IEXCDTL Excise invoice line item details Transparent Table
2 J_1IEXCHDR Excise invoice header detail Transparent Table
3 DOCUMENTTYPE Document Type for China Structure
4 EVENTO AR WS: Structure used in AFIP response Structure
5 J_1IMOVEND Vendor Master Excise Additional Data Transparent Table
6 J_1IPART2 Excise Part II details Transparent Table
7 J_2IRG1BAL Opening/Closing balance table for RG1 Transparent Table
8 J_1IPART1 Excise part I detials Transparent Table
9 EXCHANGERATE Exchange Rate for China Structure
10 BASE64BINARY Proxy Structure (generated) Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Localization Tables (FI-LOC)
Go to top

Asset Accounting Tables (FI-AA)

Go to top of the page
S.No Table Description Table Type
1 ANLA Asset Master Record Segment Transparent Table
2 ANLC Asset Value Fields Transparent Table
3 ANLZ Time-Dependent Asset Allocations Transparent Table
4 ALSMEX_TABLINE Rows for Table with Excel Data Structure
5 ANLB Depreciation terms Transparent Table
6 ANEK Document Header Asset Posting Transparent Table
7 ANLU Asset Master Record: User Fields Transparent Table
8 ANEP Asset Line Items Transparent Table
9 TABA Depreciation posting documents Transparent Table
10 ANLAV Asset Reporting: ANLA Fields Plus Cost Center... Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Asset Accounting Tables (FI-AA)
Go to top

General Ledger Accounting Tables (FI-GL)

Go to top of the page
S.No Table Description Table Type
1 FAGLFLEXA General Ledger: Actual Line Items Transparent Table
2 FAGLFLEXT General Ledger: Totals Transparent Table
3 SKB1 G/L account master (company code) Transparent Table
4 GL_ACCOUNT Generated Table for View General View Structure
5 GLACCOUNT_SCREEN_COA G/L Account Master Record: Chart of Accounts (Screen Fields) Structure
6 GLACCOUNT_SCREEN_CCODE G/L Account Master Record: Company Code (Screen Fields) Structure
7 FC01 BDF Header Record for Reporting Structure
8 RFPOSXEXT ## AUTOMATICALLY GENERATED. DO NOT CHANGE OR RE-USE ! ## Structure
9 ACC_DOCUMENT Accounting document Structure
10 ACDOCA Universal Journal Entry Line Items Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI General Ledger Accounting Tables (FI-GL)
Go to top

Bank Accounting Tables (FI-BL)

Go to top of the page
S.No Table Description Table Type
1 PAYR Payment Medium File Transparent Table
2 T012K House Bank Accounts Transparent Table
3 T012 House Banks Transparent Table
4 FPAYP Payment medium: Data on paid items Structure
5 FPAYH Payment medium: Payment data Structure
6 ISCJ_E_POSTINGS Structure for Cash Journal expenses Structure
7 REGUT TemSe - Administration Data Transparent Table
8 T042E Company Code-Specific Specifications for Payment Methods Transparent Table
9 T042Z Payment Methods for Automatic Payment Transparent Table
10 FPAYHX Payment Medium: Prepared Data for Payment Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Bank Accounting Tables (FI-BL)
Go to top

Contract Accounts Receivable and Payable Tables (FI-CA)

Go to top of the page
S.No Table Description Table Type
1 E001 Company Code Currencies for Archiv.Classes ARCT001 Structure
2 DFKKOP Items in contract account document Transparent Table
3 FKKVKP Contract Account Partner-Specific Transparent Table
4 FKKOP Business Partner Items in Contract Account Document Structure
5 DFKKKO Header Data in Open Item Accounting Document Transparent Table
6 FKKVK Contract Account Header Transparent Table
7 DFKKTHI Transfer Records for Invoice Issue by Third Party Transparent Table
8 DFKKWLI Work Items Transparent Table
9 DFKKREPZM Recording Data for EC Sales List Transparent Table
10 DFKKPP Promises to Pay Header Table Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Contract Accounts Receivable and Payable Tables (FI-CA)
Go to top

Tables (FI-SL)

Go to top of the page
S.No Table Description Table Type
1 GLT0 G/L account master record transaction figures Transparent Table
2 SETHEADER Set Header and Directory Transparent Table
3 GB01 Classes for Boolean Formulas Transparent Table
4 VARD Report Writer: Variation Dimensions Structure
5 SETLEAF Values in Sets Transparent Table
6 SETDATA Sets - Contents (before Release 4.0) Transparent Table
7 GLU1 G/L user table 1 Structure
8 GLFUNCA Actual Line Items Table for Cost of Sales Accounting Transparent Table
9 T881 Ledger Master Transparent Table
10 SETNODE Lower-level sets in sets Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Tables (FI-SL)
Go to top

Funds Management Tables (FI-FM)

Go to top of the page
S.No Table Description Table Type
1 FMDERIVE FM Derivation Structure Structure
2 REDY Screen Fields for Funds Reservations Structure
3 BPJA Totals Record for Annual Total Controlling Obj. Transparent Table
4 FMIFIIT FI Line Item Table in Funds Management Transparent Table
5 BPGE Totals Record for Total Value Controlling obj. Transparent Table
6 FMIOI Commitment Documents Funds Management Transparent Table
7 FPOS Commitment items Structure
8 FVAR Commitment Items: Fiscal Years and Plan Variants Structure
9 BPIN Import Parameters for Accessing Functions in Budget/Planning Structure
10 FMIT Totals Table for Funds Management Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Funds Management Tables (FI-FM)
Go to top

Tables (FI-AR)

Go to top of the page
S.No Table Description Table Type
1 KNVP Customer Master Partner Functions Transparent Table
2 KNKK Customer master credit management: Control area data Transparent Table
3 INT_TAB Delivery Table for Interest Rates Structure
4 T179T Materials: Product hierarchies: Texts Transparent Table
5 KNKA Customer master credit management: Central data Transparent Table
6 MAHNS Accounts blocked by dunning selection Transparent Table
7 T001CM Permitted Credit Control Areas per Company Code Transparent Table
8 MHNK Dunning data (account entries) Transparent Table
9 KNVD Customer master record sales request form Transparent Table
10 V_T001B Generierte Tabelle zu einem View General View Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Tables (FI-AR)
Go to top

Travel Management Tables (FI-TV)

Go to top of the page
S.No Table Description Table Type
1 PTRV_HEAD General Trip Data Transparent Table
2 PTRV_PERIO Period Data of a Trip Transparent Table
3 PTK99 Field string/Table for USER Screen Structure
4 PTRV_KMSUM Table for Use of Miles/Kms Accumulation Transparent Table
5 PRICE_TYPE \r\n \t\tPrice definition\r\n \t Structure
6 V_T706B1 Generated Table for View V_T706B1 General View Structure
7 PTRV_SREC Trip Statistics - Receipts Transparent Table
8 P0017 HR master record: Infotype 0017 (Travel Privileges) Structure
9 T706F Trip Provision: Flat Rates for Travel Costs Transparent Table
10 V_T702N_A Generated Table for View V_T702N_A General View Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Travel Management Tables (FI-TV)
Go to top

Tables (FI-AP)

Go to top of the page
S.No Table Description Table Type
1 REGUH Settlement data from payment program Transparent Table
2 REGUP Processed items from payment program Cluster Table
3 WITH_ITEM Witholding tax info per W/tax type and FI line item Transparent Table
4 REGUD Form print transfer data Structure
5 LFBW Vendor master record (withholding tax types) X Transparent Table
6 FDTA Help fields structure for 'DME Administration' transaction Structure
7 T004F Field status definition groups Pooled Table
8 BWITH Document-withholding tax information (batch input structure) Structure
9 TBSL Posting Key Pooled Table
10 V_T001 Generierte Tabelle zu einem View General View Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Tables (FI-AP)
Go to top

Generic Contract Accounts Receivable and Payable Tables (FI-CAX)

Go to top of the page
S.No Table Description Table Type
1 DFSCICLARIOB Bal. Int. Calculation at Contract Acct Level: Clarif. Cases Transparent Table
2 DFSCIREV Bal. Int. Calculation at Contract Acct Level: Inverse Pstgs Transparent Table
3 BCA_STR_DIM_CLR_EXTENSIONIN Customer Enhancements for each Clearing Account Structure
4 DFSCIHISTIOB Balance Int. Calculation at Contract Account Level: History Transparent Table
5 BCA_STR_DIM_REF_REVERSAL_KEYS Reversal references with keys Structure
6 TFSCHVTV Transactions for Company Code and Division Transparent Table
7 BCA_STR_DIM_OI_KEYS Open Item Key Columns Structure
8 FICAX_INTEREST_STR_INTER_DOC Interest Document (Header) Structure
9 FSC_STR_INSTP_INST_ITEM Individual Installment Due Date Structure
10 FSC_STR_INSTP_INST_DOC Installment Plan Document (Header) Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Generic Contract Accounts Receivable and Payable Tables (FI-CAX)
Go to top

Tables (FI-LC)

Go to top of the page
S.No Table Description Table Type
1 V_INDX Generated Table for View V_INDX General View Structure
2 GLT3 Summary Data Preparations for Consolidation Transparent Table
3 GLT2 Consolidation totals table Transparent Table
4 T856 Transaction Types Transparent Table
5 FILC FI-LC: Database Structure for Reporting Structure
6 V_T880 Generated Table for View V_T880 General View Structure
7 FILCT FI-LC: Global totals table with 2 object tables Transparent Table
8 RF10B Help fields for screens SAPMF10B Structure
9 MCDX Compressed Consolidation transaction data Transparent Table
10 V_T856 Generated Table for View V_T856 General View Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Tables (FI-LC)
Go to top

Lease Accounting Tables (FI-LA)

Go to top of the page
S.No Table Description Table Type
1 V_OBJECTID Generated Table for View V_OBJECTID General View Structure
2 LAE_CRM_ITEMS LAE: Contract Items Transparent Table
3 LAE_CRM_BILLPLAN Payment Schedule Transparent Table
4 LAE_CRM_HEADER LAE: CRM Contract Header Transparent Table
5 FILA_POINF Help Structure: Posting Info for FI-AA Structure
6 LAE_BILLING_DATA Payment Schedule Transparent Table
7 LAE_CRM_CONDS Lease-Accounting-Relevant Conditions Transparent Table
8 FIOTPOI One-Time Postings: Items Transparent Table
9 FILA_GF_ITEMDATA Process Data Transparent Table
10 FILA_RE_LNK Link Between Leasing <-> Refinancing Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Lease Accounting Tables (FI-LA)
Go to top

Retail Ledger Tables (FI-RL)

Go to top of the page
S.No Table Description Table Type
1 PCRRETAILA Actual line item table Transparent Table
2 PCRRETAILP Plan line items table Transparent Table
3 PCRRETAILT Totals Table Transparent Table
View the full list of SAP FI Retail Ledger Tables (FI-RL)
Go to top

Tables (FI-FIO)

Go to top of the page
S.No Table Description Table Type
1 CARCUSTOMER Generated Table for View General View Structure
2 FAC_S_IFIGL_COMPACTJOURNAL Structure of Compact Journal Structure
3 FAC_S_IFIGL_COMPACTJOURNAL_INC Structure of Compact Journal Extension Include Structure
4 FAC_S_TERMINATED_DOC Structure of Terminated Documents Structure
5 FAC_S_IFIGL_MULTIPLEREFDOC Structure of Multiple Reference Documents Structure
6 FAC_S_JRNLENTRYHISTORY Structure of Journal Entry History Structure
7 FAC_S_DOCUMENT_GAP_INCL Structure of Document Gap Extensions Include Structure
8 FAC_S_JRNLENTRYHISTORY_INCL Structure of Journal Entry History Extension Include Structure
9 FAC_S_TERMINATED_DOC_INCL Structure of Termination Document Extension Include Structure
10 FAC_S_DOCUMENT_GAP Structure of Document Gap Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Tables (FI-FIO)
Go to top

Revenue Accounting Tables (FI-RA)

Go to top of the page
S.No Table Description Table Type
1 INCL_EEW_FARR_REP Enhancement Include Postings Structure
2 FARR_D_POB Performance Obligations Transparent Table
3 FARR_D_COMP_TRAN Result table of comparative report Transparent Table
4 FARR_D_POSTING Postings Transparent Table
5 FARR_D_DEFITEM Deferral Items Transparent Table
6 FARR_S_RAI_MSG FARR_RAI: Messages Structure
7 INCL_EEW_FARR_POB Enhancement Include Performance Obligations Structure
8 FARR_D_DELDEFITM Deletion update for Deferral Item(memorized for BI) Transparent Table
9 INCL_EEW_FARR_TRANSITION Enhancement Include Comparative report for transition Structure
10 FARR_S_RAI0_CO_ALL Work Structure - Raw Data Conditions Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Revenue Accounting Tables (FI-RA)
Go to top

Central Finance Tables (FI-CF)

Go to top of the page
S.No Table Description Table Type
1 CFIN_ACCHD ACCHD Transfer table. Transparent Table
2 VCFIN_SOURCE_SET Generated Table for View General View Structure
3 FINS_CFIN_T001 Central Finance: Company Code Configuration Transparent Table
4 CFIN_CMT_H Transfer Table for Commitment Header Transparent Table
5 CFIN_CO_ADD Transfer Table for CO Additional Data in Central Finance Transparent Table
6 CFIN_CPCTL Central Payment Customizing Table Transparent Table
7 V_CFIN_AIF_RT_CF Generated Table for View General View Structure
8 CFIN_ACCIT Transfer Table for ACCIT Transparent Table
9 CFIN_COPA Transfer Table for CO-PA Extraction in CO Transparent Table
10 V_FINS_CFIN_MAPS Generated Table for View General View Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP FI Central Finance Tables (FI-CF)
Go to top

Tables (FI-PRA)

Go to top of the page
S.No Table Description Table Type
1 FINSV_PRED_FKART Generated Table for View General View Structure
2 FINSV_PRED_FKREL Generated Table for View General View Structure
3 FINSV_PRED_RLDNR Generated Table for View General View Structure
View the full list of SAP FI Tables (FI-PRA)
Go to top

Most viewed SAP Financial Accounting Tables