SAP ABAP Table FMUSFGFACTS2A (Actual line item table)

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	FMUSFGFACTS2A	Table Relationship Diagram
Short Description	Actual line item table

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	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
16	RFINUSE	☐	FM_FINUSE	FM_FINUSE	CHAR	16	0	Application of Secondary Source Funds	*
17	RFLG_APPORT	☐	FM_FLG_APPORT	FM_FLG_APPORT	CHAR	1	0	Apportionment Category
18	RFLG_AVAIL	☐	FM_FLG_AVAIL	FM_FLG_AVAIL	CHAR	1	0	Availability Time
19	RFLG_BORROW	☐	FM_FLG_BORROW	FM_FLG_BORROW	CHAR	1	0	Borrowing Source
20	RFLG_DEFINITE	☐	FM_FLG_DEFINITE	FM_FLG_DEFINITE	CHAR	1	0	Definite/Indef indicator
21	RFLG_PARTNER	☐	FM_FLG_PARTNER	FM_FLG_PARTNER	CHAR	1	0	Transaction Partner
22	RFLG_BEA	☐	FM_FLG_BEA	FM_FLG_BEA	CHAR	1	0	BEA Category
23	RLEGIS	☐	FM_LEGIS	FM_LEGIS	CHAR	1	0	Type of Legislation
24	RFLG_REIMBUR	☐	FM_FLG_REIMBUR	FM_FLG_REIMBUR	CHAR	1	0	Reimbursable
25	RCOHORT	☐	FM_COHORT	FM_COHORT	CHAR	4	0	Reporting Year for Cohort
26	RPUBLAW	☐	FM_PUBLAW	FM_PUBLAW	CHAR	20	0	Public Law Cited
27	RFLG_AUTHOR	☐	FM_FLG_AUTHOR	FM_FLG_AUTHOR	CHAR	1	0	Authority Type
28	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
29	FAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
30	BUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
31	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
32	BLSTATUS_9	☐	FMFG_BLSTATUS	FMFG_BLSTATUS	CHAR	5	0	Budgetary ledger status
33	FMFG_SUBKEY97_9	☐	FMFG_SUBKEY97	CHAR10	CHAR	10	0	Subkey for FMUSFGFACTS2T
34	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
35	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
36	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
37	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
38	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
39	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
40	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
41	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
42	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
43	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
44	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
45	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
46	REFACTIV	☐	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
47	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
48	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
49	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
50	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
51	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
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	LINETYPE	☐	LINETYPE	LINETYPE	CHAR	5	0	Item category	*
55	XSPLITMOD	☐	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
56	WSL	☐	VWCUR12	WERTV12	CURR	23	2	Value in Original Transaction Currency (Document Currency)
57	RWCUR	☐	RWCUR	WAERS	CUKY	5	0	Currency key of the original transaction currency	*
58	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
59	SGL_ACCOUNT	☐	FM_SGL_ACCOUNT	FM_SGL_ACCOUNT	CHAR	4	0	SGL Account, US Federal Government
60	RFISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
61	FMCMMTSTR_9	☐	FMCMMTSTR	FMCMMTSTR	CHAR	62	0	FM Commitment String For Budgetary Ledger
62	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
63	.INCLUDE	☐				0	0
64	TRANSFER_AGCY_9	☐	FMFG_TRANSFER_AGCY	FMFG_TRANSFER	CHAR	2	0	Transfer Agency	*
65	TRANSFER_ACCT_9	☐	FMFG_TRANSFER_ACCT	FMFG_TRAN_ACCT	CHAR	4	0	Transfer Account	*
66	YEAR_BDGT_AUTH_9	☐	FMFG_YR_BUD_AUTH	FMFG_YR_BUD_AUTH	CHAR	4	0	Year of Budget Authority
67	FLG_ADVANCE_9	☐	FM_FLG_ADVANCE	FMFG_FLG_ADVANCE	CHAR	1	0	Advanced Flag
68	DEFENSE_INDIC_9	☐	FMFG_DEFENSE_INDICATOR	FMFG_DEFENSE_INDICATOR	CHAR	3	0	Defense Indicator
69	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	FMUSFGFACTS2A	AWTYP	TTYP	AWTYP	REF	C	CN
2	FMUSFGFACTS2A	DOCTY	T889	DOCTY	REF	C	CN
3	FMUSFGFACTS2A	LOGSYS	TBDLS	LOGSYS	REF	C	CN
4	FMUSFGFACTS2A	RBUKRS	T001	BUKRS	REF	C	CN
5	FMUSFGFACTS2A	RCLNT	T000	MANDT	KEY	1	CN
6	FMUSFGFACTS2A	RLDNR	T881	RLDNR	REF	C	CN
7	FMUSFGFACTS2A	RTCUR	TCURC	WAERS	REF	C	CN
8	FMUSFGFACTS2A	RVERS	T894	RVERS	REF	C	CN

History

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