SAP ABAP Table FMUSFGW_ITEMS (FMFG line item extractor)

Hierarchy

☛

EA-PS (Software Component) SAP Enterprise Extension Public Services
⤷

PSM-FG (Application Component) Functions for U.S. Federal Government
⤷

FMFG_BW_E (Package) US Federal Governement business Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	FMUSFGW_ITEMS	Table Relationship Diagram
Short Description	FMFG line item extractor

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Generated Extract Structure for Table FMUSFGA
2	RVERS	RVERS	RVERS	CHAR	3	0	Version	*
3	RYEAR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	RTCUR	RTCUR	WAERS	CUKY	5	0	Currency Key	*
5	POPER	POPER	POPER	NUMC	3	0	Posting period
6	DOCCT	DOCCT	DOCCT	CHAR	1	0	Document Type
7	DOCNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
8	DOCLN	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
9	RBUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
10	RACCT	RACCT	SAKNR	CHAR	10	0	Account Number	*
11	RBUSA	GSBER	GSBER	CHAR	4	0	Business Area	*
12	RPRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
13	RCNTR	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
14	RPROJK	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
15	RFAREA	FKBER	FKBER	CHAR	16	0	Functional Area	*
16	RFUND	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
17	RFIPEX	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
18	RFISTL	FISTL	FISTL	CHAR	16	0	Funds Center	*
19	RORDNR	AUFNR	AUFNR	CHAR	12	0	Order Number	*
20	RVBUND	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
21	RAGNCY_LCTN_CODE	FMFG_ALC	FMFG_ALC	CHAR	8	0	Agency Location Code	*
22	RFINUSE	FM_FINUSE	FM_FINUSE	CHAR	16	0	Application of Secondary Source Funds	*
23	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
24	FMFG_SUBKEY_9	FMFG_SUBKEY	CHAR10	CHAR	10	0	Subkey for FMUSFGT
25	BLSTATUS_9	FMFG_BLSTATUS	FMFG_BLSTATUS	CHAR	5	0	Budgetary ledger status
26	SGTXT	SGTXT	TEXT50	CHAR	50	0	Item Text
27	DOCTY	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	*
28	ACTIV	GLVOR	CHAR4	CHAR	4	0	Business Transaction
29	BUDAT	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
30	WSDAT	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
31	BLDAT	BLDAT	DATUM	DATS	8	0	Document Date in Document
32	REFDOCNR	REFBELNR	BELNR	CHAR	10	0	Reference document number of an accounting document
33	REFRYEAR	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
34	REFDOCLN	REFBUZEI6	BUZEI6	NUMC	6	0	Six-digit number of the reference posting line
35	REFDOCCT	REFDOCCT	DOCCT	CHAR	1	0	Reference document category
36	REFACTIV	REFGLVOR	CHAR4	CHAR	4	0	FI-SL Business Reference Transaction
37	CPUDT	CPUDT	DATUM	DATS	8	0	Accounting document entry date
38	CPUTM	CPUTM	UZEIT	TIMS	6	0	Time of data entry
39	USNAM	USNAM	XUBNAME	CHAR	12	0	User name	*
40	AWTYP	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
41	AWORG	AWORG	AWORG	CHAR	10	0	Reference organisational units
42	PMT_OFFICE	FMFG_PMT_OFF	FMFG_PMT_OFF	CHAR	5	0	Payment Office	*
43	COHORT	FM_COHORT	FM_COHORT	CHAR	4	0	Reporting Year for Cohort
44	PUBLAW	FM_PUBLAW	FM_PUBLAW	CHAR	20	0	Public Law Cited
45	LEGIS	FM_LEGIS	FM_LEGIS	CHAR	1	0	Type of Legislation
46	FLG_COVERED	FM_FLG_COVERED	FM_FLG_COVERED	CHAR	1	0	Covered Indicator
47	FLG_CUSTODIAL	FM_FLG_CUSTODIAL	FM_FLG_CUSTODIAL	CHAR	1	0	Custodial Indicator
48	FLG_ENTITY	FM_FLG_ENTITY	FM_FLG_ENTITY	CHAR	1	0	Entity Indicator
49	FLG_EXCHANGE	FM_FLG_EXCHANGE	FM_FLG_EXCHANGE	CHAR	1	0	Exchange Indicator
50	FLG_FEDERAL	FM_FLG_FEDERAL	FM_FLG_FEDERAL	CHAR	1	0	Federal Indicator
51	FLG_APPORT	FM_FLG_APPORT	FM_FLG_APPORT	CHAR	1	0	Apportionment Category
52	FLG_AVAIL	FM_FLG_AVAIL	FM_FLG_AVAIL	CHAR	1	0	Availability Time
53	FLG_BORROW	FM_FLG_BORROW	FM_FLG_BORROW	CHAR	1	0	Borrowing Source
54	FLG_DEFINITE	FM_FLG_DEFINITE	FM_FLG_DEFINITE	CHAR	1	0	Definite/Indef indicator
55	FLG_PARTNER	FM_FLG_PARTNER	FM_FLG_PARTNER	CHAR	1	0	Transaction Partner
56	FLG_REIMBUR	FM_FLG_REIMBUR	FM_FLG_REIMBUR	CHAR	1	0	Reimbursable
57	FLG_AUTHOR	FM_FLG_AUTHOR	FM_FLG_AUTHOR	CHAR	1	0	Authority Type
58	FLG_BEA	FM_FLG_BEA	FM_FLG_BEA	CHAR	1	0	BEA Category
59	BUREAU	FM_BUREAU	FM_BUREAU	CHAR	2	0	Federal Bureau
60	BUSINESS_LINE	FM_BUSINESS_LINE	FM_BUSINESS_LINE	CHAR	2	0	Business Line
61	FGDPRTMNT	FM_DEPARTMENT	FM_DEPARTMENT	CHAR	2	0	Federal Department
62	FGDPRTMNT_PART	FM_DEPARTMENT_PARTNER	FM_DEPARTMENT	CHAR	2	0	Federal Department Partner
63	FUND_ACC_SYMBL	FM_MAIN_ACCT	FM_MAIN_ACCT	CHAR	4	0	Treasury Account Symbol - Main Account
64	RWCUR	RWCUR	WAERS	CUKY	5	0	Currency key of the original transaction currency	*
65	AWID	AWID	AWID	CHAR	10	0	Reference document: Current identification
66	BELNR	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
67	BUZEI	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
68	LINETYPE	LINETYPE	LINETYPE	CHAR	5	0	Item category	*
69	XSPLITMOD	XSPLITMOD	XFELD	CHAR	1	0	Item changed by document splitting
70	FUND_TYPE	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	*
71	FM_AREA	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
72	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
73	XSKRL	XSKRL	XFELD	CHAR	1	0	Indicator: Line item not liable to cash discount?
74	CO_AREA	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
75	SGL_ACCOUNT	FM_SGL_ACCOUNT	FM_SGL_ACCOUNT	CHAR	4	0	SGL Account, US Federal Government
76	BDGT_FUNC_CLSS	FM_BDGT_FUNC_CLSS	CHAR3	CHAR	3	0	Classification of Data According to Major Purpose
77	FMCMMTSTR_9	FMCMMTSTR	FMCMMTSTR	CHAR	62	0	FM Commitment String For Budgetary Ledger
78	TRANSFER_AGCY_9	FMFG_TRANSFER_AGCY	FMFG_TRANSFER	CHAR	2	0	Transfer Agency	*
79	TRANSFER_ACCT_9	FMFG_TRANSFER_ACCT	FMFG_TRAN_ACCT	CHAR	4	0	Transfer Account	*
80	YEAR_BDGT_AUTH_9	FMFG_YR_BUD_AUTH	FMFG_YR_BUD_AUTH	CHAR	4	0	Year of Budget Authority
81	FLG_ADVANCE_9	FM_FLG_ADVANCE	FMFG_FLG_ADVANCE	CHAR	1	0	Advanced Flag
82	DEFENSE_INDIC_9	FMFG_DEFENSE_INDICATOR	FMFG_DEFENSE_INDICATOR	CHAR	3	0	Defense Indicator
83	MEASURE	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
84	XBLNR	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
85	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
86	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
87	PROG_REPT_CAT_9	FMFG_PROGRAM_REPORT_CATEGORY	FMFG_PROGRAM_REPORT_CATEGORY	CHAR	3	0	Program Reporting Category Posted
88	TIMESTAMP	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
89	VALUETYPE	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
90	CURTYPE	RSCURTYPE	RSCURTYPE	CHAR	2	0	Currency type
91	FISCPER	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
92	FISCVAR	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
93	CHARTACCTS	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
94	UPMOD	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
95	VALUTYP	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
96	CURRUNIT	RSCURRENCY	WAERS	CUKY	5	0	Currency Key	*
97	DEBIT	RR_UMSOL	WERTV9	CURR	17	2	Total debit postings
98	CREDIT	RR_UMHAB	WERTV9	CURR	17	2	Total credit postings
99	TURNOVER	RR_SALES	WERTV9	CURR	17	2	Sales of the period
100	PROG_REPT_CAT	FMFG_PROG_REPT_CAT	FMFG_PROGRAM_REPORT_CATEGORY	CHAR	3	0	Program Reporting Category
101	.INCLUDE				0	0	Additional Federal Government Reporting Attributes
102	FUNDINYEAR	FMFG_FUNDINYEAR	FMFG_YN	CHAR	1	0	Fund flagged to be used in fiscal year
103	FUNDEARMARKED	FMFG_FUNDEARMARKED	FMFG_YN	CHAR	1	0	Fund flagged as earmarked