FMBWUS SAP (Budgeting Workbench User settings) Table details

Dictionary Type: Table
Description: Budgeting Workbench User settings




ABAP Code to SELECT data from FMBWUS
Related tables to FMBWUS
Access table FMBWUS




Table field list including key, data, relationships and ABAP select examples

FMBWUS is a standard SAP Table which is used to store Budgeting Workbench User settings data and is available within R/3 SAP systems depending on the version and release level.

The FMBWUS table consists of various fields, each holding specific information or linking keys about Budgeting Workbench User settings data available in SAP. These include USERNAME (User name), VALTYPE (BCS Value Type), PROCESS_UI (Budgeting Process), BUDCAT (Budget Category).. 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: Cannot Be Enhanced


SAP FMBWUS 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
USERNAMEUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
VALTYPEBCS Value Type BUKU_VALTYPECHAR2Assigned to domainBUKU_VALTYPE
PROCESS_UIBudgeting Process BUKU_PROCESS_UICHAR4Assigned to domainBUKU_PROCESS_UI
BUDCATBudget Category BUKU_BUDCATCHAR2Assigned to domainALPHARLDNRBUDCAT
SPLITSplit flag for transfer in two screens FMBW_SPLITCHAR1XFELD
LAYOUTVARLayout variant - Layout management in budgeting FMLA_LAYOUTVARCHAR6FMLAFMLA_LAYOUTVARLAY
KEYFIG01ID of the Key Figure BUKF_KEYFIGCHAR15BUKF_KEYFIG
KEYFIG02ID of the Key Figure BUKF_KEYFIGCHAR15BUKF_KEYFIG
KEYFIG03ID of the Key Figure BUKF_KEYFIGCHAR15BUKF_KEYFIG
KEYFIG04ID of the Key Figure BUKF_KEYFIGCHAR15BUKF_KEYFIG
KEYFIG05ID of the Key Figure BUKF_KEYFIGCHAR15BUKF_KEYFIG
TREE_ONCheckbox XFELDCHAR1XFELD
KFCREATE_ONCheckbox XFELDCHAR1XFELD
KFDISPLAY_ONCheckbox XFELDCHAR1XFELD
KFCHANGE_ONCheckbox XFELDCHAR1XFELD
KFREVERSE_ONCheckbox XFELDCHAR1XFELD
KFSIMULATE_ONSimulation of key figures FMBW_FLG_KF_SIMULATECHAR1XFELD
DEFAULT_LAYOUTLayout as default for all documents FMBW_FLG_DEFAULT_LAYOUTCHAR1XFELD
CC_PROTOCOL_ONConsistency checks - Active/inactive status of the protocol BUCC_PROTOCOL_ACTIVATIONCHAR1BOOLE
BUDCATKEYFIG0117-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG0217-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG0317-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG0417-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG0517-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG0617-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG0717-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG0817-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG0917-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG1017-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG1117-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG1217-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG1317-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG1417-Char. Field CHAR17CHAR17CHAR17
BUDCATKEYFIG1517-Char. Field CHAR17CHAR17CHAR17

Key field Non-key field



How do I retrieve data from SAP table FMBWUS using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMBWUS to SELECT all data from the table
DATA: WA_FMBWUS TYPE FMBWUS.

SELECT SINGLE *
FROM FMBWUS
INTO CORRESPONDING FIELDS OF WA_FMBWUS
WHERE...

How to access SAP table FMBWUS

Within an ECC or HANA version of SAP you can also view further information about FMBWUS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!