SAP ABAP Table FMGLFLEXA (General Ledger: Actual Line Items)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FA (Application Component) Fund Accounting
     ⤷ FMGL (Package) New General Ledger for Public Sector

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FMGLFLEXA	Table Relationship Diagram
Short Description	General Ledger: Actual Line Items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	RCLNT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RYEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
3	DOCNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	.INCLUDE	☑				0	0	General Ledger: Technical Fields in Key of Line Items
5	RLDNR	☑	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	V_FAGL_T881_DBAL
6	.INCLUDE	☑				0	0	General Ledger: Additional Acct Assignmt (SAP) in Key of LIs
7	RBUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	DOCLN	☑	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
9	.INCLUDE	☐				0	0	General ledger: Transaction attributes
10	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
11	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
12	.INCLUDE	☐				0	0	RTCUR + RUNIT
13	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
14	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
15	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
16	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Data Part of Line Items
17	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
18	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	*
19	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
20	.INCLUDE	☐				0	0	General ledger: Main account assignment
21	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
22	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
23	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt in Data Part of LIs
24	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
25	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
26	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
27	.INCLUDE	☐				0	0
28	.INCLUDE	☐				0	0
29	.INCLUDE	☐				0	0	General Ledger: Sender Additional Acct Assgmt Public Sector
30	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
31	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
32	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
33	SFUND	☐	BP_P_GEBER	BP_GEBER	CHAR	10	0	Partner Fund	*
34	SGRANT_NBR	☐	GM_GRANT_PARTNER	GM_GRANT_NBR	CHAR	20	0	Partner Grant	GMGR
35	.INCLUDE	☐				0	0	General Ledger PS: Fund, Grant and Functional Area
36	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
37	RGRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant	GMGR
38	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
39	.INCLUDE	☐				0	0	Value Fields of GL Line Items Table
40	TSL	☐	VTCUR12	WERTV12	CURR	23	2	Value in Transaction Currency
41	HSL	☐	VLCUR12	WERTV12	CURR	23	2	Value in Local Currency
42	KSL	☐	VGCUR12	WERTV12	CURR	23	2	Value in Group Currency
43	OSL	☐	VOCUR12	WERTV12	CURR	23	2	Value in Another Currency
44	MSL	☐	QUAN1_12	MENGV12	QUAN	23	3	Quantity
45	WSL	☐	VWCUR12	WERTV12	CURR	23	2	Value in Original Transaction Currency (Document Currency)
46	.INCLUDE	☐				0	0	Mandatory Fields of a GL Actual Line Item Table
47	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
48	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
49	RWCUR	☐	RWCUR	WAERS	CUKY	5	0	Currency key of the original transaction currency	TCURC
50	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
51	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
52	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
53	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
54	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
55	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
56	LINETYPE	☐	LINETYPE	LINETYPE	CHAR	5	0	Item category	T8G02
57	XSPLITMOD	☐	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
58	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	USR02
59	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
60	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMGLFLEXA	ACTIV	T022	ACTIVITY
2	FMGLFLEXA	AWTYP	TTYP	AWTYP
3	FMGLFLEXA	BSCHL	TBSL	BSCHL
4	FMGLFLEXA	COST_ELEM	CSKB	KSTAR
5	FMGLFLEXA	KOKRS	TKA01	KOKRS
6	FMGLFLEXA	LINETYPE	T8G02	LINETYPE
7	FMGLFLEXA	LOGSYS	TBDLS	LOGSYS
8	FMGLFLEXA	RACCT	SKB1	SAKNR
9	FMGLFLEXA	RASSC	T880	RCOMP	KEY	1	CN
10	FMGLFLEXA	RBUKRS	T001	BUKRS
11	FMGLFLEXA	RBUSA	TGSB	GSBER
12	FMGLFLEXA	RCLNT	T000	MANDT	KEY	1	CN
13	FMGLFLEXA	RFAREA	TFKB	FKBER
14	FMGLFLEXA	RGRANT_NBR	GMGR	GRANT_NBR
15	FMGLFLEXA	RLDNR	V_FAGL_T881_DBAL	RLDNR
16	FMGLFLEXA	RMVCT	T856	TRTYP
17	FMGLFLEXA	RWCUR	TCURC	WAERS
18	FMGLFLEXA	SBUSA	TGSB	GSBER	KEY	1	CN
19	FMGLFLEXA	SFAREA	TFKB	FKBER	KEY	1	CN
20	FMGLFLEXA	SGRANT_NBR	GMGR	GRANT_NBR
21	FMGLFLEXA	USNAM	USR02	BNAME

History

Last changed by/on	SAP	20130529
SAP Release Created in	600