FMBS_BS SAP (Budget structures) Table details
Dictionary Type: Table
Description: Budget structures
Description: Budget structures
Table field list including key, data, relationships and ABAP select examples
FMBS_BS is a standard SAP Table which is used to store Budget structures data and is available within R/3 SAP systems depending on the version and release level.
The FMBS_BS table consists of various fields, each holding specific information or linking keys about Budget structures data available in SAP. These include FM_AREA (Financial Management Area), BS (Name of Budget Structure), FLG_HIERARCHICAL (Activate Multi-Level Budget Structure), CRTUSER (User Who Created or Updated the Object).. 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
Text table = FMBS_BS_T
SAP FMBS_BS 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_NAME | FMBS_NAME | |||
FLG_HIERARCHICAL | Activate Multi-Level Budget Structure | FMHIE_FLG_HIERARCHICAL | CHAR | 1 | XFELD | ||||
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 FMBS_BS using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMBS_BS to SELECT all data from the tableDATA: WA_FMBS_BS TYPE FMBS_BS.
SELECT SINGLE *
FROM FMBS_BS
INTO CORRESPONDING FIELDS OF WA_FMBS_BS
WHERE...
How to access SAP table FMBS_BS
Within an ECC or HANA version of SAP you can also view further information about FMBS_BS 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