SAP Fund Accounting Tables
Are you looking for the right table related to SAP Fund Accounting 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 Fund Accounting (PSM-FA) module.
Top 10 tables in Fund Accounting
| Table | Description |
|---|---|
| FMCCAVCRESERVE | CCAVC aux table for reserved items |
| PSGLFLEX01 | General ledger: Technical fields |
| FMCCAVCLDGRGAT | Year-Independent Attributes of Control Ledger (FMCC) |
| FMADB_TC_WEIGHTS | FMADB: Trace - Saved Weights (Last Run) |
| FMCCAVCFILTH | Cash Control filter settings: header entries |
| FMADB_HEADER | Header Information for ADBs |
| FMADB_INT_DOC | ADB: Documents to Be Imported |
| FMADB_DEFAULT_AA | FMADB: Default Account Assignment for Petty Amounts |
| FMCCAVCLDGRACT | Activation of control ledger for Cash Control |
| FMADB_ENTITY | ADB: Entities Involved in Procedure |
List of tables in Fund Accounting
| Table | Description |
|---|---|
| FMCCAVCRESERVE | CCAVC aux table for reserved items |
| PSGLFLEX01 | General ledger: Technical fields |
| FMCCAVCLDGRGAT | Year-Independent Attributes of Control Ledger (FMCC) |
| FMADB_TC_WEIGHTS | FMADB: Trace - Saved Weights (Last Run) |
| FMCCAVCFILTH | Cash Control filter settings: header entries |
| FMADB_HEADER | Header Information for ADBs |
| FMADB_INT_DOC | ADB: Documents to Be Imported |
| FMADB_DEFAULT_AA | FMADB: Default Account Assignment for Petty Amounts |
| FMCCAVCLDGRACT | Activation of control ledger for Cash Control |
| FMADB_ENTITY | ADB: Entities Involved in Procedure |
| FMCCAVCFILTACC | Cash Control filter settings: detail entries |
| FMCCBASIDX | Index table for structures |
| FMADB_ACT_ENTITY | FMADB: Active Entities |
| FAGL_CLHCM_ASGMT | Cash-Basis Accounting - HCM Integration: Default RE_ACCOUNT |
| FAGL_CFR_ASGMT | Cash Flow Reporting: Assignment to E/R Account |
| FMCCAVCO | Object table 1 |
| FMADB_INTERVALLS | Processed ADB Periods |
| FMCCAVCKEDRENVT | Text for Strategy Environment |
| FAGL_CASH_ACCNT | Cash Ledger: Cash-Relevant Accounts |
| FMADB_DOC | ADB: Document Generation |
| FMCCAVCLDGRATT | Attributes of Cash Control Ledger (CC) |
| FMCCAVCP | Plan line items table |
| FAGL_CFR_CONTROL | Cash Flow Reporting: Control Table |
| FMADB_TC_INT_DOC | ADB: Interest Documents |
| FMADB_POOL | ADB: Pool Account Assignments |
| FMCCAVCT | Totals Table |
| FMADB_GLACCOUNT | ADB: G/L Accounts that Take Part in Weighting Determination |
| FAGL_CL_CONST | Cash Ledger: Constants for Unassigned Processes |
| FMGLFLEX08 | General Ledger: Reserve Table 2 |
| FAGL_CLMIG_STATE | Cash Ledger: Migration Status |
| FMCCAVCC | Object table 2 |
| FMCCAVCA | Actual line item table |
| FAGL_CLMIG_ASGMT | Cash Ledger Migration: Profit and Loss Acct for Opening Bal. |
| FMCCSRCIDX | Index table for sources |
| PSGLFLEX06 | General ledger: Sender SAP additional account assignment |
| FAGL_CL_ASGMT | Cash Ledger: Assignment of Income Statemt Accts to B/S Accts |
| FMCCAVC_PRL | Cluster table for different purposes |
| PSGLFLEX02 | General ledger: Main account assignment |
| FMGLFLEXT | General Ledger Public Sector: Total |
| PSGLFLEX04 | General ledger: Customer additional account assignment |
| PSGLFLEX00 | General ledger: Transaction attributes |
| PSGLFLEXA | General Ledger: Actual Line Items |
| FMCC_CASH_ACCNT | Cash Control: Def. of accounts relevant for Cash Control |
| T001B_PS | Account Assignment Objects in General Ledger |
| FMGLFLEX05 | General Ledger: Additional Acct Assignment: Customer 2 |
| PSGLFLEX03 | General ledger: SAP additional account assignment |
| FMPPFUND | Items for Partial Payment by Fund Process |
| FMGLFLEX02 | General ledger: Main account assignment |
| FMGLFLEXA | General Ledger: Actual Line Items |
| FMGLFLEX04 | General ledger: Customer additional account assignment |
| FMGLFLEX07 | General Ledger: Reserve Table 1 |
| FMGLFLEXP | General Ledger: Plan Line Items |
| PSGLFLEX08 | General Ledger: Reserve Table 2 |
| T001B_PS_PER | Permitted Posting Periods for Account Assignment Objects |
| PSGLFLEXP | General Ledger: Plan Line Items |
| FMGLFLEX00 | General ledger: Transaction attributes |
| PSGLFLEX05 | General Ledger: Additional Acct Assignment: Customer 2 |
| FMPP_CONTROL | Partial Payment per G/L Account Assignments: Control Table |
| PSGLFLEXT | General Ledger Public Sector: Total |
| PSGLFLEX07 | General Ledger: Reserve Table 1 |
| PSGLMIG_PROTOCOL | rotocol for the Migration to the new Public Sector Template |
| FMGLFLEX01 | General ledger: Technical fields |
| FMGLFLEX06 | General ledger: Sender SAP additional account assignment |
| FMGLFLEX03 | General ledger: SAP additional account assignment |
| FMCCBASOBJNR | Object numbers for CC addresses |