SAP Budgeting Tables
Are you looking for the right table related to SAP Budgeting 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 Budgeting (PSM-FM-BCS-BU) module.
Top 10 tables in Budgeting
| Table | Description |
|---|---|
| FMCECGADDRS | Cover Groups: Assigned Budget Addresses |
| BURBCALCRULEST | Texts on Calculation Rules for Revenues Increasing the Bud. |
| BTXPHPR01 | Budge_text: Attributes of Physical Information Objects |
| FMBS_BO_MIG | Conversion of Table for FM Budget Addresses |
| BTXCHKF01 | Budge_text: File Name of Last Check Out |
| BUKF_KFCAT | Key Figures - Key Figure/Category relation |
| FMBUDTYPE | Budget type definition |
| BTXCHKO01 | Budge_text: Check-Out Data for a Physical Information Obj. |
| BTXCONT01 | Budge_text: Table for Document Contents (Import/Export) |
| BUPROCESST | Texts of Internal Budgeting Processes |
List of tables in Budgeting
| Table | Description |
|---|---|
| FMCECGADDRS | Cover Groups: Assigned Budget Addresses |
| BURBCALCRULEST | Texts on Calculation Rules for Revenues Increasing the Bud. |
| BTXPHPR01 | Budge_text: Attributes of Physical Information Objects |
| FMBS_BO_MIG | Conversion of Table for FM Budget Addresses |
| BTXCHKF01 | Budge_text: File Name of Last Check Out |
| BUKF_KFCAT | Key Figures - Key Figure/Category relation |
| FMBUDTYPE | Budget type definition |
| BTXCHKO01 | Budge_text: Check-Out Data for a Physical Information Obj. |
| BTXCONT01 | Budge_text: Table for Document Contents (Import/Export) |
| BUPROCESST | Texts of Internal Budgeting Processes |
| BUTECHORGT | Texts for Original Applications (Budgeting) |
| BUBUDCAT | List of budget category instances |
| BURBCALCRULES | Calculation Formulas for Revenues Increasing the Budget |
| FMBS_CONTROL | Budget structure settings on FM area and fiscal year level |
| BUKUTEXTCAT | Budget Text Categories |
| FMCUPRPT | Texts for Field Profiles for Provisionally Posted Bdgt Docs |
| FMCYDOC | Links source and targets during the copy of documents |
| FMORGFAV | BCS : Organizer Favorites |
| FMMIGOV | Overview of Migration Status |
| BUCC_RULE_OPD | Consistency Checks - Operands |
| BUKF_CAT_T | Key Figures - Category Texts |
| BUKUTEXTTEMPLT | Texts for Budget Text Templates |
| BUKUTEXTCATT | Texts for Budget Text Categories |
| BUFIELDS | Control allowed Field Names - Field Status Management |
| FMREL_FUND | Release settings for Fund |
| FMBDP | FM Budget change line items table |
| BUKF_FG_FIELD | Key Figures - Fields of field group |
| BUPPSTFIELDS | Fields Which Can be Changed in Preposted Documents |
| BUPROCESS_UI | User Interface Process |
| FMPEP_VARIANTHT | Session Variant Text |
| BUKF_DSRC_FIELD | Key Figures - Data source field |
| FMCONSUM_FTYPE | Consumable budget type for Fund Type |
| BUKUTXTTEMPLVART | Texts for Variables in Budget Text Templates |
| FMPEPLAY_H | FMPEP - Layout Customizing Settings - Header |
| FMRBC | Object table 2 |
| FMPRPDEF | Edit Field Profile for Preposted Documents |
| BTXLORI01 | Budge_text: Incoming Relations of Logical Info Objects |
| FMPEPLAY_COL | FMPEP: layout customizing settings for columns |
| FMROLLUP_FTYPE | Preclosing Rollup: Transfer Rules for Fund Type |
| FMPEP_ADM_SV | Session Variants administration |
| BUBUDCATT | Texts for Budget Categories |
| FMBCSA_USER | User specific Budget Control System activation settings |
| FMREL_FTYPE | Consumable budget type for Fund Type |
| FMPTCOMBG | Allowed Combinations Process/Budget Type Using BT Groups |
| BUCC_RULE_T | Rule Texts for Consistency Checks |
| FMMIGDOC | Migrated Documents |
| FMCCFBDGT_CNTRL | Customizing settings: creation of budget during ccf |
| FMBUMANAGER | Management of budgeting enironment in FM |
| BTXDOCL01 | Budge_text: Instances of Logical Information Objects |
| FMSTATDEFT | Texts for Budgeting Status |
| FMRBBRECS | Budget Receivers per RIB Rule |
| FMFSS | Field Status String definition |
| BUCC_LIB_T | Library Texts for Consistency Checks |
| FMPEPLAY_TAB_T | FMPEP - Layout Customizing Settings - Tabstrips (Text) |
| FMFSGT | Text for Field Status Group |
| FMDISTCK | Distribution Checks |
| BTXPHNM01 | Budge_text: Use of Target Anchors in Physical Objects |
| FMBS_FMADDRESS | Budget Structure Elements |
| FMMAACT | Activation of Multi-annual Budgeting |
| FMROLLUP_FUND | Preclosing Rollup: Transfer Rules for Fund |
| FMDIMSTATE | Definition of state for account assignment element |
| FMRBCDACT | Activation of Change Documents for Cover Elibility |
| FMRBBOBJECTS | RIB Rules For Revenue Increasing the Budget |
| FMCECDACT | Activation of Change Documents for Cover Elibility |
| BUKF_DSRC_T | Key Figures - Texts for Data Sources |
| BUPROCESS_UIT | Texts for Budgeting Processes (User Interface - UI) |
| FMFSST | Text for Field Status definition |
| FMPEP_UI_MODEL | Define UI model for Multiple Budget Entry transaction |
| FMCONSUM_FUND | Consumable budget type for Fund |
| FMBWUS | Budgeting Workbench User settings |
| FMHIE_CHGCHK_FLG | Activate Checks for Hierarchy Change |
| FMPEPLAY | FMPEP - Layout Customizing Settings - Basic Data |
| FMPTCOMB | Allowed combinations (process / budget type) |
| FMRELSTATE | Definition of release scenario |
| BUKF_KFDSRC | Key Figures - Key Figure Datasources relation |
| FMBUDTXT | Budget texts register |
| BTXPHRI01 | Budge_text: Incoming Relations of Physical Info Objects |
| FMBUCOBUSTRANSAC | Restriction Business transaction for CO Plan Transfer to BCS |
| FMCUPRP | Field Profile for Preposted or Posted Budget Documents |
| FMRB_RULE_MIG | Conversion of FM RIB Rules |
| FMHBH | Funds management budget header (held documents) |
| FMREV_STGRD_ACT | Activation of the Reversal Reason for Budget Documents |
| BUKF_CAT | Key Figures - Category |
| FMBS_BS_T | Texts for Budget Structures |
| BUVALTYPE | List of budgeting value type instances |
| BTXPHHR01 | Budge_text: Outgoing Hyperlinks From Physical Objects |
| FMRBA | Actual line item table |
| FMEDFORMS_WD | Assignment of Forms for Entry document |
| FMBCSSUBDIVFMHBL | Extension table for table FMHBL (Subdivision) |
| FMRBACTCD | Activation of Change Documents for FMRBT Records |
| FMPSTDEF | Edit Field Profile for Posted Documents |
| FMCECVGRP | Cover Groups |
| BUKF_DSRC | Key Figures - Data source |
| FMLAT | Texts for Layout Variants |
| FMRBT | Summary table RIB (no more updated!) |
| BTXDOCP01 | Budge_text: Instances of Physical Information Objects |
| FMSTATDEF | Budgeting status definition |
| FMBUDTYPET | Texts for Budget Types |
| BUKF_FG | Key Figures - Field group |
| FMBULEDGERS | Relation between posting and budgeting ledgers |
| FMHIEIDS | Hierarchy IDs |
| BUKF_KF | Key Figures - Key Figure |
| FMACTIVPER | Activate Period Control Budgeting |
| FMHIESETTINGS | Settings for Budget Hierarchies |
| BUKF_KF_T | Key Figures - Texts for Key Figures |
| BTXPHF01 | Budge_text: Files of Physical Information Objects |
| FMBUDTXT_KEY | Budget Text Key Customizing |
| FMPROFILE | Profile for BCS budgeting |
| BURBBLEDGERST | Ledger Text for Revenues Increasing the Budget |
| FMBUCOPI | CO plan integration with FM Budgeting |
| FMPEPLAY_TAB | FMPEP - Layout Customizing Settings - Tabstrips |
| BTXLORE01 | Budge_text: Outgoing Relations of Logical Information Object |
| FMREV_STGRD_DEF | Allowed Reversal Reasons for Budget Documents |
| BUKUTEXTTEMPL | Templates for Budget Texts |
| FMBDC | Object table 2 |
| BTXLOPR01 | Budge_text: Attribute Values of Logical Information Objects |
| BURBBLEDGERS | Ledgers for Revenue Increasing the Budget |
| FMBS_BS | Budget structures |
| FMCUPRPCOM | Assignment of Field Profiles for Preposted Budget Documents |
| FMPTCOMBAG | Allowed combinations process / budget type group for status |
| FMRBO | Object table 1 |
| BUKF_FIELD_VALUE | Key Figures - Data source fields checks per category |
| BUKF_FG_T | Key Figures - Texts for Field Groups |
| FMBUSTATUS | Status and budget addresses settings on the version level |
| FMPEPLAY_COL_T | FMPEP - Layout Customizing Settings - Columns (Text) |
| BTXPHRE01 | Budge_text: Outgoing Relations of Physical Info Objects |
| BUCC_RULE | Consistency Checks - Rules |
| FMPEP_FIELD_ATTR | FMPEP: system table for field attributes handling |
| FMDISTA | Distribution Activation |
| BUKF_CATDSRC | Key Figures - Category/Data source relation |
| CCF_CORR | Table of actions in correction of carryforward |
| FMDISTC | Distribution Checks |
| BUPOSTFIELDS | Fields Which Can be Changed in Posted Documents |
| FMMAPERC | Standard percentage set for multi-annual budgeting |
| BTXIDXST01 | Budge_text: Status Table for Indexing Documents |
| BUPROCESS | Internal budgeting process |
| BUKUTXTTEMPLVAR | Variables for Budget Text Templates |
| FMMACGPERC | Percentage per cover group (Multi-annual budgeting) |
| FMPTCOMBA | Allowed combinations (process / budget type) for status |
| FMFSVA | Assignment of Field Status Variant |
| BUFUNCTIONS | Budgeting Functions to Activate /Deactivate buttons |
| FMFSV | Field Status Variant definition |
| FMPRPDEFBUT | Edit Button Profile for Preposted Documents |
| FMBL | Funds management budget document lines (entry documents) |
| FMRBACT | RIB Customizing Settings |
| BUFUNCTIONST | Functions Texts |
| FMOPENPER | Control Budgeting Periods |
| BUCC_RULE_MSG | Consistency Checks - Message of the rule |
| BUCC_LIB | Consistency Checks - Library |
| FMFSGA | Assignment of Field Status Group |
| FMBCS_FMBL_CD | Empty table for change documents on FMBL incl. local. fields |
| FMCEACT | Activation of Cover Elibility |
| FMBDO | Object table 1 - Budget address |
| FMEDDOCFORMS | Assignment of Forms for Entry document |
| FMBDA | Actual line item table |
| FMFSSDEF | Edit Field Status String |
| FMCUPRPCDACT | Activation of Change History for Preposted Documents |
| BUVALTPRO | Valid Combinations Between Process and Value Type |
| FMHBL | Funds management budget document lines (held documents) |
| FMBTGROUP | Budget Type Group definition |
| BUTECHORG | Table of original Transactions (Technical) |
| FMLA | Layout Variant |
| FMCCFBDGT_CUST | Customizing settings: creation of budget during ccf |
| FMBSCDACT | Activation of Change Documents for Budget Structure |
| FMPEP_VARIANTH | Session variants (header part) for transaction FMPEP |
| FMMIGPAR | Partially Migrated Documents |
| FMOPENPER_FUND | Control Budgeting Periods per Fund |
| FMRIBDOCP | Document Based RIB Segment |
| BUPROCESS_UI_RD | Reduce Process UI |
| FMBS_HIE_ACT | Activation of Hierarchical Budget Structure |
| FMFSSA | Assign Field Status String |
| FMPEP_VARIANTL | Session variants (line part) for transaction FMPEP |
| FMFSVT | Text for Field Status Variant definition |
| FMCC_CUST_LIB | FM - Consistency checks - Assignment of libraries |
| FMKF_TERM_RB | Key Figures - FM Terms |
| BUWRTTP | Mapping rules for migration from FBS to BCS - Field WRTTP |
| FMCECVGRPT | Texts for Cover Groups |
| FMKF_TERM_AVC | Key Figures - FM AVC Term |
| FMBDT | FM budget totals table (no more updated!) |
| FMCY_COPI | For CO plan data transfer |
| FMKF_DSRC_EVAL | Key Figures - Evaluation class of data source |
| BUVORGA | Mapping rules for migration from FBS to BCS - Field VORGA |
| FMBUDCAT | Budget category activation |
| FMBS_BO | Budget Addresses |
| FMBWUD | User Documents |
| FMBS_VERS_ASS | Budget Addresses settings on the version level |
| FMHIEHEADERS | Hierarchy Nodes: Constant Parts ("Headers") |
| FMBTGDEF | Budget Group content definition |
| FMBCSA | Budget Control System activation settings |
| BUVALTYPET | Texts for Budgeting Value Type Instances |
| FMHIEIDST | Texts for Hierarchy IDs |
| FMHIENODES | Hierarchy Nodes (Without Constant Part) |
| FMFSG | Field Status Group definition |
| FMBTGROUPT | Text for Budget Type Group |
| FMEDDOCTYPEA | Assign process to document type |
| FMBS_CONTROL_LDR | BS settings FM area, fisc. year and posting ledger |
| FMBCSSUBDIVFMBL | Extension Fields for Subdivision |
| FMBH | Funds management budget header (entry documents) |
| FMKF_TERM | Key Figures - FM Terms |
| FMKU_T_CCF_CORR | table of corrections for CCF |
| BTXLOIOT01 | Budge_text: Descriptions of Logical Information Objects |
| FMPEPLAY_T | FMPEP - Layout Customizing Settings - Basic Data (Text) |
| FMRBP | Plan line items table |
| FMSIGNPREP | Sign Handling for Plan Data |