SAP ABAP Table FMFGGLU1 (All fields of US-Federal ledgers 95, 96 and 97)

Hierarchy

☛

EA-PS (Software Component) SAP Enterprise Extension Public Services
⤷

PSM-FG (Application Component) Functions for U.S. Federal Government
⤷

FMFG_BLEXT_E (Package) US Federal Government Extention of the Budgetary Ledger

Basic Data

Table Category	INTTAB	Structure
Structure	FMFGGLU1	Table Relationship Diagram
Short Description	All fields of US-Federal ledgers 95, 96 and 97

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ACTIV	GLVOR	CHAR4	CHAR	4	0	Business Transaction
2	AWID	AWID	AWID	CHAR	10	0	Reference document: Current identification
3	AWORG	AWORG	AWORG	CHAR	10	0	Reference organisational units
4	AWTYP	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
5	BDGT_FUNC_CLSS	FM_BDGT_FUNC_CLSS	CHAR3	CHAR	3	0	Classification of Data According to Major Purpose
6	BELNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
7	BLDAT	BLDAT	DATUM	DATS	8	0	Document Date in Document
8	BLSTATUS_9	FMFG_BLSTATUS	FMFG_BLSTATUS	CHAR	5	0	Budgetary ledger status
9	BUDAT	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
10	BUREAU	FM_BUREAU	FM_BUREAU	CHAR	2	0	Federal Bureau
11	BUSA	GSBER	GSBER	CHAR	4	0	Business Area	*
12	BUSINESS_LINE	FM_BUSINESS_LINE	FM_BUSINESS_LINE	CHAR	2	0	Business Line
13	BUZEI	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
14	COHORT	FM_COHORT	FM_COHORT	CHAR	4	0	Reporting Year for Cohort
15	CO_AREA	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
16	CPUDT	CPUDT	DATUM	DATS	8	0	Accounting document entry date
17	CPUTM	CPUTM	UZEIT	TIMS	6	0	Time of data entry
18	DEFENSE_INDIC_9	FMFG_DEFENSE_INDICATOR	FMFG_DEFENSE_INDICATOR	CHAR	3	0	Defense Indicator
19	DOCCT	DOCCT	DOCCT	CHAR	1	0	Document Type
20	DOCLN	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
21	DOCNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
22	DOCTY	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	*
23	DRCRK	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
24	FAREA	FKBER	FKBER	CHAR	16	0	Functional Area	*
25	FGDPRTMNT	FM_DEPARTMENT	FM_DEPARTMENT	CHAR	2	0	Federal Department
26	FGDPRTMNT_PART	FM_DEPARTMENT_PARTNER	FM_DEPARTMENT	CHAR	2	0	Federal Department Partner
27	FLG_ADVANCE_9	FM_FLG_ADVANCE	FMFG_FLG_ADVANCE	CHAR	1	0	Advanced Flag
28	FLG_APPORT	FM_FLG_APPORT	FM_FLG_APPORT	CHAR	1	0	Apportionment Category
29	FLG_AUTHOR	FM_FLG_AUTHOR	FM_FLG_AUTHOR	CHAR	1	0	Authority Type
30	FLG_AVAIL	FM_FLG_AVAIL	FM_FLG_AVAIL	CHAR	1	0	Availability Time
31	FLG_BEA	FM_FLG_BEA	FM_FLG_BEA	CHAR	1	0	BEA Category
32	FLG_BORROW	FM_FLG_BORROW	FM_FLG_BORROW	CHAR	1	0	Borrowing Source
33	FLG_COVERED	FM_FLG_COVERED	FM_FLG_COVERED	CHAR	1	0	Covered Indicator
34	FLG_CUSTODIAL	FM_FLG_CUSTODIAL	FM_FLG_CUSTODIAL	CHAR	1	0	Custodial Indicator
35	FLG_DEFINITE	FM_FLG_DEFINITE	FM_FLG_DEFINITE	CHAR	1	0	Definite/Indef indicator
36	FLG_ENTITY	FM_FLG_ENTITY	FM_FLG_ENTITY	CHAR	1	0	Entity Indicator
37	FLG_EXCHANGE	FM_FLG_EXCHANGE	FM_FLG_EXCHANGE	CHAR	1	0	Exchange Indicator
38	FLG_FEDERAL	FM_FLG_FEDERAL	FM_FLG_FEDERAL	CHAR	1	0	Federal Indicator
39	FLG_PARTNER	FM_FLG_PARTNER	FM_FLG_PARTNER	CHAR	1	0	Transaction Partner
40	FLG_REIMBUR	FM_FLG_REIMBUR	FM_FLG_REIMBUR	CHAR	1	0	Reimbursable
41	FMCMMTSTR_9	FMCMMTSTR	FMCMMTSTR	CHAR	62	0	FM Commitment String For Budgetary Ledger
42	FMFG_SUBKEY96_9	FMFG_SUBKEY96	CHAR10	CHAR	10	0	Subkey for FMUSFGFACTS1T
43	FMFG_SUBKEY97_9	FMFG_SUBKEY97	CHAR10	CHAR	10	0	Subkey for FMUSFGFACTS2T
44	FMFG_SUBKEY_9	FMFG_SUBKEY	CHAR10	CHAR	10	0	Subkey for FMUSFGT
45	FM_AREA	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
46	FUND_ACC_SYMBL	FM_MAIN_ACCT	FM_MAIN_ACCT	CHAR	4	0	Treasury Account Symbol - Main Account
47	FUND_TYPE	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	*
48	GL_SIRID	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
49	HSL	VLCUR9	WERTV9	CURR	17	2	Value in local currency
50	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
51	LEGIS	FM_LEGIS	FM_LEGIS	CHAR	1	0	Type of Legislation
52	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
53	LINETYPE	LINETYPE	LINETYPE	CHAR	5	0	Item category	*
54	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
55	MEASURE	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
56	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
57	PMT_OFFICE	FMFG_PMT_OFF	FMFG_PMT_OFF	CHAR	5	0	Payment Office	*
58	POPER	POPER	POPER	NUMC	3	0	Posting period
59	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
60	PUBLAW	FM_PUBLAW	FM_PUBLAW	CHAR	20	0	Public Law Cited
61	RACCT	RACCT	SAKNR	CHAR	10	0	Account Number	*
62	RAGNCY_LCTN_CODE	FMFG_ALC	FMFG_ALC	CHAR	8	0	Agency Location Code	*
63	RBDGT_FUNC_CLSS	FM_BDGT_FUNC_CLSS	CHAR3	CHAR	3	0	Classification of Data According to Major Purpose
64	RBUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
65	RBUSA	GSBER	GSBER	CHAR	4	0	Business Area	*
66	RCLNT	MANDT	MANDT	CLNT	3	0	Client	*
67	RCNTR	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
68	RCOHORT	FM_COHORT	FM_COHORT	CHAR	4	0	Reporting Year for Cohort
69	REFACTIV	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
70	REFDOCCT	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
71	REFDOCLN	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
72	REFDOCNR	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
73	REFRYEAR	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
74	RFAREA	FKBER	FKBER	CHAR	16	0	Functional Area	*
75	RFINUSE	FM_FINUSE	FM_FINUSE	CHAR	16	0	Application of Secondary Source Funds	*
76	RFIPEX	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
77	RFISTL	FISTL	FISTL	CHAR	16	0	Funds Center	*
78	RFLG_APPORT	FM_FLG_APPORT	FM_FLG_APPORT	CHAR	1	0	Apportionment Category
79	RFLG_AUTHOR	FM_FLG_AUTHOR	FM_FLG_AUTHOR	CHAR	1	0	Authority Type
80	RFLG_AVAIL	FM_FLG_AVAIL	FM_FLG_AVAIL	CHAR	1	0	Availability Time
81	RFLG_BEA	FM_FLG_BEA	FM_FLG_BEA	CHAR	1	0	BEA Category
82	RFLG_BORROW	FM_FLG_BORROW	FM_FLG_BORROW	CHAR	1	0	Borrowing Source
83	RFLG_COVERED	FM_FLG_COVERED	FM_FLG_COVERED	CHAR	1	0	Covered Indicator
84	RFLG_CUSTODIAL	FM_FLG_CUSTODIAL	FM_FLG_CUSTODIAL	CHAR	1	0	Custodial Indicator
85	RFLG_DEFINITE	FM_FLG_DEFINITE	FM_FLG_DEFINITE	CHAR	1	0	Definite/Indef indicator
86	RFLG_ENTITY	FM_FLG_ENTITY	FM_FLG_ENTITY	CHAR	1	0	Entity Indicator
87	RFLG_EXCHANGE	FM_FLG_EXCHANGE	FM_FLG_EXCHANGE	CHAR	1	0	Exchange Indicator
88	RFLG_PARTNER	FM_FLG_PARTNER	FM_FLG_PARTNER	CHAR	1	0	Transaction Partner
89	RFLG_REIMBUR	FM_FLG_REIMBUR	FM_FLG_REIMBUR	CHAR	1	0	Reimbursable
90	RFUND	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
91	RLDNR	RLDNR	RLDNR	CHAR	2	0	Ledger	*
92	RLEGIS	FM_LEGIS	FM_LEGIS	CHAR	1	0	Type of Legislation
93	RORDNR	AUFNR	AUFNR	CHAR	12	0	Order Number	*
94	RPRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
95	RPROJK	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
96	RPUBLAW	FM_PUBLAW	FM_PUBLAW	CHAR	20	0	Public Law Cited
97	RRCTY	RRCTY	RRCTY	CHAR	1	0	Record Type
98	RTCUR	RTCUR	WAERS	CUKY	5	0	Currency Key	*
99	RVBUND	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
100	RVERS	RVERS	RVERS	CHAR	3	0	Version	*
101	RWCUR	RWCUR	WAERS	CUKY	5	0	Currency key of the original transaction currency	*
102	RYEAR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
103	SBUKRS	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	*
104	SGL_ACCOUNT	FM_SGL_ACCOUNT	FM_SGL_ACCOUNT	CHAR	4	0	SGL Account, US Federal Government
105	SGTXT	SGTXT	TEXT50	CHAR	50	0	Item Text
106	TRANSFER_ACCT_9	FMFG_TRANSFER_ACCT	FMFG_TRAN_ACCT	CHAR	4	0	Transfer Account	*
107	TRANSFER_AGCY_9	FMFG_TRANSFER_AGCY	FMFG_TRANSFER	CHAR	2	0	Transfer Agency	*
108	TSL	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
109	USNAM	USNAM	XUBNAME	CHAR	12	0	User name	*
110	WSDAT	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
111	WSL	VWCUR12	WERTV12	CURR	23	2	Value in Original Transaction Currency (Document Currency)
112	XBLNR	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
113	XSKRL	XSKRL	XFELD	CHAR	1	0	Indicator: Line item not liable to cash discount?
114	XSPLITMOD	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
115	YEAR_BDGT_AUTH_9	FMFG_YR_BUD_AUTH	FMFG_YR_BUD_AUTH	CHAR	4	0	Year of Budget Authority
116	PROG_REPT_CAT_9	FMFG_PROGRAM_REPORT_CATEGORY	FMFG_PROGRAM_REPORT_CATEGORY	CHAR	3	0	Program Reporting Category Posted
117	.INCLUDE				0	0