SAP FMBDA Actual line item table Table data and field list

FMBDA is a standard SAP Table which is used to store Actual line item table data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMBDA table consists of various fields, each holding specific information or linking keys about Actual line item table data available in SAP. These include GL_SIRID (Record number of the line item record), RLDNR (Ledger), RRCTY (Record Type), RVERS (Version)... 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. .

FMBDA 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 FMBDA 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 FMBDA 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
RCLNT	Client	MANDT	CLNT	3	T000		MANDT
GL_SIRID	Record number of the line item record	GU_RECID	CHAR	18			OBJNR	OBN
RLDNR	Ledger	RLDNR	CHAR	2	T881	ALPHA	RLDNR	GLN	H_T881
RRCTY	Record Type	RRCTY	CHAR	1			RRCTY
RVERS	Version	VERSN	CHAR	3	TKVS	ALPHA	COVERSI	KVS
RYEAR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
RTCUR	Currency Key	RTCUR	CUKY	5	TCURC		WAERS	FWS
DRCRK	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
POPER	Posting period	POPER	NUMC	3			POPER	POPR
DOCCT	Document Type	DOCCT	CHAR	1			DOCCT	GCT
DOCNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
DOCLN	Six-Character Posting Item for Ledger	DOCLN6	CHAR	6			DOCLN6
RFIKRS	Financial Management Area	FIKRS	CHAR	4	FM01		FIKRS	FIK
RFUND	Fund	FM_FUND	CHAR	10	FMFINCODE		BP_GEBER	FIC
RFUNDSCTR	Funds Center	FISTL	CHAR	16	FMFCTR		FISTL	FIS
RCMMTITEM	Commitment Item	FM_FIPEX	CHAR	24	FMCI		FM_FIPEX	FPS
RFUNCAREA	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
RUSERDIM	Customer Field for FM Actual and Commitment Data	FM_USERDIM	CHAR	10			CHAR10
RGRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20	GMGR	ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
RMEASURE	Funded Program	FM_MEASURE	CHAR	24	FMMEASURE		FM_MEASURE	FM_MEASURE
BUDGET_PD_9	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
CEFFYEAR_9	Year of Cash Effectivity	GNJHR	NUMC	4		GJAHR	GJAHR	GNJHR
VALTYPE_9	BCS Value Type	BUKU_VALTYPE	CHAR	2	BUVALTYPE		BUKU_VALTYPE
WFSTATE_9	Workflow Status of a Record in the Budget Totals Table	BUKU_WFSTATE	CHAR	1			BUKU_WFSTATE
PROCESS_9	Internal Budgeting Process	BUKU_PROCESS	CHAR	4	BUPROCESS		BUKU_PROCESS
BUDTYPE_9	Budget Type	BUKU_BUDTYPE	CHAR	4			CHAR4	BUTY
LOGSYS	Logical system	LOGSYS	CHAR	10	TBDLS	ALPHA	LOGSYS
TSL	Value in Transaction Currency	VTCUR9	CURR	17(2)			WERTV9
HSL	Value in local currency	VLCUR9	CURR	17(2)			WERTV9
KSL	Value in group currency	VGCUR9	CURR	17(2)			WERTV9
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
DOCTY	FI-SL Document Type	DOCTY	CHAR	2	T889		DOCTY	BAR
ACTIV	Business Transaction	GLVOR	CHAR	4			CHAR4
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
WSDAT	Value Date for Currency Translation	WSDAT	DATS	8			DATUM	WSD
REFDOCNR	Reference document number of an accounting document	REFBELNR	CHAR	10		ALPHA	BELNR	BLN
REFRYEAR	Reference fiscal year	REFGJAHR	NUMC	4		GJAHR	GJAHR	GJR
REFDOCLN	Six-digit number of the reference posting line	REFBUZEI6	NUMC	6			BUZEI6	BUZ
REFDOCCT	Reference document category	REFDOCCT	CHAR	1			DOCCT	GCT
REFACTIV	FI-SL Business Reference Transaction	REFGLVOR	CHAR	4			CHAR4
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
CPUTM	Time of Entry	CPUTM	TIMS	6			UZEIT
USNAM	User name	USNAM	CHAR	12	Assigned to domain		XUBNAME	USR
AWTYP	Reference Transaction	AWTYP	CHAR	5	TTYP		AWTYP
AWORG	Reference Organizational Units	AWORG	CHAR	10			AWORG
CTEM_CATEGORY_9	Commitment Item Category	FM_POTYP	NUMC	1			FM_POTYP
TECHORG_9	Original Application	BUKU_TECHORG	CHAR	10	Assigned to domain		BUKU_TECHORG

Key field

Non-key field

< FMBCS_S_LINES_STD - Standard fields for FMBL (non-key fields contained in FMBL) FMBDC - Object table 2 >

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

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

SELECT SINGLE *
FROM FMBDA
INTO CORRESPONDING FIELDS OF WA_FMBDA
WHERE...

How to access SAP table FMBDA

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

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