SAP ABAP Table FMUSFGP (Plan line items 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	FMUSFGP	Table Relationship Diagram
Short Description	Plan line items 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	RPMAX	☐	RPMAX	RPMAX	NUMC	3	0	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	TSLVT	☐	TSLVT9	WERTV9	CURR	17	2	Balance carried forward in transaction currency
31	TSL01	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
32	TSL02	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
33	TSL03	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
34	TSL04	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
35	TSL05	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
36	TSL06	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
37	TSL07	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
38	TSL08	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
39	TSL09	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
40	TSL10	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
41	TSL11	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
42	TSL12	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
43	TSL13	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
44	TSL14	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
45	TSL15	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
46	TSL16	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
47	HSLVT	☐	HSLVT9	WERTV9	CURR	17	2	Balance carried forward in local currency
48	HSL01	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
49	HSL02	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
50	HSL03	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
51	HSL04	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
52	HSL05	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
53	HSL06	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
54	HSL07	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
55	HSL08	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
56	HSL09	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
57	HSL10	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
58	HSL11	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
59	HSL12	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
60	HSL13	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
61	HSL14	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
62	HSL15	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
63	HSL16	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
64	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
65	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
66	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
67	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
68	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
69	REFDOCNR	☐	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
70	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
71	REFDOCLN	☐	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
72	REFDOCCT	☐	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
73	REFACTIV	☐	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
74	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
75	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
76	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
77	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
78	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units

Foreign Keys

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

History

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