SAP FMRBA Actual line item table Table data and field list

FMRBA 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 FMRBA 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. .

FMRBA 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 FMRBA 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 FMRBA 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	RVERS	CHAR	3	T894	ALPHA	RVERS	GVS
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	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
RFUNDSCTR	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
RCMMTITEM	Commitment Item	FM_FIPEX	CHAR	24	Assigned to domain		FM_FIPEX	FPS
RFUNCAREA	Functional Area	FM_FAREA	CHAR	16	Assigned to domain		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	Assigned to domain		FM_MEASURE	FM_MEASURE
RCVRGRP_9	Cover Group	FMCE_CVRGRP	CHAR	16	Assigned to domain		FMCE_CVRGRP
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
RIBPROC_9	RIB Process	BURB_PROCESS	CHAR	4			BURB_PROCESS
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

Key field

Non-key field

< FMR01 - Funds Management Information System FMRBACT - RIB Customizing Settings >

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

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

SELECT SINGLE *
FROM FMRBA
INTO CORRESPONDING FIELDS OF WA_FMRBA
WHERE...

How to access SAP table FMRBA

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

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