FMBDT SAP (FM budget totals table) Table details

Dictionary Type: Table
Description: FM budget totals table




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




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

FMBDT is a standard SAP Table which is used to store FM budget totals table data and is available within R/3 SAP systems depending on the version and release level.

The FMBDT table consists of various fields, each holding specific information or linking keys about FM budget totals table data available in SAP. These include RLDNR (Ledger), RRCTY (Record Type), RVERS (Version), RYEAR (Fiscal Year).. 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 FMBDT 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
RCLNTClient MANDTCLNT3T000MANDT
RLDNRLedger RLDNRCHAR2T881ALPHARLDNRGLNH_T881
RRCTYRecord Type RRCTYCHAR1RRCTY
RVERSVersion VERSNCHAR3TKVSALPHACOVERSIKVS
RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
ROBJNRObject number for objects (account assignment elements) GOBJNR_RCHAR18OBJNR
COBJNRObject number for transaction attributes GOBJNR_CCHAR18OBJNR
SOBJNRObject number for partner objects (accnt assignmnt elements) GOBJNR_SCHAR18OBJNR
RTCURCurrency Key RTCURCUKY5TCURCWAERSFWS
DRCRKDebit/Credit Indicator SHKZGCHAR1SHKZG
RPMAXPeriod RPMAXNUMC3RPMAX
RFIKRSFinancial Management Area FIKRSCHAR4FM01FIKRSFIK
RFUNDFund FM_FUNDCHAR10FMFINCODEBP_GEBERFIC
RFUNDSCTRFunds Center FISTLCHAR16FMFCTRFISTLFIS
RCMMTITEMCommitment Item FM_FIPEXCHAR24FMCIFM_FIPEXFPS
RFUNCAREAFunctional Area FKBERCHAR16TFKBFKBERFBE
RUSERDIMCustomer Field for FM Actual and Commitment Data FM_USERDIMCHAR10CHAR10
RGRANT_NBRGrant GM_GRANT_NBRCHAR20GMGRALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
RMEASUREFunded Program FM_MEASURECHAR24FMMEASUREFM_MEASUREFM_MEASURE
BUDGET_PD_9FM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
CEFFYEAR_9Year of Cash Effectivity GNJHRNUMC4GJAHRGJAHRGNJHR
VALTYPE_9BCS Value Type BUKU_VALTYPECHAR2Assigned to domainBUKU_VALTYPE
WFSTATE_9Workflow Status of a Record in the Budget Totals Table BUKU_WFSTATECHAR1BUKU_WFSTATE
PROCESS_9Internal Budgeting Process BUKU_PROCESSCHAR4BUPROCESSBUKU_PROCESS
BUDTYPE_9Budget Type BUKU_BUDTYPECHAR4FMBUDTYPECHAR4BUTY
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
TSLVTBalance carried forward in transaction currency TSLVT9CURR17(2) WERTV9
TSL01Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL02Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL03Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL04Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL05Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL06Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL07Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL08Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL09Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL10Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL11Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL12Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL13Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL14Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL15Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
TSL16Total of transactions of the period in transaction currency TSLXX9CURR17(2) WERTV9
HSLVTBalance carried forward in local currency HSLVT9CURR17(2) WERTV9
HSL01Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL02Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL03Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL04Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL05Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL06Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL07Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL08Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL09Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL10Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL11Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL12Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL13Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL14Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL15Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
HSL16Total of transactions of the period in local currency HSLXX9CURR17(2) WERTV9
KSLVTBalance carried forward in group currency KSLVT9CURR17(2) WERTV9
KSL01Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL02Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL03Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL04Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL05Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL06Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL07Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL08Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL09Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL10Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL11Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL12Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL13Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL14Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL15Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
KSL16Total of transactions of the period in group currency KSLXX9CURR17(2) WERTV9
CSPREDDistribution key for currency amounts CSPREDCHAR4T821SSPREDGSP
CTEM_CATEGORY_9Commitment Item Category FM_POTYPNUMC1FM_POTYP

Key field Non-key field



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

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

SELECT SINGLE *
FROM FMBDT
INTO CORRESPONDING FIELDS OF WA_FMBDT
WHERE...

How to access SAP table FMBDT

Within an ECC or HANA version of SAP you can also view further information about FMBDT 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!