FMHBL SAP (Funds management budget document lines (held documents)) Table details
Description: Funds management budget document lines (held documents)
Table field list including key, data, relationships and ABAP select examples
FMHBL is a standard SAP Table which is used to store Funds management budget document lines (held documents) data and is available within R/3 SAP systems depending on the version and release level.
The FMHBL table consists of various fields, each holding specific information or linking keys about Funds management budget document lines (held documents) data available in SAP. These include 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).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FMHBL table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
FM_AREA | Financial Management Area | FIKRS | CHAR | 4 | Assigned to domain | FIKRS | FIK | ||
CRTUSER | User Who Created or Updated the Object | BUKU_CRTUSER | CHAR | 12 | USERNAME | ||||
DOCNR | Temporary Document Number (for Incomplete Documents ) | TEMPN | CHAR | 10 | ALPHA | BELNR | |||
DOCLN | Budget entry document line | BUED_DOCLN | CHAR | 6 | DOCLN6 | ||||
RPMAX | Period | RPMAX | NUMC | 3 | RPMAX | ||||
FLG_ADDED | Indicator for Additional Line | BUED_FLG_ADDED | CHAR | 1 | BUED_FLG_ADDED | ||||
CTEM_CATEGORY | Commitment Item Category | FM_POTYP | NUMC | 1 | FM_POTYP | ||||
FISCYEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
CEFFYEAR | Year of Cash Effectivity | GNJHR | NUMC | 4 | GJAHR | GJAHR | GNJHR | ||
FUND | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
FUNDSCTR | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
CMMTITEM | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
FUNCAREA | Functional Area | FM_FAREA | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
USERDIM | Customer Field for FM Actual and Commitment Data | FM_USERDIM | CHAR | 10 | CHAR10 | ||||
BUDCAT | Budget Category | BUKU_BUDCAT | CHAR | 2 | Assigned to domain | ALPHA | RLDNR | BUDCAT | |
VALTYPE | BCS Value Type | BUKU_VALTYPE | CHAR | 2 | Assigned to domain | BUKU_VALTYPE | |||
PROCESS | Internal Budgeting Process | BUKU_PROCESS | CHAR | 4 | Assigned to domain | BUKU_PROCESS | |||
BUDTYPE | Budget Type | BUKU_BUDTYPE | CHAR | 4 | CHAR4 | BUTY | |||
TCURR | Transaction Currency | TWAER | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
TVAL01 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL02 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL03 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL04 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL05 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL06 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL07 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL08 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL09 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL10 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL11 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL12 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL13 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL14 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL15 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
TVAL16 | Budget amount in transaction currency | TVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL01 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL02 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL03 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL04 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL05 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL06 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL07 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL08 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL09 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL10 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL11 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL12 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL13 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL14 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL15 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
LVAL16 | Budget amount in local currency | LVALXX9 | CURR | 17(2) | WERTV9 | ||||
DISTKEY | Distribution Key | SPRED | CHAR | 4 | Assigned to domain | SPRED | GSP | ||
TEXT50 | Item Text | SGTXT | CHAR | 50 | TEXT50 |
Key field | Non-key field |
How do I retrieve data from SAP table FMHBL using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMHBL to SELECT all data from the tableDATA: WA_FMHBL TYPE FMHBL.
SELECT SINGLE *
FROM FMHBL
INTO CORRESPONDING FIELDS OF WA_FMHBL
WHERE...
How to access SAP table FMHBL
Within an ECC or HANA version of SAP you can also view further information about FMHBL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects