FMHIESETTINGS SAP (Settings for Budget Hierarchies) Table details
Dictionary Type: Table
Description: Settings for Budget Hierarchies
Description: Settings for Budget Hierarchies
ABAP Code to SELECT data from FMHIESETTINGS
Related tables to FMHIESETTINGS
Access table FMHIESETTINGS
Related tables to FMHIESETTINGS
Access table FMHIESETTINGS
Table field list including key, data, relationships and ABAP select examples
FMHIESETTINGS is a standard SAP Table which is used to store Settings for Budget Hierarchies data and is available within R/3 SAP systems depending on the version and release level.
The FMHIESETTINGS table consists of various fields, each holding specific information or linking keys about Settings for Budget Hierarchies data available in SAP. These include FM_AREA (Financial Management Area), BS (Name of Budget Structure), FUND_ROLE (Role of the FM AA Element in hierarchy), BUDGET_PD_ROLE (Role of the FM AA Element in hierarchy).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP FMHIESETTINGS 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 | FM01 | FIKRS | FIK | ||
BS | Name of Budget Structure | FMBS_NAME | CHAR | 10 | FMBS_BS | FMBS_NAME | FMBS_NAME | ||
FUND_ROLE | Role of the FM AA Element in hierarchy | FMHIE_HIE_ROLE | CHAR | 1 | FMHIE_HIE_ROLE | ||||
BUDGET_PD_ROLE | Role of the FM AA Element in hierarchy | FMHIE_HIE_ROLE | CHAR | 1 | FMHIE_HIE_ROLE | ||||
FUNDSCTR_ROLE | Role of the FM AA Element in hierarchy | FMHIE_HIE_ROLE | CHAR | 1 | FMHIE_HIE_ROLE | ||||
CMMTITEM_ROLE | Role of the FM AA Element in hierarchy | FMHIE_HIE_ROLE | CHAR | 1 | FMHIE_HIE_ROLE | ||||
FUNCAREA_ROLE | Role of the FM AA Element in hierarchy | FMHIE_HIE_ROLE | CHAR | 1 | FMHIE_HIE_ROLE | ||||
GRANT_NBR_ROLE | Role of the FM AA Element in hierarchy | FMHIE_HIE_ROLE | CHAR | 1 | FMHIE_HIE_ROLE | ||||
MEASURE_ROLE | Role of the FM AA Element in hierarchy | FMHIE_HIE_ROLE | CHAR | 1 | FMHIE_HIE_ROLE | ||||
USERDIM_ROLE | Role of the FM AA Element in hierarchy | FMHIE_HIE_ROLE | CHAR | 1 | FMHIE_HIE_ROLE | ||||
SORT_ORDER1 | Account Assignment Element | FMHIE_MASDAT_ID | CHAR | 1 | FMHIE_TTXID_TYPE | ||||
SORT_ORDER8 | Account Assignment Element | FMHIE_MASDAT_ID | CHAR | 1 | FMHIE_TTXID_TYPE | ||||
SORT_ORDER2 | Account Assignment Element | FMHIE_MASDAT_ID | CHAR | 1 | FMHIE_TTXID_TYPE | ||||
SORT_ORDER3 | Account Assignment Element | FMHIE_MASDAT_ID | CHAR | 1 | FMHIE_TTXID_TYPE | ||||
SORT_ORDER4 | Account Assignment Element | FMHIE_MASDAT_ID | CHAR | 1 | FMHIE_TTXID_TYPE | ||||
SORT_ORDER5 | Account Assignment Element | FMHIE_MASDAT_ID | CHAR | 1 | FMHIE_TTXID_TYPE | ||||
SORT_ORDER6 | Account Assignment Element | FMHIE_MASDAT_ID | CHAR | 1 | FMHIE_TTXID_TYPE | ||||
SORT_ORDER7 | Account Assignment Element | FMHIE_MASDAT_ID | CHAR | 1 | FMHIE_TTXID_TYPE | ||||
CRTUSER | User Who Created or Updated the Object | BUKU_CRTUSER | CHAR | 12 | USERNAME | ||||
CRTDATE | Date on which the object was created or updated | BUKU_CRTDATE | DATS | 8 | DATE | ||||
CRTTIME | Time at which the object was created or updated | BUKU_CRTTIME | TIMS | 6 | TIME | ||||
CHGUSER | Last user to change object | BUKU_CHGUSER | CHAR | 12 | USERNAME | ||||
CHGDATE | Date on which the object was changed | BUKU_CHGDATE | DATS | 8 | DATE | ||||
CHGTIME | Time at which the object was changed | BUKU_CHGTIME | TIMS | 6 | TIME |
Key field | Non-key field |
How do I retrieve data from SAP table FMHIESETTINGS using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMHIESETTINGS to SELECT all data from the tableDATA: WA_FMHIESETTINGS TYPE FMHIESETTINGS.
SELECT SINGLE *
FROM FMHIESETTINGS
INTO CORRESPONDING FIELDS OF WA_FMHIESETTINGS
WHERE...
How to access SAP table FMHIESETTINGS
Within an ECC or HANA version of SAP you can also view further information about FMHIESETTINGS 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