1. SAP Tutorial
  2. SAP PSM

FMBWUS SAP table for – Budgeting Workbench User settings

Here we would like to draw your attention to FMBWUS table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). FMBWUS is a SAP standard transp table used for storing Budgeting Workbench User settings related data in SAP. It comes under the package FMBPA_E.

SAP FMBWUS table

Table FMBWUS technical data

TableFMBWUS
Data storingBudgeting Workbench User settings
ModulePSM
Sub ModulePSM-FM-BCS-BU
SAP PackageFMBPA_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMBWUS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMBWUS table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • USERNAME : User name
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • VALTYPE : BCS Value Type
    Its data type is CHAR (Character String) with field length 2
  • PROCESS_UI : Budgeting Process
    Its data type is CHAR (Character String) with field length 4
  • BUDCAT : Budget Category
    Its data type is CHAR (Character String) with field length 2
  • SPLIT : Split flag for transfer in two screens
    Its data type is CHAR (Character String) with field length 1
  • LAYOUTVAR : Layout variant – Layout management in budgeting
    Its data type is CHAR (Character String) with field length 6
  • KEYFIG01 : ID of the Key Figure
    Its data type is CHAR (Character String) with field length 15
  • KEYFIG02 : ID of the Key Figure
    Its data type is CHAR (Character String) with field length 15
  • KEYFIG03 : ID of the Key Figure
    Its data type is CHAR (Character String) with field length 15
  • KEYFIG04 : ID of the Key Figure
    Its data type is CHAR (Character String) with field length 15
  • KEYFIG05 : ID of the Key Figure
    Its data type is CHAR (Character String) with field length 15
  • TREE_ON : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • KFCREATE_ON : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • KFDISPLAY_ON : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • KFCHANGE_ON : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • KFREVERSE_ON : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • KFSIMULATE_ON : Simulation of key figures
    Its data type is CHAR (Character String) with field length 1
  • DEFAULT_LAYOUT : Layout as default for all documents
    Its data type is CHAR (Character String) with field length 1
  • CC_PROTOCOL_ON : Consistency checks – Active/inactive status of the protocol
    Its data type is CHAR (Character String) with field length 1

    • FMBWUS related tables

    • FMPROFILE : Profile for BCS budgeting
    • FMROLLUP_FUND : Preclosing Rollup: Transfer Rules for Fund
    • FMBH : Funds management budget header (entry documents)
    • FMBDT : FM budget totals table
    • FMMIGPAR : Partially Migrated Documents
    • FMBL : Funds management budget document lines (entry documents)
    • BTXCHKF01 : Budge_text: File Name of Last Check Out
    • FMCC_CUST_LIB : FM – Consistency checks – Assignment of libraries
    • FMREL_FTYPE : Consumable budget type for Fund Type
    • FMRELSTATE : Definition of release scenario
    • FMKF_TERM_RB : Key Figures – FM Terms
    • FMHBH : Funds management budget header (held documents)
    • FMPEP_FIELD_ATTR : FMPEP: system table for field attributes handling
    • FMFSSA : Assign Field Status String
    • FMBS_CONTROL_LDR : BS settings FM area, fisc. year and posting ledger
    • FMBSCDACT : Activation of Change Documents for Budget Structure
    • FMREL_FUND : Release settings for Fund
    • FMMAACT : Activation of Multi-annual Budgeting
    • FMPEPLAY_COL : FMPEP: layout customizing settings for columns
    • FMPEPLAY_COL_T : FMPEP – Layout Customizing Settings – Columns (Text)

    FMBWUS related transaction codes under SAP package FMBPA_E

    • FMKFDEF : FM Definition of Key Figures
    • FMBSPOHISDEL : Delete Change History of Post. Addr.
    • FMMPTRAN : Transfer postings
    • FMCYCOPI_BW : Transfer of SAP BW PlanData to BCS
    • FMBSIDX_INCON : Display index inconsistencies
    • FMB_PT01 : Budget Totals Vs. Commt./Actual Tot.
    • FMB_A01 : Budget Consumption View
    • FMBS_STAT : Budget Structure Settings
    • FMBSBO_GEN : Generate budget objects from budget
    • FMPLADM : FI-FM: Planner Profile Maintenance
    • FMPLDPD : FI-FM: Change Plan Data
    • FMRP_RFFMBWBM : BW: Text-Upload
    • FMB_B01 : Budget View by Document Type
    • FMBSPO_DATA : Actual/Commitment on invalid objects
    • FMKUTOTCOL : Collect Budget Totals
    • FMBSBO_MULT : Maintain budget objects
    • FMBSPO : Change Posting Addresses
    • FMMPRBB : Increase Budget from Revenues
    • FMEDDH : Display Budget Documents
    • FMMPROLLUP : Rollup budget

    Related References

    Related Tutorials

    FMBB SAP tcode for – Budgeting Workbench

    FMBB tcode in SAP PSM (Funds Management in PSM) module. This transaction code is used for Budgeting Workbench. See the...

    FMBCSA_USER SAP table for – User specific Budget Control System activation settings

    FMBCSA_USER table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of User specific...

    FMBUMANAGER SAP table for – Management of budgeting enironment in FM

    FMBUMANAGER table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Management of...

    FMOPENPER SAP table for – Control Budgeting Periods

    FMOPENPER table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Control Budgeting...

    FMOPENPER_FUND SAP table for – Control Budgeting Periods per Fund

    FMOPENPER_FUND table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Control Budgeting...

    FMMAACT SAP table for – Activation of Multi-annual Budgeting

    FMMAACT table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Activation of...

    FMACTIVPER SAP table for – Activate Period Control Budgeting

    FMACTIVPER table in SAP PSM (Funds Management in PSM) module. This table is used for storing data of Activate Period...

    «
    »