SAP ABAP Table FMRPF_USFGX (FM USFG Line Item Browser)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FG (Application Component) Functions for U.S. Federal Government
     ⤷ FMFG_RPT_E (Package) US Federal Government Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	FMRPF_USFGX	Table Relationship Diagram
Short Description	FM USFG Line Item Browser

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in