SAP Funds Management Tables

Are you looking for the right table related to SAP Funds Management 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 Funds Management (FI-FM) module.

Top 10 tables in Funds Management

TableDescription
POSFREIIs No Longer Used: Free List of Internal Item Numbers
FMFRGDefine Release Groups
FM01UDSettings for revenues increasing the budget
BPGETotals Record for Total Value Controlling obj.
FGWF_MDRLKMain Rules for General Role Definition Header Entries
FMCFC2FYC Budget Control
FM01IAssignment Commitment Type/Cover Eligibility Profile FM Area
FMFRGTDefine Release Groups
FMHVMTXTBudget Memo
FMISPSUSERSpecial Control Table for FMISPS per User(only SAP internal)

List of tables in Funds Management

TableDescription
POSFREIIs No Longer Used: Free List of Internal Item Numbers
FMFRGDefine Release Groups
FM01UDSettings for revenues increasing the budget
BPGETotals Record for Total Value Controlling obj.
FGWF_MDRLKMain Rules for General Role Definition Header Entries
FMCFC2FYC Budget Control
FM01IAssignment Commitment Type/Cover Eligibility Profile FM Area
FMFRGTDefine Release Groups
FMHVMTXTBudget Memo
FMISPSUSERSpecial Control Table for FMISPS per User(only SAP internal)
FMFCTRBPBudget Object Group Definitions
FMCOVRCO Posting Integration: Transaction
FMEPFI-FM Line Items
FMGEBERFIFM: Financing Code for Sponsor
FMCFABSTR-FM: Transferred Commitment/Budget (Senders+Receivers)
BPTXBudgeting Text
BPBKDoc.Header Controlling Obj.
FM01Financial Management Areas
FMAVCis being deleted
FM01FRGMaintain Release Groups
BPPETotals Record for Period Values Controlling Obj.
FM01GFM Areas: Availability Control Settings
FMCDRBBSFM Rev. Incr. Budget History - Government Canada
FAGL_DOCTYPE_OIMDocument type for the Clearing Lines for OIM
BPIGBudget Object Index (Overall Budget)
FIWF_MDRLKMain Rules for FI Role Definition - Header Entries
FMBUDVERSActivate Budget Versions
FMACTDETLTTexts for Commitment/Actual Detailing
FIWF_ACGRPAccount Assignment Groups for Role Definition
EUUDCHAPPermitted Expenditure Chapter for Revenue Budget Line
FMCFAA_TRTR-FM: Commitments/Budget Carried Forward
FAGL_LEDGER_OIMLedgers for zero-balance follow-on documents
FMCFAAS_TRTR-FM: Commitments/Budget Carried Forward (Interim Storage)
BPIJBudget Object Index (Annual Budget)
FM01FRGTMaintain Release Approval Groups (Texts)
FMCFAASTR-FM: Commitments/Budget Carried Forward (Interim Storage)
FM01AFM area control records
BPCKControlling objects, activated objects
FIWF_AMGRPAmount Groups for FI Role Definition
BPDKTHeader Text Entry Document
BPCGControlling Object, by Year
FM01BControl Records for FIFM Company Codes
FMCFAATR-FM: Commitments/Budget Carried Forward
FM01SNCollective Expenditure Settings
BPDJAnnual Values Entry Document
FB03Financial Transactions
FM01BUDHORIZONNumber of Cash Effectivity Years and Financial Budget Years
FCABKFI-CA: Document Header
BPEGLine Item Overall Values Controlling Obj.
TREGField Status Groups for Funds Reservations
TBP4BAssignment of Budget Subtypes to Budget Types
BPEPLine Item Period Values Controlling Obj.
TBPFMFM Active Availability Control
KBLPWDocument item amounts in different currencies
TBPFKAvailability Control: Cost Elements Exempted
BPDKHeader Entry Document
FM01TOLTolerance for Budget Consistency Checks
FMBUDDETLBudget Detailing in Funds Management
KBLEWItem development amounts in various currencies
TREFFields for Field Selection String in Funds Reservations
TVA02Variant for Transfers from Reference Documents for Fds Rsvn
FMACTDETLDetailing of Commitment and Actual Data in Funds Management
FMBEFI-FM Cash Levels
TBPFPTCommitment Type Profile Texts
KBLPSEarmarked Funds: Value Adjustment Documents
KBLKDocument Header: Manual Document Entry
BPDGTotal Values Entry Document
TRE01Copy Template when Creating Funds Reservations
TBP1ABudget/Plan Profile
TREWFTGroup Keys for Selection of Workflow-Relevant Fields (Text)
TBPFMXActive availability control on commitment budget
KBLKKREDVendors for Funds Reservations
TKBLATDocument type text table
FM01FRG2Assign Release Approval Groups to Activity
TREFSTTTexts for Field Selection String for Funds Reservations
FM01FOverall parameters for FM areas
PIVB_TABLESource DB Tables of Pivot Browser reports
BPGVPrel.entry, overall
BPDZLine Entry Document
TBPAS_FUNDBudget Subtypes for Availability Control Per Fund
TREVField Status Variant for Funds Reservation
BPEJLine Item Annual Values Controlling Obj.
FM01CFM area control parameters
BPDPPeriod Values Entry Document
BPJVPrel.entry - annual values
FMUP02Customizbare Felder zum Fortschreibungsprofil
PIVB_CATALOGReport Catalog Definition
FMAPSTATFIFM: System Status for FIFM Acct Asst Objects
PSMFPTYPETText table for customizing table PSMFPTYPE
RESCTAdditional Criteria per Line Item
FM01DFunds Management Update Control
FM01DFBudget Type: Assignment to Cover Eligibility
TREVGAssignment: Field Status String -> Variant/Group
BPDZTText Line Entry Document
FMSNRULECollective Expenditure Rules
FMMM2Transaction Type Control
FMSD07Days Results List: FM-FI Bank/Clearing Account Comparison
FMALLOCDistribution of Collective Budget Administration
FMSUFI-FM Totals Records
FMRCCVARIACompany Code Assignment
TBPFCAvailability Control: Tolerance Limits
FIWF_MDRULMain Rules for FI Role Definition
TKBLAFunds reservation document type
FMRESGLOB_USERGlobal Settings for Earmarked Funds: User-Dependent
FMWF_BDGRPFM Account Groups for FM Role Definition
FMUDBSEGAddtl Info on Revenues Increasing Budget for Recovery Order
FCABPFI-CA: Document Item
FMUP03Customization control data for activating FM view
KBLPAYKPayment Plan Header
FMRESACCMVRULESRules for Account Assignment Transfer
FM01YFM Areas- Year-Dependent Values
FM00Client-Dependent Fields in Funds Management
FM01EInfo on cover availability per FM area
TKBBATTexts for Document Types
FM01FRG1Maintain Release Groups
BPJATotals Record for Annual Total Controlling Obj.
FM01NFollow-up posting info by FM area / application /data origin
FMR01Funds Management Information System
FMCFABTR-FM: Commitments/Budget Carried Forward (Sender+Receiver)
CTRUNICLASis being deleted
TREVTTexts for Funds Reservation Field Status Variants
FMRESINI1TEarmarked Funds: Transaction Texts
FMR_TOLSTTolerance Key for Overrun Tolerance: Texts
FMUDIFIITAdditional Data for FI Line Items f. Revenues Incr. the Bdgt
FMTACTTActivities that can be protected
FMRESFIELDSControllable Fields Earmarked Funds
TBPAS_FTYPEBudget Subtypes for Availability Control for Each Fund Type
FAGL_SP_LDGR_OIMLedgers for zero-balance follow-on documents
TBP1TBudget / Plan Profile Texts
FMRCCVARIVariant definition
FM01KTCustomizing FM Account Assignment
FMRE_MM_CATASSPermitted Types of Earmarked Funds in Purchase Order Docs
THISTTable for History
FGWF_MDRULMain Rules for General Role Definition
IAOM_GTR_EXATGrantor: Account Assignment Manager External Characteristics
BPCJControlling Object, by Year
FMUDBSEGSRecovery Order Budget Increases for Reversal
FMBUDFI-FM Data Transfer Structure FM4C
FMUP00TUpdate Profiles
FMWF_BLTYPDocument Category Assignment to FI/FM Role Defn Doc.Classes
FMUDRULECRules for Revenues Increasing the Budget
FMWF_ACTTYActivity Categories for FM Role Definition
FMSNRULECChange Documents for Collective Budget Rules
BPTRObject Data Controlling Obj.
BPVKDocument Header for Parked Documents
FCDUNICLASis being deleted
FMCFSIOFI-FM: Selected Open Commitment Documents
TBUDVGTIS-PS Budget Types: Texts
FMFUNDTYPETFM Fund Types Texts
TVA02TVariant for Funds Reservation Copying Template
TVA01TVariant for Funds Reservation Copying Template
TBP2ABudget/Plan Versions
FMICOHDFM/CO Integration: Document Header
FMREFActive availability ctrl: Cross commitments reference table
FM01_ARCHArchived FM Areas
FMBUDDETLTTexts for Budget Detailing
TREASONSReasons for Decisions in Funds Reservations
FMWF_MDRULFM Main Delegations Rules
FM01TFunds Management Area Texts
FMRESINI1Earmarked Funds: Initialization Information
FMIAAAssignment Table for Budget Ledger
FMRESACCMVRULERules for Account Assignment Transfer
FMACTPOSFIFM: List of Internal Item Numbers
TVA01Variant for Funds Reservation Copying Template
FMRC07Results List Documents Bank/Clearing Account Matching FM-FI
FMICObject table 2
FMCHA1Work List for Reassignment Tool
FMCFSBFM - CF: Carryforward rules
FMFPOTTexts for a Financia Management Item
FMVALIDValidation for Funds Management
FMEDDOCTYPETFM budget entry document type texts
FMRSCVARTDescription for Scenario Variants
FMFRGASGNAssign Transactions to Release Approval Groups
TBP4ABudget/Planning Subcategories
KBLPAYPPayment Plan Items
FMDP_DPR_CLRActivate the DP Clearing and DPR Clearing and update
FMLOGLog file for documents not updated
TBPFPVCommitment Types: Control
FMEINDECKCAssign FM Acct Assgt Requir.Cover to One Authoriz.to Give It
FMIFIITFI Line Item Table in Funds Management
FMR_TOLSTolerance Key for Overrun Tolerance
FMSNHHINTGIntegration of Collective Budget Adminisration with Budget
FMCFB_VRGNGFM: Permitted Activities for Balance Carryforward
FMUDPOOLCAssignment of Cover Pool to Rev. Increasing FM Acct Assgmt
FMITTotals Table for Funds Management
FMZUGRAllocation of CO Group to FM Account Assignment
TBP0LBudget/Planning Ledger
FMFIPGBPBudget Structure Template: FM Budgeting Control
FMCFABS_TRTR-FM: Transferred Commitment/Budget (Senders+Receivers)
FMRCCVARITVariant Text
FMIPPlan Line Items Table for Funds Management
FMRES_EW_INFOSSaving Enhancement Wizard Settings
TREWFGroup Keys for Selection of Workflow-Relevant Fields
FMEUTRANSParameters for Euro Conversion
FMZUCHChange information on allocation of CO Object to FM Object
FMCFRULEFM - Carryforward Parameters (FYC)
PIVB_CALC_KF_TPIVB: Texts for Calculated Key Figures
FMFPOFIFM: Commitment Item
FMUDKBLPAddtl Info re Revenues Increasing Budget for Fcst of Revenue
FMZUCOFM-CO Assignment Control Table
PIVB_FEATUREFeatures of Pivot Browser reports
FMUDBSEGHAddtl Info on Revenues Increasing Budget for Recovery Order
FMFCPOTFIFM: Financial Summarization Item Texts
FMHVMTXTTBudget Memo Texts, language dependent
FMCOPICO-FM: Plan Data Transfer - Annual/Overall Values
TREFSTField Selection String for Funds Reservations
FMRESACCMVRULETDescription of an Account Assignment Transfer Rule
TBPCEPTCover Eligibility Profile Texts
FMCFAB_TRTR-FM: Commitments/Budget Carried Forward (Sender+Receiver)
TBPFEFM Availability Control: Tolerance Limits
FMDKSRTGRPGroups of Sort Criteria for Cover Eligibility
FMCFB_VRGNGTFM: Balance Carryfwd Allowed Activities (Language-Dependent)
FMFIPGPAssign Commitment Item to Budget Structure Template
TBP1BBudget / Plan Profile Texts
FMWF_ACTTTTexts for Activity Categories in FI/FM Role Definition
FMCFBPAKSFM-FYC: Budget/Planning Updates (Interim Storage)
FMUDRELCAssignment of Expenditure Objs.to Revenue Objs Incr.Budget
FMEUROPLANTable of Euro FM Areas
FMCFSIO_TRFI-FM: Selected Open Commitment Documents
POS00Is No Longer Used: List of Internal Item Numbers
FMIFIHDFI Header Table in Funds Management
TFB06Financial Transaction Reporting
FMFRGZORAssign Release Group Profile
FMUDKBLPPItem Revenues Increasing Budget for Forecast of Revenue
TREWFFIELDFiels in Group Keys for Workflow (Obsolete Since 4.70)
FMMM1Assignment Table for Warehouse Funds Center
FMCFSIFFI-FM: Selected Open Documents from FI Update
FMUDRULERules for Revenues Increasing Budget
FMRESGLOBALSGlobal Settings for Earmarked Funds
FMUDBSEGPPart.Payt Item for Customer Invoice of a Rev. Incr. the Bgt
TBP1CBudget/Plan Profile
FMCFC0Default Settings for Fiscal Year Change
TBPFDCost Budget Availability Control: Tolerance Limits
FMIOICCNEarmarked Blocked Amounts for Commitments in Funds Managemnt
FMDECK3Cover eligibility: amount management for sender budget obj.
FMFUNDSELFIFM: Selected Fund for Closing Operations
FMFCPOFIFM: Commitment Summarization Item
FMTACTZFM: Valid Activities per Authorization Object (same TACTZ)
FMIUROpen Interval Rules for updating FM
TBP4TTexts for Budget/Plan Subcategories
TRE02Template for Copying from Funds Reservation Reference Docs
FMCVCHECKSDYRestrictions in the Rule Maintenance for Cover Eligibility
FMRE_WFDEC_RSNEarmarked Funds Workflow, Step IDs, Key & Decision Reason
FMRESINI2Earmarked Funds: Initialization Data
FMCVCHECKSRestrictions in the Rule Maintenance for Cover Eligibility
TBPFPCommitment Type Profile
FMEINDECKAssign FM Acct Assgt Requir.Cover to One Authoriz.to Give It
FMFREEPOSFIFM: Free List of Internal Item Numbers
TFB05Free Financial Transactions
FMFIPGRBudget Structure Template
TREGTTexts for Funds Reservation Field Status Groups
TKBBADocument Types
FMRSCDATAEarmarked Funds Data
FMCFC1RFYC Commtiment Control (Carryforward Parameter)
FMR_TOLTolerance Limits for Earmarked Funds
FMZUOBAllocation of CO Object to FM Account Assignment
TBP3BTexts for planning / budgeting versions
FMCFSBCDFM-CF: Carryforward Rules (Dummy -> Change Documents)
FMRESACCMVASSIGNAssignment of Account Assignment Transfr Rules to Activities
FMUDRELAssignment of Expenditure Objs.to Revenue Objs Incr.Budget
FMIOICommitment Documents Funds Management
FMUDOverride FM Update Date
TBPCEPCover Eligibility Profiles
FMCTRNR02Commitment-item-depending FM monitoring number
FMWF_DOCCLDocument Classes for FM Role Definition
FMRESLOCKSTTests on Earmarked Fund Blocks
FMFUNDTYPEFM Fund Types
FMRESLOCKSPossible Earmarked Fund Blocks
FMFIPGRTBudget Structure Template, Texts
FMDECKUNGAssignment of a Cover Pool to an FM Account Assignment
FMDECKHKCAssignment of FM Account Assignment to Cover Pool
TFB03TNames of Financial Transactions
FMUDKBLPSBudget Increases for Reversal for Forecast of Revenues
FMIOObject Table for Funds Management
FMHICTRFIFB: DB Table for Hierarchy Relations in a Center
FMUP00Update Control (Not Value Type Dependent)
TBPW1is being deleted
KBLK_USERFields for addtl funds commt, funds precommt etc. hdr data
FMISPSGeneral Parameters for Funds Management
FMDECKRGCover Pool
FMCFC1FYC Commitment Control
FMRSCVARScenario variants
FMDOCList of FM Documents for Revaluation
FMUP01Update Control with Value Type Dependency
FMDKSORTSort Criteria for Cover Eligibility
FMEDDOCTYPEFM budget entry document type
FMCNAIFM Line Items with Active CCN Logic
FMHIPOSFIFM: DB Table for Hierarchy Relations for an Item
FMRESUPDCStatus Table for Conversion Programs
FMWF_DOCCTTexts for FM Role Definition Document Classes
FMIAActual Line Item Table for Funds Management
FMZUKAAllocation of Cost Element to FM Account Assignment
FMS200PParallelling of RFFMS200
FMCFSIF_TRSelected Open FI Documents (Settlement)
FMUDKBLPHAddtl Info re Revenues Increasing Budget for Fcst of Revenue
KBLPDocument Item: Manual Document Entry
FMFRGPRORelease Approval Group Profiles
PIVB_FIELDMAPField Mapping: Report Catalog to DB Table
FMDECKRGTCover Pool Texts
FMICOITFM/CO integration: Line item
FMDECKHKAssignment of FM Account Assignment to Cover Pool
PIVB_CALC_KFPIVB: Table for Calculated Key Figures
PSMFPTYPECustomizing table for Funded Program Type
TREASONSTTests for Reasons for Rejection in Funds Reservations
FMRPRELAssignment of Expenditure Objects to Revenue Cover Pool
FMRPRULERules for Revenue Cover Pool
FMCFSITR-FM Selected Open Commitments
FMFRGPROTRelease Approval Group Profiles
TBPCEPVCover Eligility Profile: Control
TBP2BBudget / Plan Version Texts
PIVB_FIELDCharacteristics of Report Catalog Field
BPHICross-hierarchy Data Controlling obj.
FMWF_MDRLKMain Delegations Rules Header Entries
FMUDPOOLAssignment of Cover Pool to Rev. Increasing FM Acct Assgmt
TBP4CSelect Budget Types for Subdivision
TBP3ABudget / plan versions from rel.3.0
FMWF_AMGRPAmount Groups for FM Role Definition
FMRESUPDSTable for Conversions Programs to Run
FMTACTActivities which can be Protected
KBLEDocument Item Processing: Manual Document Entry
TBPCABudget Costing
TBUDVGIS-PS Budget Types for Payment/Commitment Budget
FMSAVE_RETSave Retention Period for Archived Document
FMRPPOOLAssignment of Expdt Cover Pool to Revenue Cover Pool
KBLESUMTotals Table KBLE