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.
Tables | Description | Functional Area |
BKPF | Accounting Document Header for accounting documents and information | General Ledger |
BSEG | Accounting Document Segment including details like account number, amount, currency,etc | General Ledger |
T001 | Company Codes including name, currency, language, etc. | General Ledger |
T012 | House Banks such as bank key, bank name, account number, etc | Bank Accounting |
KNA1 | Customer Master Data for customers including address, contact details, payment terms, etc | Accounts Receivable |
KNB1 | Customer Company Codes Data for customers like credit limits, payment history, etc | Accounts Receivable |
LFA1 | Vendor Master Data including address, contact details, payment terms, etc. | Accounts Payable |
LFB1 | Vendor Company Codes Data such as payment terms, tax information, etc. | Accounts Payable |
BSIK | Open Items for G/L Accounts such as document number, posting key, amount, etc. | General Ledger |
BSAK | Open Items for Customer including document number, posting key, amount, etc. | Accounts Receivable |
BSIK | Open Items for Vendor such as document number, posting key, amount, etc. | Accounts Payable |
T030 | Accounts for Exchange Rate Differences used in currency valuation | General Ledger |
T076B | Currency Exchange Rates between different currencies | General Ledger |
T003 | Currency Codes along with their descriptions | General Ledger |
SKA1 | G/L Account Master Data including account number, description, account type, etc | General Ledger |
T052 | Posting Periods variants used for defining posting periods in FI | General Ledger |
T001W | Plant Data for Material including plant code, name, address, etc | Logistics |
T052U | Special Periods information used for financial closing in FI | General Ledger |
T042 | Accounts for Payroll | Payroll Accounting |
SKB1 | G/L Account Company Codes Data such as account currency, tax information, etc. | General Ledger |
BSET | Tax Data Document Segment for accounting documents | General Ledger |
T076C | Exchange Rate Types used in currency translation | General Ledger |
T030R | Transaction figures for Foreign Trade activities | General Ledger |
T003T | Currency Names with descriptions of currency codes | General Ledger |
T001L | Storage Locations including location code, description, address, etc | Logistics |
T001B | Permitted Posting Periods for different company codes | General Ledger |
T030H | Allowed G/L Accounts per Currency | General Ledge |
T059Q | Automatically Created Payment Program | Payment Processing |
T030K | Foreign Exchange Risk Management | General Ledger |
T030R | Transaction Figures for Foreign Trade activities | General Ledger |
T007A | Holds tax keys along with their descriptions | Taxation |
T001I | Company Codes for Investment Management purposes | Investment Management |
T030V | Contains data related to sales and purchasing activities | Sales and Distribution |
T030Z | Partner Roles used in various business transactions | General Ledger |
T001F | Additional Financial Accounting Areas | General Ledger |
T007B | Contains tax codes along with their descriptions | Taxation |
T030B | Financial Accounting Data for Foreign Currency Valuation | General Ledger |
T030P | Contains additional reporting data | General Ledger |
T031 | Stores allowed G/L accounts for specific transactions | General Ledger |
T030F | Product and Location Data for Material Valuation | Material Management |
T033 | Holds document types along with their descriptions | General Ledger |
T030G | Financial Accounting Data for Material Valuation | Material Management |
T014 | Holds company codes along with their descriptions | General Ledger |
T030Q | Contains data related to manual accounting entries | General Ledger |
T012K | Stores plant data for materials | Material Management |
T030J | Materials Management Accounting | Material Management |
T030X | Stores data related to material valuation | Material Management |
T030D | Contains valuation areas used in material valuation | Material Management |
T030M | Stores data related to management accounting | Management Accounting |
T030E | Contains data related to the material ledger | Material Management |