SAP ABAP Table FMUSFGT (Summary 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	FMUSFGT	Table Relationship Diagram
Short Description	Summary 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	RLDNR	☑	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
3	RRCTY	☑	RRCTY	RRCTY	CHAR	1	0	Record Type
4	RVERS	☑	RVERS	RVERS	CHAR	3	0	Version	T894
5	RYEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	ROBJNR	☑	GOBJNR_R	OBJNR	CHAR	18	0	Object number for objects (account assignment elements)
7	COBJNR	☑	GOBJNR_C	OBJNR	CHAR	18	0	Object number for transaction attributes
8	SOBJNR	☑	GOBJNR_S	OBJNR	CHAR	18	0	Object number for partner objects (accnt assignmnt elements)
9	RTCUR	☑	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
10	DRCRK	☑	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
11	RPMAX	☑	RPMAX	RPMAX	NUMC	3	0	Period
12	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
14	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
15	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
16	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
17	RPROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
18	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
19	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
20	RFIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
21	RFISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
22	RORDNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
23	RVBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
24	RAGNCY_LCTN_CODE	☐	FMFG_ALC	FMFG_ALC	CHAR	8	0	Agency Location Code	*
25	RFINUSE	☐	FM_FINUSE	FM_FINUSE	CHAR	16	0	Application of Secondary Source Funds	*
26	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
27	FMFG_SUBKEY_9	☐	FMFG_SUBKEY	CHAR10	CHAR	10	0	Subkey for FMUSFGT
28	BLSTATUS_9	☐	FMFG_BLSTATUS	FMFG_BLSTATUS	CHAR	5	0	Budgetary ledger status
29	TSLVT	☐	TSLVT9	WERTV9	CURR	17	2	Balance carried forward in transaction currency
30	TSL01	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
31	TSL02	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
32	TSL03	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
33	TSL04	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
34	TSL05	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
35	TSL06	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
36	TSL07	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
37	TSL08	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
38	TSL09	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
39	TSL10	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
40	TSL11	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
41	TSL12	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
42	TSL13	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
43	TSL14	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
44	TSL15	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
45	TSL16	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
46	HSLVT	☐	HSLVT9	WERTV9	CURR	17	2	Balance carried forward in local currency
47	HSL01	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
48	HSL02	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
49	HSL03	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
50	HSL04	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
51	HSL05	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
52	HSL06	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
53	HSL07	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
54	HSL08	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
55	HSL09	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
56	HSL10	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
57	HSL11	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
58	HSL12	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
59	HSL13	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
60	HSL14	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
61	HSL15	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
62	HSL16	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
63	CSPRED	☐	CSPRED	SPRED	CHAR	4	0	Distribution key for currency amounts	T821S
64	FUND_TYPE	☐	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	*
65	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
66	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
67	SGL_ACCOUNT	☐	FM_SGL_ACCOUNT	FM_SGL_ACCOUNT	CHAR	4	0	SGL Account, US Federal Government
68	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	FMMEASURE

Foreign Keys

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

History

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