SAP Financials Tables
Are you looking for the right table related to SAP Financials Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Financials (FIN) module.
Top 10 tables in Financials
| Table | Description |
|---|---|
| FINBTATYPE0C | Business Transaction Categories |
| FINGLTRATYPE0C | Transaction Types of General Ledger |
| FINCLOSESTEP0T | Closing Phases |
| FINPVALADJKEY0T | Aging Group |
| FINPRCTABDERIV | Assignment Table for Table Type of Prices |
| FINDUEAGINGGRP0T | Aging Group |
| FINGLACCTGRP0T | Texts of Account Groups |
| FINDUEAGINGGRP0C | Aging Group |
| FINXCONDTYPE0T | Local Texts for FIN_CONDTYPE (Not Used in Live System) |
| FINFUNCAREA0T | Texts of Functional Areas |
List of tables in Financials
| Table | Description |
|---|---|
| FINBTATYPE0C | Business Transaction Categories |
| FINGLTRATYPE0C | Transaction Types of General Ledger |
| FINCLOSESTEP0T | Closing Phases |
| FINPVALADJKEY0T | Aging Group |
| FINPRCTABDERIV | Assignment Table for Table Type of Prices |
| FINDUEAGINGGRP0T | Aging Group |
| FINGLACCTGRP0T | Texts of Account Groups |
| FINDUEAGINGGRP0C | Aging Group |
| FINXCONDTYPE0T | Local Texts for FIN_CONDTYPE (Not Used in Live System) |
| FINFUNCAREA0T | Texts of Functional Areas |
| FINCOMPELDUE0T | Composition Element AP/AR |
| FINXPARTYID0T | Local Texts for FIN_CASHLOC (Not Used in Live System) |
| FINPRCVARIANT0T | Price Variants |
| FINX_FINFO_0C | Overview of Semantic Model: Field List |
| FINCOMPELCASH0T | Composition Element Cash |
| FINDUETYPE0C | Type of receivable/payable |
| FINXPARTYID0C | Local Values for FIN_PARTYID (Not Used in Live System) |
| FINDUETYPE0T | Type of receivable/payable |
| FINJOURNAL0T | Texts for Journals |
| ACCSYSTEM03 | Derivations for Accounting System |
| FINSTLRULER0C | Definition Settlement Rule Receiver |
| FINORDITMTYPE0C | Order Item Category |
| FINVALFUNC0C | Master Data for Strategy Functions |
| FINXCOSTCTR0C | Local Values for FIN_COSTCTR (Not Used in Live System) |
| FINXLOCATION0C | Local Values for FIN_LOCATION (Not Used in Live System) |
| FINCHOFACCT0C | Charts of Accounts |
| FINPRICELABEL01 | Price Type Controls |
| FINORDPUR0C | Data Storage for Purchase Order Information - Header |
| FINXBATCH0C | Local Values for FIN_BATCH (Not Used in Live System) |
| FINDOCTYPE0T | Texts of Document Types |
| FINVALLEVEL0T | Texts for Valuation Levels |
| FIN_BBE_AMAP | Field Mapping for BusEnt: Attributes on Value Container |
| FINBSNDID0C | Identification for Sender System and Object Type |
| FINBTATYPE0T | Business Transaction Categories |
| FINXCASHLOC0T | Local Texts for FIN_CASHLOC (Not Used in Live System) |
| FINXPROFITCTR0C | Local Values for FIN_PROFITCTR (Not Used in Live System) |
| FINVALMETHOD0T | Texts for Valuation Functions for Strategy Formulas |
| FINXPRODUCT0C | Local Values for FIN_PRODUCT (Not Used in Live System) |
| FINSTLRULES0C | Definition Settlement Rule Sender |
| FINGLACCTMAP0C | Assignment of G/L Accounts: Operational for Local or Group |
| FINORDTYPE0C | Order Category |
| FINGLTRATYPE0T | Texts for Transaction Types of General Ledger |
| FINPOSTYPE0T | Texts of Item Categories |
| FINNRSOBJ0C | Table for Number Range Objects |
| FINPRICELABEL0C | Master Data for Price Types |
| FINVALLEVEL0C | Valuation Levels |
| FINORDTYPE0T | Texts for Order Categories |
| FINGLACCT0T | Texts for G/L Account |
| ACCSYSTEM02 | Number Range Object for Accounting System and Company |
| FINXLREPUNIT0C | Local Values for FIN_PROFITCTR (Not Used in Live System) |
| FINSTLAPP0T | Applications for Settlement (Text Table) |
| FINCURRTYPE0T | Text for Currency Type |
| FINPVALADJKEY0C | Valuation Adjustment Key |
| FINGLACCTGRP0C | Account Group |
| FINJOURNAL0C | Journals |
| FINXPROFITCTR0T | Local Texts for FIN_PROFITCTR (Not Used in Live System) |
| FINPRCVARIANT0C | Price Variants |
| FINXCONDTYPE0C | Local Values for FIN_CONDTYPE (Not Used in Live System) |
| FINCLOSESTEP0C | Closing Phases |
| FINPAYTYPE0C | Payment type |
| FINPAYTYPE0T | Payment type |
| FINVALSTRATDERIV | Derivation Table: Valuation Strategy for Business Transactio |
| FINVALSTRAT0C | Master Data for Valuation Strategy |
| FINSTLRULER0T | Definition Settlement Rule Receiver (Text Table) |
| FINVALSTRAT0T | Texts for Valuation Strategies |
| FINPRICELABEL0T | Text Table for Price Types |
| ACCSYSTEM0C | Accounting Systems |
| FINGLACCTCOMP0C | G/L Account on Accounting System/Company Level |
| FINCURRTYPE0C | Currency Type |
| FIN_BBE_FMAP | Field Mapping for BusEnt: BE on Metadata Carrier |
| FINCOMPELCASH0C | Composition Element Cash |
| FINORDITMTYPE0T | Texts of Order Item Categories |
| FINCOMPELDUE0C | Composition Element AP/AR |
| FINCOMPEL0T | Composition Element |
| FINXCOMPANY0C | Local Values for FIN_COMPANY (Not Used in Live System) |
| FINDUEDATE | Data Storage for Invoice Information for Due Dates |
| FINXCASHLOC0C | Local Values for FIN_CASHLOC (Not Used in Live System) |
| FINORDPUR01 | Data Storage for Purchase Order Information - Items |
| FINX_FINFO_01 | Overview of Semantic Model: Mapping to ERP Entities |
| FINFUNCAREA0C | Functional Area |
| FINXCOMPANY0T | Local Texts for FIN_COMPANY (Not Used in Live System) |
| ACCSYSTEM01 | Settings for Company on Accounting System |
| FINPOSTYPE0C | FS item categories |
| FINX_FINFO_02 | Overview of Semantic Model: Registration in ERP Environment |
| FINVALMETHOD0C | Valuation Functions for Strategy Formulas |
| FINORMNFRECID | Planned Receivers for Manufacturing Orders |
| FINSTLRULES0T | Definition Settlement Rule Sender (Text Table) |
| FINCOMPEL0C | Composition Element |
| FINGLACCT0C | G/L Account |
| FINVALFUNC0T | Texts for Strategy Functions |
| FINDOCTYPE0C | Document types |
| ACCSYSTEM0T | Texts of Accounting Systems |
| FINSTLAPP0C | Applications for Settlement |
| FINCHOFACCT0T | Texts of Document Types |
| FINXPRODUCT01 | Local Values for FIN_PRODUCT (Not Used in Live System) |
| FINORDUE0C | FIN Objects for Receivables/Payables |