The FMHBL table in SAP ERP or S/4HANA stores Funds management budget document lines (held documents) data. There are total 57 fields in FMHBL table. The Funds management budget document lines (held documents) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMHBL table. It is in New budgeting: FM application part (FMBPA_E) ABAP package and is part of the Budgeting (PSM-FM-BCS-BU) module.
SAP FMHBL Table Fields
Following is the list of fields that are available in SAP FMHBL table. The primary key fields of the table are CLIENT (Client), FM_AREA (Financial Management Area), CRTUSER (User Who Created or Updated the Object), DOCNR (Temporary Document Number (for Incomplete Documents )), DOCLN (Budget entry document line), RPMAX (Period).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| FM_AREA | Financial Management Area | FIKRS | CHAR (4) | |
| CRTUSER | User Who Created or Updated the Object | BUKU_CRTUSER | CHAR (12) | |
| DOCNR | Temporary Document Number (for Incomplete Documents ) | TEMPN | CHAR (10) | |
| DOCLN | Budget entry document line | BUED_DOCLN | CHAR (6) | |
| RPMAX | Period | RPMAX | NUMC (3) | |
| FLG_ADDED | Indicator for Additional Line | BUED_FLG_ADDED | CHAR (1) | |
| CTEM_CATEGORY | Commitment Item Category | FM_POTYP | NUMC (1) | |
| FISCYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| CEFFYEAR | Year of Cash Effectivity | GNJHR | NUMC (4) | |
| FUND | Fund | BP_GEBER | CHAR (10) | |
| BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | CHAR (10) | |
| FUNDSCTR | Funds Center | FISTL | CHAR (16) | |
| CMMTITEM | Commitment item | FM_FIPEX | CHAR (24) | |
| FUNCAREA | Functional Area | FM_FAREA | CHAR (16) | |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR (20) | |
| MEASURE | Funded Program | FM_MEASURE | CHAR (24) | |
| USERDIM | Customer Field for FM Actual and Commitment Data | FM_USERDIM | CHAR (10) | |
| BUDCAT | Budget Category | BUKU_BUDCAT | CHAR (2) | |
| VALTYPE | BCS Value Type | BUKU_VALTYPE | CHAR (2) | |
| PROCESS | Internal Budgeting Process | BUKU_PROCESS | CHAR (4) | |
| BUDTYPE | Budget Type | BUKU_BUDTYPE | CHAR (4) | |
| TCURR | Transaction Currency | TWAER | CUKY (5) | |
| TVAL01 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL02 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL03 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL04 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL05 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL06 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL07 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL08 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL09 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL10 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL11 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL12 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL13 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL14 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL15 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| TVAL16 | Budget amount in transaction currency | TVALXX9 | CURR (17) | |
| LVAL01 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL02 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL03 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL04 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL05 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL06 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL07 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL08 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL09 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL10 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL11 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL12 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL13 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL14 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL15 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| LVAL16 | Budget amount in local currency | LVALXX9 | CURR (17) | |
| DISTKEY | Distribution Key | SPRED | CHAR (4) | |
| TEXT50 | Item Text | SGTXT | CHAR (50) |
