SAP ABAP Table FMUSFGA (Actual line item table for US Federal Government)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM (Application Component) Funds Management
     ⤷ FMFG_E (Package) US Federal Government budgetary ledger account derivation

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FMUSFGA	Table Relationship Diagram
Short Description	Actual line item table for US Federal Government

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMUSFGA	AWTYP	TTYP	AWTYP	REF	C	CN
2	FMUSFGA	DOCTY	T889	DOCTY	REF	C	CN
3	FMUSFGA	LOGSYS	TBDLS	LOGSYS	REF	C	CN
4	FMUSFGA	MEASURE	FMMEASURE	MEASURE	REF	C	CN
5	FMUSFGA	RBUKRS	T001	BUKRS	REF	C	CN
6	FMUSFGA	RBUSA	TGSB	GSBER	REF	C	CN
7	FMUSFGA	RCLNT	T000	MANDT	KEY	1	CN
8	FMUSFGA	RFAREA	TFKB	FKBER	REF	C	CN
9	FMUSFGA	RLDNR	T881	RLDNR	REF	C	CN
10	FMUSFGA	RPROJK	PRPS	PSPNR	REF	C	CN
11	FMUSFGA	RTCUR	TCURC	WAERS	REF	C	CN
12	FMUSFGA	RVERS	T894	RVERS	REF	C	CN

History

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