SAP ABAP Table FMUSFGFACTS1A (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	FMUSFGFACTS1A	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_COVERED	☐	FM_FLG_COVERED	FM_FLG_COVERED	CHAR	1	0	Covered Indicator
18	RFLG_CUSTODIAL	☐	FM_FLG_CUSTODIAL	FM_FLG_CUSTODIAL	CHAR	1	0	Custodial Indicator
19	RFLG_ENTITY	☐	FM_FLG_ENTITY	FM_FLG_ENTITY	CHAR	1	0	Entity Indicator
20	RFLG_EXCHANGE	☐	FM_FLG_EXCHANGE	FM_FLG_EXCHANGE	CHAR	1	0	Exchange Indicator
21	RVBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
22	RFLG_PARTNER	☐	FM_FLG_PARTNER	FM_FLG_PARTNER	CHAR	1	0	Transaction Partner
23	RBDGT_FUNC_CLSS	☐	FM_BDGT_FUNC_CLSS	CHAR3	CHAR	3	0	Classification of Data According to Major Purpose
24	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
25	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
26	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
27	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
28	FMFG_SUBKEY96_9	☐	FMFG_SUBKEY96	CHAR10	CHAR	10	0	Subkey for FMUSFGFACTS1T
29	SBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
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	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
49	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
50	LINETYPE	☐	LINETYPE	LINETYPE	CHAR	5	0	Item category	*
51	XSPLITMOD	☐	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
52	WSL	☐	VWCUR12	WERTV12	CURR	23	2	Value in Original Transaction Currency (Document Currency)
53	RWCUR	☐	RWCUR	WAERS	CUKY	5	0	Currency key of the original transaction currency	*
54	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
55	BUREAU	☐	FM_BUREAU	FM_BUREAU	CHAR	2	0	Federal Bureau
56	BUSINESS_LINE	☐	FM_BUSINESS_LINE	FM_BUSINESS_LINE	CHAR	2	0	Business Line
57	FGDPRTMNT	☐	FM_DEPARTMENT	FM_DEPARTMENT	CHAR	2	0	Federal Department
58	FGDPRTMNT_PART	☐	FM_DEPARTMENT_PARTNER	FM_DEPARTMENT	CHAR	2	0	Federal Department Partner
59	FUND_ACC_SYMBL	☐	FM_MAIN_ACCT	FM_MAIN_ACCT	CHAR	4	0	Treasury Account Symbol - Main Account
60	SGL_ACCOUNT	☐	FM_SGL_ACCOUNT	FM_SGL_ACCOUNT	CHAR	4	0	SGL Account, US Federal Government
61	FLG_FEDERAL	☐	FM_FLG_FEDERAL	FM_FLG_FEDERAL	CHAR	1	0	Federal Indicator
62	FMCMMTSTR_9	☐	FMCMMTSTR	FMCMMTSTR	CHAR	62	0	FM Commitment String For Budgetary Ledger
63	RFISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
64	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
65	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMUSFGFACTS1A	AWTYP	TTYP	AWTYP	REF	C	CN
2	FMUSFGFACTS1A	DOCTY	T889	DOCTY	REF	C	CN
3	FMUSFGFACTS1A	LOGSYS	TBDLS	LOGSYS	REF	C	CN
4	FMUSFGFACTS1A	RBUKRS	T001	BUKRS	REF	C	CN
5	FMUSFGFACTS1A	RCLNT	T000	MANDT	KEY	1	CN
6	FMUSFGFACTS1A	RLDNR	T881	RLDNR	REF	C	CN
7	FMUSFGFACTS1A	RTCUR	TCURC	WAERS	REF	C	CN
8	FMUSFGFACTS1A	RVERS	T894	RVERS	REF	C	CN
9	FMUSFGFACTS1A	SBUKRS	T001	BUKRS	REF	C	CN

History

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