SAP ABAP Table FMFGRPTADERIVE (Derivation Structure for additional Reporting Attributes)

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	FMFGRPTADERIVE	Table Relationship Diagram
Short Description	Derivation Structure for additional Reporting Attributes

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	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
2	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
3	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
4	RYEAR	☐	RYEAR	GJAHR	NUMC	4	0	Fiscal year
5	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
6	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
7	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	SBUKRS	☐	S_BUKRS	BUKRS	CHAR	4	0	Sender company code	T001
9	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
10	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
11	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
12	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
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)	PRPS
15	RORDNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
16	RVBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
17	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
18	RFUND	☐	FM_FUND	BP_GEBER	CHAR	10	0	Fund	*
19	FUND_TYPE	☐	FM_FUNDTYPE	FM_FUNDTYPE	CHAR	6	0	FM Fund Type	*
20	RFIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
21	RFISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
22	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
23	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	FMMEASURE
24	RFINUSE	☐	FM_FINUSE	FM_FINUSE	CHAR	16	0	Application of Secondary Source Funds	FMFUSE
25	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
26	BLSTATUS_9	☐	FMFG_BLSTATUS	FMFG_BLSTATUS	CHAR	5	0	Budgetary ledger status
27	.INCLUDE	☐				0	0	Other than FACTS1 and FACTS2
28	AGNCY_LCTN_CODE	☐	FMFG_ALC	FMFG_ALC	CHAR	8	0	Agency Location Code	FMFGT_ALC
29	SGL_ACCOUNT	☐	FM_SGL_ACCOUNT	FM_SGL_ACCOUNT	CHAR	4	0	SGL Account, US Federal Government
30	.INCLUDE	☐				0	0	Fields for US Federal government FACTS1
31	FLG_CUSTODIAL	☐	FM_FLG_CUSTODIAL	FM_FLG_CUSTODIAL	CHAR	1	0	Custodial Indicator
32	FLG_COVERED	☐	FM_FLG_COVERED	FM_FLG_COVERED	CHAR	1	0	Covered Indicator
33	FLG_ENTITY	☐	FM_FLG_ENTITY	FM_FLG_ENTITY	CHAR	1	0	Entity Indicator
34	FLG_EXCHANGE	☐	FM_FLG_EXCHANGE	FM_FLG_EXCHANGE	CHAR	1	0	Exchange Indicator
35	FLG_FEDERAL	☐	FM_FLG_FEDERAL	FM_FLG_FEDERAL	CHAR	1	0	Federal Indicator
36	BDGT_FUNC_CLSS	☐	FM_BDGT_FUNC_CLSS	CHAR3	CHAR	3	0	Classification of Data According to Major Purpose
37	BUREAU	☐	FM_BUREAU	FM_BUREAU	CHAR	2	0	Federal Bureau
38	BUSINESS_LINE	☐	FM_BUSINESS_LINE	FM_BUSINESS_LINE	CHAR	2	0	Business Line
39	FGDPRTMNT	☐	FM_DEPARTMENT	FM_DEPARTMENT	CHAR	2	0	Federal Department
40	FGDPRTMNT_PART	☐	FM_DEPARTMENT_PARTNER	FM_DEPARTMENT	CHAR	2	0	Federal Department Partner
41	FUND_ACC_SYMBL	☐	FM_MAIN_ACCT	FM_MAIN_ACCT	CHAR	4	0	Treasury Account Symbol - Main Account
42	.INCLUDE	☐				0	0	Fields for US Federal government FACTS2
43	FLG_DEFINITE	☐	FM_FLG_DEFINITE	FM_FLG_DEFINITE	CHAR	1	0	Definite/Indef indicator
44	FLG_APPORT	☐	FM_FLG_APPORT	FM_FLG_APPORT	CHAR	1	0	Apportionment Category
45	FLG_AVAIL	☐	FM_FLG_AVAIL	FM_FLG_AVAIL	CHAR	1	0	Availability Time
46	FLG_REIMBUR	☐	FM_FLG_REIMBUR	FM_FLG_REIMBUR	CHAR	1	0	Reimbursable
47	FLG_AUTHOR	☐	FM_FLG_AUTHOR	FM_FLG_AUTHOR	CHAR	1	0	Authority Type
48	FLG_BORROW	☐	FM_FLG_BORROW	FM_FLG_BORROW	CHAR	1	0	Borrowing Source
49	FLG_BEA	☐	FM_FLG_BEA	FM_FLG_BEA	CHAR	1	0	BEA Category
50	FLG_PARTNER	☐	FM_FLG_PARTNER	FM_FLG_PARTNER	CHAR	1	0	Transaction Partner
51	COHORT	☐	FM_COHORT	FM_COHORT	CHAR	4	0	Reporting Year for Cohort
52	PUBLAW	☐	FM_PUBLAW	FM_PUBLAW	CHAR	20	0	Public Law Cited
53	LEGIS	☐	FM_LEGIS	FM_LEGIS	CHAR	1	0	Type of Legislation
54	TRANSFER_AGCY_9	☐	FMFG_TRANSFER	FMFG_TRANSFER	CHAR	2	0	Transfer Agency	FMUSFGF2_TRANS
55	TRANSFER_ACCT_9	☐	FMFG_TRAN_ACCT	FMFG_TRAN_ACCT	CHAR	4	0	Transfer Account	FMUSFGF2_TRANS
56	YEAR_BDGT_AUTH_9	☐	FMFG_YR_BUD_AUTH	FMFG_YR_BUD_AUTH	CHAR	4	0	Year of Budget Authority
57	FLG_ADVANCE_9	☐	FMFG_FLG_ADVANCE	FMFG_FLG_ADVANCE	CHAR	1	0	Advanced Flag
58	DEFENSE_INDIC_9	☐	FMFG_DEFENSE_INDICATOR	FMFG_DEFENSE_INDICATOR	CHAR	3	0	Defense Indicator
59	PROG_REPT_CAT	☐	FMFG_PROGRAM_REPORT_CATEGORY	FMFG_PROGRAM_REPORT_CATEGORY	CHAR	3	0	Program Reporting Category Posted	FMFGF2PRC
60	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
61	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
62	FLG_PYA	☐	FMFG_FLG_PYA	FMFG_FLG_PYA	CHAR	1	0	Prior Year Adjustment flag
63	APPOR_CAT_B_DETAIL	☐	FMFG_APPORTDTL		CHAR	3	0	Apportionment Detail
64	APPOR_CAT_B_TXT	☐	FMFG_APPORTTEXT		CHAR	25	0	Apportionment Text
65	.INCLUDE	☐				0	0
66	RPTA_ADDIN	☐	FMFG_RPTA_ADDIN	FMFG_RPTA_ADDIN	CHAR	4	0	Include adding of additional reporting attributes
67	FREEUSE1	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
68	FREEUSE2	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
69	.INCLUDE	☐				0	0	Additional Federal Government Reporting Attributes
70	FUNDINYEAR	☐	FMFG_FUNDINYEAR	FMFG_YN	CHAR	1	0	Fund flagged to be used in fiscal year
71	FUNDEARMARKED	☐	FMFG_FUNDEARMARKED	FMFG_YN	CHAR	1	0	Fund flagged as earmarked

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMFGRPTADERIVE	AGNCY_LCTN_CODE	FMFGT_ALC	ALC
2	FMFGRPTADERIVE	CO_AREA	TKA01	KOKRS
3	FMFGRPTADERIVE	FM_AREA	FM01	FIKRS	REF	C	CN
4	FMFGRPTADERIVE	LOGSYS	TBDLS	LOGSYS	REF	C	CN
5	FMFGRPTADERIVE	MEASURE	FMMEASURE	MEASURE	REF	C	CN
6	FMFGRPTADERIVE	PROG_REPT_CAT	FMFGF2PRC	PROG_REPT_CAT
7	FMFGRPTADERIVE	RBUKRS	T001	BUKRS	KEY	1	CN
8	FMFGRPTADERIVE	RBUSA	TGSB	GSBER	REF	C	CN
9	FMFGRPTADERIVE	RFAREA	TFKB	FKBER	REF	C	CN
10	FMFGRPTADERIVE	RFINUSE	FMFUSE	FINUSE	REF	C	CN
11	FMFGRPTADERIVE	RLDNR	T881	RLDNR
12	FMFGRPTADERIVE	RPROJK	PRPS	PSPNR	REF	C	CN
13	FMFGRPTADERIVE	RTCUR	TCURC	WAERS	KEY	1	CN
14	FMFGRPTADERIVE	RVERS	T894	RVERS
15	FMFGRPTADERIVE	SBUKRS	T001	BUKRS	KEY	1	CN
16	FMFGRPTADERIVE	TRANSFER_ACCT_9	FMUSFGF2_TRANS	TRANSFER_ACCOUNT	KEY	1	CN
17	FMFGRPTADERIVE	TRANSFER_AGCY_9	FMUSFGF2_TRANS	TRANSFER_AGENCY	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in