SAP ABAP Table FMGLFLEXP (General Ledger: Plan 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	FMGLFLEXP	Table Relationship Diagram
Short Description	General Ledger: Plan 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	DOCCT	☑	DOCCT	DOCCT	CHAR	1	0	Document Type
10	RPMAX	☑	RPMAX	RPMAX	NUMC	3	0	Period
11	.INCLUDE	☐				0	0	General ledger: Transaction attributes
12	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
13	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
14	.INCLUDE	☐				0	0	RTCUR + RUNIT
15	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
16	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
17	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
18	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Data Part of Line Items
19	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
20	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	*
21	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
22	.INCLUDE	☐				0	0	General ledger: Main account assignment
23	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
24	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
25	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt in Data Part of LIs
26	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
27	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
28	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
29	.INCLUDE	☐				0	0
30	.INCLUDE	☐				0	0
31	.INCLUDE	☐				0	0	General Ledger: Sender Additional Acct Assgmt Public Sector
32	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
33	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
34	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
35	SFUND	☐	BP_P_GEBER	BP_GEBER	CHAR	10	0	Partner Fund	*
36	SGRANT_NBR	☐	GM_GRANT_PARTNER	GM_GRANT_NBR	CHAR	20	0	Partner Grant	GMGR
37	.INCLUDE	☐				0	0	General Ledger PS: Fund, Grant and Functional Area
38	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
39	RGRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant	GMGR
40	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
41	.INCLUDE	☐				0	0	Data Fields of a GL Totals Table
42	.INCLUDE	☐				0	0	Field Group TSL
43	TSLVT	☐	TSLVT12	WERTV12	CURR	23	2	Balance carried forward in transaction currency
44	TSL01	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
45	TSL02	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
46	TSL03	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
47	TSL04	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
48	TSL05	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
49	TSL06	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
50	TSL07	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
51	TSL08	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
52	TSL09	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
53	TSL10	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
54	TSL11	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
55	TSL12	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
56	TSL13	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
57	TSL14	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
58	TSL15	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
59	TSL16	☐	TSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in transaction currency
60	.INCLUDE	☐				0	0	Field Group HSL
61	HSLVT	☐	HSLVT12	WERTV12	CURR	23	2	Balance carried forward in local currency
62	HSL01	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
63	HSL02	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
64	HSL03	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
65	HSL04	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
66	HSL05	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
67	HSL06	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
68	HSL07	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
69	HSL08	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
70	HSL09	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
71	HSL10	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
72	HSL11	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
73	HSL12	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
74	HSL13	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
75	HSL14	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
76	HSL15	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
77	HSL16	☐	HSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in local currency
78	.INCLUDE	☐				0	0	Field Group KSL
79	KSLVT	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
80	KSL01	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
81	KSL02	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
82	KSL03	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
83	KSL04	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
84	KSL05	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
85	KSL06	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
86	KSL07	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
87	KSL08	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
88	KSL09	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
89	KSL10	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
90	KSL11	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
91	KSL12	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
92	KSL13	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
93	KSL14	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
94	KSL15	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
95	KSL16	☐	KSLXX12	WERTV12	CURR	23	2	Total of transactions of the period in group currency
96	.INCLUDE	☐				0	0	Field Group OSL
97	OSLVT	☐	OSLVT12	WERTV12	CURR	23	2	Balance carried forward in fourth currency
98	OSL01	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
99	OSL02	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
100	OSL03	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
101	OSL04	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
102	OSL05	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
103	OSL06	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
104	OSL07	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
105	OSL08	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
106	OSL09	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
107	OSL10	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
108	OSL11	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
109	OSL12	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
110	OSL13	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
111	OSL14	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
112	OSL15	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
113	OSL16	☐	OSLXX12	WERTV12	CURR	23	2	Total transactions for the period in the fourth currency
114	.INCLUDE	☐				0	0	Field Group MSL
115	MSLVT	☐	MSLVT12	MENGV12	QUAN	23	3	Balance carried forward of quantity
116	MSL01	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
117	MSL02	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
118	MSL03	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
119	MSL04	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
120	MSL05	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
121	MSL06	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
122	MSL07	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
123	MSL08	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
124	MSL09	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
125	MSL10	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
126	MSL11	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
127	MSL12	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
128	MSL13	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
129	MSL14	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
130	MSL15	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
131	MSL16	☐	MSLXX12	MENGV12	QUAN	23	3	Total of the transactions of period in units of measure
132	.INCLUDE	☐				0	0	Mandatory Fields of a GL Plan Line Item Table
133	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
134	DOCTY	☐	FAGL_DOCTY	FAGL_DOCTY	CHAR	2	0	Document Type for Plan Documents in General Ledger	FAGL_T889A
135	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
136	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
137	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
138	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
139	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	USR02
140	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMGLFLEXP	ACTIV	T022	ACTIVITY
2	FMGLFLEXP	COST_ELEM	CSKB	KSTAR
3	FMGLFLEXP	DOCTY	FAGL_T889A	DOCTY
4	FMGLFLEXP	LOGSYS	TBDLS	LOGSYS
5	FMGLFLEXP	RACCT	SKB1	SAKNR
6	FMGLFLEXP	RASSC	T880	RCOMP	KEY	1	CN
7	FMGLFLEXP	RBUKRS	T001	BUKRS
8	FMGLFLEXP	RCLNT	T000	MANDT	KEY	1	CN
9	FMGLFLEXP	RFAREA	TFKB	FKBER
10	FMGLFLEXP	RGRANT_NBR	GMGR	GRANT_NBR
11	FMGLFLEXP	RLDNR	V_FAGL_T881_DBAL	RLDNR
12	FMGLFLEXP	RMVCT	T856	TRTYP
13	FMGLFLEXP	SBUSA	TGSB	GSBER	KEY	1	CN
14	FMGLFLEXP	SFAREA	TFKB	FKBER	KEY	1	CN
15	FMGLFLEXP	SGRANT_NBR	GMGR	GRANT_NBR
16	FMGLFLEXP	USNAM	USR02	BNAME

History

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