SAP FI Tables spans over the diverse area of accounting within the SAP ERP System. These tables are the basic need of SAP consultants and users. They use the tables to resolve the various issues.

TablesDescriptionFunctional Area
BKPFAccounting Document Header for accounting documents and informationGeneral Ledger
BSEGAccounting Document Segment including details like account number, amount, currency,etcGeneral Ledger
T001Company Codes including name, currency, language, etc.General Ledger
T012House Banks  such as bank key, bank name, account number, etcBank Accounting
KNA1Customer Master Data for customers including address, contact details, payment terms, etcAccounts Receivable
KNB1Customer Company Codes Data for customers like credit limits, payment history, etcAccounts Receivable
LFA1Vendor Master Data including address, contact details, payment terms, etc.Accounts Payable
LFB1Vendor Company Codes Data such as payment terms, tax information, etc.Accounts Payable
BSIKOpen Items for G/L Accounts such as document number, posting key, amount, etc.General Ledger
BSAKOpen Items for Customer including document number, posting key, amount, etc.Accounts Receivable
BSIKOpen Items for Vendor such as document number, posting key, amount, etc.Accounts Payable
T030Accounts for Exchange Rate Differences used in currency valuationGeneral Ledger
T076BCurrency Exchange Rates between different currenciesGeneral Ledger
T003Currency Codes along with their descriptionsGeneral Ledger
SKA1G/L Account Master Data including account number, description, account type, etcGeneral Ledger
T052Posting Periods variants used for defining posting periods in FIGeneral Ledger
T001WPlant Data for Material including plant code, name, address, etcLogistics
T052USpecial Periods information used for financial closing in FIGeneral Ledger
T042Accounts for PayrollPayroll Accounting
SKB1G/L Account Company Codes Data such as account currency, tax information, etc.General Ledger
BSETTax Data Document Segment for accounting documentsGeneral Ledger
T076CExchange Rate Types used in currency translationGeneral Ledger
T030RTransaction figures for Foreign Trade activitiesGeneral Ledger
T003TCurrency Names with descriptions of currency codesGeneral Ledger
T001LStorage Locations including location code, description, address, etcLogistics
T001BPermitted Posting Periods for different company codesGeneral Ledger
T030HAllowed G/L Accounts per CurrencyGeneral Ledge
T059QAutomatically Created Payment ProgramPayment Processing
T030KForeign Exchange Risk ManagementGeneral Ledger
T030RTransaction Figures for Foreign Trade activitiesGeneral Ledger
T007AHolds tax keys along with their descriptionsTaxation
T001ICompany Codes for Investment Management purposesInvestment Management
T030VContains data related to sales and purchasing activitiesSales and Distribution
T030ZPartner Roles used in various business transactionsGeneral Ledger
T001FAdditional Financial Accounting AreasGeneral Ledger
T007BContains tax codes along with their descriptionsTaxation
T030BFinancial Accounting Data for Foreign Currency ValuationGeneral Ledger
T030PContains additional reporting dataGeneral Ledger
T031Stores allowed G/L accounts for specific transactionsGeneral Ledger
T030FProduct and Location Data for Material ValuationMaterial Management
T033Holds document types along with their descriptionsGeneral Ledger
T030GFinancial Accounting Data for Material ValuationMaterial Management
T014Holds company codes along with their descriptionsGeneral Ledger
T030QContains data related to manual accounting entriesGeneral Ledger
T012KStores plant data for materialsMaterial Management
T030JMaterials Management AccountingMaterial Management
T030XStores data related to material valuationMaterial Management
T030DContains valuation areas used in material valuationMaterial Management
T030MStores data related to management accountingManagement Accounting
T030EContains data related to the material ledgerMaterial Management
SAP FI Tables