SAP ABAP Table FMGLFLEXT (General Ledger Public Sector: Total)

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	FMGLFLEXT	Table Relationship Diagram
Short Description	General Ledger Public Sector: Total

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

History

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