SAP FMGLFLEXA General Ledger: Actual Line Items Table data and field list

FMGLFLEXA is a standard SAP Table which is used to store General Ledger: Actual Line Items data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMGLFLEXA table consists of various fields, each holding specific information or linking keys about General Ledger: Actual Line Items data available in SAP. These include RYEAR (Fiscal Year), DOCNR (Accounting Document Number), RLDNR (Ledger in General Ledger Accounting), RBUKRS (Company Code)... 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. .

FMGLFLEXA 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: Can be enhanced (character-type or numeric)

SAP FMGLFLEXA 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 FMGLFLEXA 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
RYEAR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
DOCNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
RLDNR	Ledger in General Ledger Accounting	FAGL_RLDNR	CHAR	2	V_FAGL_T881_DBAL	ALPHA	RLDNR	GLN_FLEX	FAGL_RLDNR
RBUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
DOCLN	Six-Character Posting Item for Ledger	DOCLN6	CHAR	6			DOCLN6
ACTIV	FI-SL Business Transaction	ACTI1	CHAR	4	T022		ACTIVITY
RMVCT	Transaction Type	RMVCT	CHAR	3	T856		RMVCT
RTCUR	Currency Key	RTCUR	CUKY	5	Assigned to domain		WAERS	FWS
RUNIT	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
AWTYP	Reference Transaction	AWTYP	CHAR	5	TTYP		AWTYP
RRCTY	Record Type	RRCTY	CHAR	1			RRCTY
RVERS	Version	RVERS	CHAR	3	Assigned to domain	ALPHA	RVERS	GVS
LOGSYS	Logical system	LOGSYS	CHAR	10	TBDLS	ALPHA	LOGSYS
RACCT	Account Number	RACCT	CHAR	10	SKB1	ALPHA	SAKNR	ACC
COST_ELEM	Cost Element	KSTAR	CHAR	10	CSKB	ALPHA	KSTAR	KAT
RBUSA	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
KOKRS	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
FIKRS	Financial Management Area	FIKRS	CHAR	4	Assigned to domain		FIKRS	FIK
SFAREA	Partner Functional Area	SFKBER	CHAR	16	TFKB		FKBER
SBUSA	Trading partner's business area	PARGB	CHAR	4	TGSB		GSBER	GSB
RASSC	Company ID of trading partner	RASSC	CHAR	6	T880	ALPHA	RCOMP	PGS
SFUND	Partner Fund	BP_P_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
SGRANT_NBR	Partner Grant	GM_GRANT_PARTNER	CHAR	20	GMGR	ALPHA	GM_GRANT_NBR		GRANTS_GENERIC
RFUND	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
RGRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20	GMGR	ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
RFAREA	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
TSL	Value in Transaction Currency	VTCUR12	CURR	23(2)			WERTV12
HSL	Value in Local Currency	VLCUR12	CURR	23(2)			WERTV12
KSL	Value in Group Currency	VGCUR12	CURR	23(2)			WERTV12
OSL	Value in Another Currency	VOCUR12	CURR	23(2)			WERTV12
MSL	Quantity	QUAN1_12	QUAN	23(3)			MENGV12
WSL	Value in Original Transaction Currency (Document Currency)	VWCUR12	CURR	23(2)			WERTV12
DRCRK	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
POPER	Posting period	POPER	NUMC	3			POPER	POPR
RWCUR	Currency key of the original transaction currency	RWCUR	CUKY	5	TCURC		WAERS	FWS
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
BSCHL	Posting Key	BSCHL	CHAR	2	TBSL		BSCHL
BSTAT	Document Status	BSTAT_D	CHAR	1			BSTAT
LINETYPE	Item category	LINETYPE	CHAR	5	T8G02		LINETYPE
XSPLITMOD	Item changed by document splitting	XSPLITMOD	CHAR	1			XFELD
USNAM	User name	USNAM	CHAR	12	USR02		XUBNAME	USR
TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS

Key field

Non-key field

< FMGLFLEX08 - General Ledger: Reserve Table 2 FMGLFLEXA_FS - General Ledger Line Items >

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

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

SELECT SINGLE *
FROM FMGLFLEXA
INTO CORRESPONDING FIELDS OF WA_FMGLFLEXA
WHERE...

How to access SAP table FMGLFLEXA

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

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