SAP FMBDO Object table 1 - Budget address Table data and field list

FMBDO is a standard SAP Table which is used to store Object table 1 - Budget address data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMBDO table consists of various fields, each holding specific information or linking keys about Object table 1 - Budget address data available in SAP. These include OBJNR (Object number for FI-SL tables), DATIV (Posting date frm which the objct is valid for act.postings), DATIB (Posting date up to which the object is valid for act.postngs), DATPV (Posting date frm which the objct is valid for plan postings)... 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. .

FMBDO table Technical Details:

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 FMBDO table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FMBDO table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
OBJNR	Object number for FI-SL tables	GOBJNR	CHAR	18			OBJNR
DATIV	Posting date frm which the objct is valid for act.postings	DAT_0_VON	DATS	8			DATUM
DATIB	Posting date up to which the object is valid for act.postngs	DAT_0_BIS	DATS	8			DATUM
DATPV	Posting date frm which the objct is valid for plan postings	DAT_1_VON	DATS	8			DATUM
DATPB	Posting date up to which the objct is valid for plan postngs	DAT_1_BIS	DATS	8			DATUM
FIKRS	Financial Management Area	FIKRS	CHAR	4	Assigned to domain		FIKRS	FIK
FUND	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
FUNDSCTR	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
CMMTITEM	Commitment Item	FM_FIPEX	CHAR	24	Assigned to domain		FM_FIPEX	FPS
FUNCAREA	Functional Area	FM_FAREA	CHAR	16	Assigned to domain		FKBER	FBE
USERDIM	Customer Field for FM Actual and Commitment Data	FM_USERDIM	CHAR	10			CHAR10
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20	GMGR	ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
MEASURE	Funded Program	FM_MEASURE	CHAR	24	Assigned to domain		FM_MEASURE	FM_MEASURE

Key field

Non-key field

< FMBDC - Object table 2 FMBDP - FM Budget change line items table >

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

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

SELECT SINGLE *
FROM FMBDO
INTO CORRESPONDING FIELDS OF WA_FMBDO
WHERE...

How to access SAP table FMBDO

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

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